Process stopped due to unexpected error

Help
1

Hi,

I’m reading excel file and converting it to text format and uploading in webportal.
While iteration second time robot process stopping due to unexpected error
Version-2018.1
Please suggest any work around

2

Hi,

Can you share the workflow?

3

@Manoj_Batra:sorry I cannot share the workflow. since it is client machine

but I’m using linq to convert 30000 excel line item to text format. will that cause this issue

4

You dont need to do all manually we have activity called output datatable once you read excel give that Data table as input for output data table and it will return you string and you can write then to other files.

1 Like
5

Yes, but it I need to convert excel value into text tab delimit where output datatable will not generate even replacing comma (“,”,“”) doesn’t give the expected result

6

Once you have string then explicitly String manipulations.

7

can you share only the piece of code where the exception is occurring. I need to replicate it on my machine to know the exact error that is causing this issue. it would be hard to tell the exact solution or if you can share the complete error that is coming while execution, this would be a great help to solve this.

8

i havent tried it in that way but linq seems better for me.
so linq make process to stop…any idea?

9

Thanks for your response.
Bot will read mail and save excel file(2mb) and convert it to text format and upload in portal
Here one portal will take 5-10 mins load.until bot wait once get upload status complete…it will move on to next attachment
While moving second attachment i’m getting this error

10

Error