Bot throwing error at the end of workflow after reading large data in excel

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)

Hey!

Use read range from workbook. instead of using the Excel read range

Regards,
NaNi

Hello @THIRU_NANI

Workbook Read range activity wont allow me to read csv file. I have a condition where bot may read .csv, .xlsx file

Regards,
Rushikesh

Hey!

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

That’s it…

It will read the both the files even if it is csv or excel

Regards,
NaNi

@THIRU_NANI

I tried the approach you suggested. But same error is getting thrown even after using read csv and read range (wb) activity.

image

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

Thanks,
Rushikesh

Hey!

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?

Regards,
NaNi

@THIRU_NANI

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.

Regards
Rushikesh