I am getting “Message: Could not retrieve the result of the job execution. This might be because a message was too large to process.
Exception Type: System.Exception” from Read Range activity.
I have an excel file that contains a data with 1000+ rows, and 30-40 columns. I need to retrieve this dataTable, and have to process it. So I am first using Read Range activity.
But it gives the error written above! I have never seen this error before, and google search didn’t really get me anywhere to solve this problem… What is worse, I put the Read Range inside a Try Catch, but it is not catching this error!
I have a Message Box inside Catch, but it doesn’t print that. Instead, it just stops the execution!
Hi buddy
This error is due to a text written to console like using message box or write line activity
if any such activity is used kindly remove them and run once
this error doesn’t occur due to Read range
for more info on this
Kindly check this once and let know buddy
You were almost done
Cheers @tomato25
Actually I am not using anything else other than Read Range activity.
What is weird is, this progress runs successfully. After the execution, the error is thrown!
@tomato25 Are you running this from Orchestrator and/or writing anything to console? Have attached a sample workflow that reads an excel and gives the count of rows