Hi there,
I have an error I've been trying to resolve for some time now and cannot seem to find the cause or resolution.
The error I am getting is "Exception has been thrown by the target of an invocation".
This is happening at the "Write Collection" stage.
Essentially what my process is doing is the Digital Worker is accession a web application (Chorus) and extracting comments from a list of work items. These comments that are extracted are saved to a collection.
When all of the items are completed I'm left with a collection of comments. This collection can have 1,000+ rows. The length of comments can vary.
When writing collection to the Excel file, it is failing.
Let me add that it does not always fail.
What I mean is that I will have 4 DW's running the same process and 1 of the 4 will fail with this error while the other 3 will be successful and I can see the report they've each generated.
It also isn't isolated to any 1 DW. DW 1 can work one time and another run it may be the one to fail.
I've looked this up extensively and also have a ticket open with support.
My recent thought was that the DW was maybe extracting a comment where the character count exceeds the max character count that can be written to Excel.
Excel has a max character count of 32,767 characters or around there.
To test this I manually added a comment to a work item of over 40,000 characters. If I read the comment I get all of the characters saved to my data item and collection but when I go to write my collection to Excel I see that it doesn't write all 40,000 characters. It just writes up to the most characters Excel can hold.
One thing to note is that while in Design Studio, if I manually add text to a data item, it can only hold up to 32,767 characters. It won't allow me to type any more. However if I read text and save it to a data item, it can hold more characters (ie: the 40,000).
I'm not sure if while running in production we'd get the same result.
Looking for any feedback or assistance here.
Thanks a lot,
