Hi Guys, I am having a reoccurring issue with this error. It keeps appearing after it has already completed the activity. I have updated Excel packages and it is still happening.
I’ve got 3 copy and pastes in a row, I have put a try catch in the first one and that works but I would rather figure why this is happening than use try-catches throughout.
For ref this is the activity:
Hi @Rebecca_9
You might be using a single Excel Process Scope activity for both Use Excel File activities. It is recommended to use a separate Excel Process Scope for each Use Excel File activity to avoid this exception.
Hope it helps!!
on a general note can you confirm if the roews specified and the sheets are present or is it creating the sheet1?
generally this 3EC error occurs when something that you are trying to search is not found
also as multiple excels are involved check the below settings in excel process scope
cheers
Hi I have added another Excel process scope and still no luck. It is completing the activity but then failing prior to moving onto next activity so I cant understand why I am getting the error if it is completing it first. Thank you though.
Hi, No not creating new sheets, Sheet names already created. Excel file, Sheet and range documented in activity - all match.
The issue is that it is completing the activity and then erroring after it has already done what it should have done, which is why I cant understand why its not just moving onto next activity.
Hi @Rebeca_Alguacil,
This happens due to Excel timing and COM sync issues. Even though the Copy/Paste activity completes, Excel is still processing when the next one starts, which causes the error. Add a short Delay between consecutive copy/paste actions, verify the ranges are valid and not overlapping, or replace multiple copy/paste steps with a single Read Range and Write Range. This is not a package issue but an Excel synchronization problem.
Thanks
It checks whether the row count matches between the source and the destination. If they do not match, an exception will be thrown.
In the screenshot you shared, the source starts from D1, while the destination starts from D2, so they do not match.
Hope you understand!!
in source try giving D2 instead of D1 and then check
then you need not select remove headers also
cheers
Could this still be the issue if it is completing the task though. The activity works as it should and copies and pastes the data and only fails after it has completed it?
If I do this will it overwrite the headers in the second document though?
Also it is completing the activity correctly so would this not cause a failure prior to completing instead of after?
it might not..
you can change and try it..thats the best way to find it
also headers would be in first row anyways and in copy itself if we remove then then ideally it should not be an issue
cheers
