I have a workflow that reads a fixed width CSV file into a ‘TempTable’ datatable ~1.3M lines. I then have a Case Switch which parses the data into 2 datatables. Both are then output into 2 Excel files. However during the parsing into the 2 datatables, when one of the datatables row count becomes > 650K the robot crashes. So it actually doesnt make it to the export stage of the process. If I stop the parsing process when the count reaches 650K it works, but if I change it to 700K it crashes before completing.
This should help you: UiPath robot stops working - #2 by Michael_Farough