I am facing same error when loading excel file with data of 54K rows and column till - FD.
This is not the file issue.
Till now it is looks like UiPath limitation of not loading large excel file. This is a show stopper for our project now which I am working.
I have written a C# application to read the same file and loadinf data to datatable which is working fine.
I am getting “UiPath robot stopped unexpectedly” from the Connect Activity when i am establishing connection to the input excel file. I have my input excel file and UiPath Studio in the local environment. But the application I am working on is inside Citrix.
Sure. Please find the attachment. I have my Connect activity in the Retry scope. I have used disconnect activity at the end of the process which i haven’t shared here. The error is arising only from the Connect activity when i tried debugging.
Hi, I have already tried this. My machine is not connected with the orchestrator. The Bot tends to run sometimes and sometimes it randomly fails at a particular step, without logging any error/ exception.
I have also tried splitting the step in submodule and marking activities/invoke as private. It also didn’t work.
The link I sent you actually contained an error, wcf is not the channel between robot and orchestrator, it’s the channel between robot service and executor. It was fixed now.
Is there anything logged, when the job fails, in event viewer ?
Can you enable low level logging (cmd > UiRobot.exe --enableLowLevel), try to make the flow fail again and see what is logged in event viewer ?
Hey andreiT I am unable to find the maxReceivedMessageSize in my UiPath.Service.Host.exe.config file. I am running 2020.4.1 sutdio. Would the version of my studio affect where the maxReceivedMessageSize would be?
That is correct, in 2020.4.1 we are using another custom channel to communicate between processes, not WCF, so that option is not longer present.
Do you have problems processing a large file ? Can you explain your problem in more detail ?
Yes I am unable to open a .csv file that is ~100 KB in size. but when I convert the file to xlsx I am able to. I was hoping that resizing the maxRecievedMessageSize would fix this. Would you have any other suggestion?
100KB is small actually. Even the old WCF channel would not have trouble with it.
I think the problem has another root cause, maybe the CSV extension itself. Or maybe the activity you are using does not allow opening of CSV files.
Can you post the actual error? Maybe we can pin point the error origin.