Question
areteans technology solutions pvt ltd
IN
Last activity: 2 Jan 2020 14:41 EST
Excel connector save issue in pega robotics insert bulk records
Hi Team,
I get the data from web application and form that data into and finally insert datarow into excel sheet.
i am using excel connector to insert data row into excel sheet.
after insert some records robots thrown an error to save the excel.
but if i work with same thing in oledb connector its doesnt create any pblm.
i am currentlu using office 365
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
Please provide some more information about your issue. Can you attach an example solution? If not, can you provide a screenshot of your automation? Can you provide details of the error? Preferably the message from the RuntimeLog.
areteans technology solutions pvt ltd
IN
i am using for loop to save the excel using 3 times retry option.but rare situation the automaion saving excel thrown error,
is there any issue with using saved event or sleep?.
areteans technology solutions pvt ltd
IN
i am using for loop to save the excel using 3 times retry option.but rare situation the automaion saving excel thrown error,
is there any issue with using saved event or sleep?.
Pegasystems Inc.
US
I don't believe you need to save it that often. What is the error you are getting? I assume something about the file being in-use.
Pegasystems Inc.
US
When I just tested this, I found that the Save method is synchronous; meaning it won't return until the save is complete. I think the event you are waiting for seems to fire ave is invoked. I would just call Save and then continue after that method. You shouldn't need a loop as one save is sufficient.