I am reading the excel data approx. 9000 records.
Bot is reading the excel and storing in out_DataTable argument. I am encountering below error.
RemoteException wrapping System.Exception: Could not retrieve the result of the job execution. This might be because a message was too large to process.
Please provide solution where I can store the large data and pass it to other workflows.
Attaching workflow for reference
PS_ReadExcelReport.xaml (16.7 KB)
Use read range from workbook. instead of using the Excel read range
Workbook Read range activity wont allow me to read csv file. I have a condition where bot may read .csv, .xlsx file
In this case we can do the following…
Assign StrFolderpath = "FolderPath\"
Assign ArrCSVFiles = Directory.GetFiles(StrFolderpath,"*.csv")
Assign ArrExcelFiles = Directory.GetFiles(StrFolderpath,"*.xlsx")
Take one for each and pass the ArrCSVFiles
Now use Read CSV and do the operations
Take one more for each and pass the ArrExcelFiles
Now inside the for each use Read range from workbook
It will read the both the files even if it is csv or excel
I tried the approach you suggested. But same error is getting thrown even after using read csv and read range (wb) activity.
This is basically due to the large data is passed to the out argument and uipath does not allow that.
Please let me know if you have any other alternative
Could you please show us the activity Where exactly we’re getting this error?
If we’re trying to display the data in writeline or message box or log message due to huge data. These activities can’t display the data…
Could you please see the output in text file? By using the write text file activity?
Attaching the xaml file.
PS_ReadExcelReport.xaml (18.0 KB)
Error is thrown at outer most scope while coming out of the workflow.
It is reading the data correct. But while passing that data table as out argument error is thrown.