topic RE: Exception Handling in Product Forum

Exception Handling

ShraddhaPavagi2 — Sat, 10 Oct 2020 19:11:00 GMT

Hi All,

I am getting below exception while executing the code.

Could not execute code stage because exception thrown by code stage: The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))

Can any one please tell why I am getting this type exception and how to resolve it.

------------------------------
Shraddha Pavagi
------------------------------

RE: Exception Handling

hossein.azimi — Sat, 10 Oct 2020 23:29:00 GMT

Hi Shraddha

This is a Microsoft error and is not related to Blue Prism The error usually occurs when MS Excel is not ready to handle your call (for example, if the user is busy editing a cell or pressing the mouse button).

The following two threads on the Microsoft forum may help you to address this error:

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------

RE: Exception Handling

ShraddhaPavagi2 — Mon, 12 Oct 2020 07:52:00 GMT

Thanks a lot.

------------------------------
Shraddha Pavagi
------------------------------

RE: Exception Handling

UAMUSIIOIR — Tue, 20 Apr 2021 16:23:00 GMT

Hi everyone.

My solution was very simple.
I found the core of the problem: the Excel setting. If you have some information that updates while the opening - switch it off.
Example: Pivot Table. Do not allow to refresh data while opening Excel.

------------------------------
Iryna Musiiovska
------------------------------

RE: Exception Handling

TheodorosPapaso — Wed, 02 Jun 2021 10:56:00 GMT

Hi Iryna,

I came across the same error while I'm using the Open Workbook in Blue Prism MS Excel VBO-Extended. This happens because excel contains pivot tables, where 'refresh data when opening the file' is checked (in Pivot table's options). However I can't change it to false programmatically in Blue Prism before using the Open Workbook. Did you manage to solve this one?

Thanks,
Theo

------------------------------
Theodoros Papasotiriou
------------------------------