Timeout issue with "Use Excel File" Activity while working with SAP Addon in Excel

Help Activities
, ,
1

I am working with an Excel file which has an integrated SAP Addon to connect with SAP Database and fetch data into excel via logging into Credentials. I am automating the steps to enter the SAP Logon credentials which we get via a popup when we open the excel file. I am using Excel process scope and then “Use excel file” for the same. I am using Launch Method as “Application” since I need to automate the screens and popups of the SAP Login in the excel file opened as if I select “Automation”, the excel opens without the SAP Addon and i didnt get the Popup. The issue I am facing is when the bot is running in unattended mode everytime, the activity “User excel file” is executed and bot opens the excel file. The SAP popup appears but the UiPath stops at the point. It doesnt proceed or timeout. Although the “Process scope” has a default timeout of 20 seconds, it still shows running for more than 20 hrs. I have tried delays, kill excel but I am not sure why the “use excel file” stops there and doesnt proceed to look for the SAP Popup and continue. Can Anyone please help.

image
image1149×649 52.6 KB

This image is shows the excel file which when opened manually or through bot, shows the popup. the bot needs to enter the credentials.

image
image1441×513 35.5 KB

This image shows the code. i am using Process excel scope and Launch method is Application

image
image1073×588 37 KB

This image shows the “User excel file” code. The bot doesnt even execute the log message activity highlighted. It is just stuck.
I request the community to please share the solution as I have tried all possible solutions which i know.

2

Hi,

Can you try to use Parallel activity and InvokeWorkflowFile activity with Isolated option as the following post?

Regards,

3

Apologies @Yoichi …could you be please more specific…I am not able to relate to the other post shared.
Thankyou

4

Hi,

Can you try as the following?

First, put Parallel activity then put InvokeWorkflow file activity with Isolated option in Left lane and put UseExcelFile ion Right lane.

image
image1282×641 46.5 KB

In callee workflow (Let’s say Sequence.xaml) , put UseApplication/Browser,TypeInto and Click for inputting information into SAP addin dialog.

Regards,

5

Hi @Yoichi ,
it didnt work…i tried as mentioned. I separated the SAP login sequence into a separate Isolated wf and launched my excel file in parallel as shown. The issue again came with “Use excel file:could not execute the operation within the allotted time”.
Also, in the use excel file flow, there are steps which needs to be done after “Logging into SAP”. Since Logging into SAP and Use excel file are in Parallel activity, sometimes the excel flow continues to perform the steps mentioned in Use excel file flow and fails.
I request if yoy have any other way to resolve.

6

Hi, I am also facing this error “Use Excel File: Could not execute the operation within the allotted time.”

In my case I am using this to create a pivot table. But I am getting this error not every time but randomly. These are my properties:

for excel scope:

image
image447×563 64.3 KB

for use excel:

image
image449×557 44.3 KB

@Yoichi Any insights on this?

7

I had the same issue and couldn’t figure out a way to solve it with UiPath. What I did is, I unset the “refresh workbook on opening”, then there won’t be the logon prompt on startup.

You can do this by opening the file, then go to Analysis Design → Design Panel → Display. Then there will be a popup. Go to tab Components and uncheck “Refresh Workbook on Opening”. Save and then there won’t be a logon dialog when opening the file again.