Hello.
I am trying to build the automation to get spreadsheet from SAP through UiPath. however, since the data itself is so huge that data transferring get crashed and permanently loading, which unable me to either use SAP or check sap staus by using read sap status bar activity.
Anyone has the same issue and have a solution to this?
Thank you for your assistance.
Can you please elaborate
you mean when you open a report in sap it opens in excel and youa re trying to get the data from there?
if so first try to save the excel and then read
cheers
Add some delay before of the read sap status bar activity and check whether it works or not.
When i faced this problem i added some delay and it worked for me
Try exporting data in smaller batches/date ranges, increase timeouts, and wait for the output file creation instead of relying on SAP UI activities during the export
There are chances that the data might be huge so selecting data in batches as suggested and download the same can help. Try to download in .csv instead of .xlsx
If this does not work, check with your team internally if you have scope to use SAP BAPI tables. If you can get those data using SAP BAPI then you can save a lot of time and also can extract accurate data.
We too had faced this issue , what you need to do is process the data in batches. Export a set of records, then check if you have reached the last page or the last row. If not, continue with the next batch.
This approach helps avoid SAP timeouts and works better when dealing with large amounts of data.