Ideas to handle unhandled exceptions

StephanieStrydom — Mon, 27 Jun 2022 07:53:00 GMT

Hi, we often build processes that run macros or interact with Adobe Acrobat. I find that this is where my processes break, once it handed over control to the other application - the macro hangs for some system reason (like RPC server unavailable) and then it has no way of returning to Blue Prism to mark the item as exception. Do you have any ideas how to handle these type of issues?

------------------------------
Stephanie Strydom
------------------------------

RE: Ideas to handle unhandled exceptions

devneetmohanty07 — Mon, 27 Jun 2022 08:01:00 GMT

Hi Stephanie,

This likely will happen as when you call Macros they run on the same thread as Blue Prism. So if any popup will appear then your bot execution will also stop. The ideal way to handle such issues is at the Macro end such that you create a function which returns some error message via Error Handling to resolve those popups back to Blue Prism in order to figure what the issue was at Blue Prism end and you can then take the necessary steps.

The other thing which you can try is to go with the latest Excel business object at DX Exchange: MS Excel Extended

Here you can use one of the action called as 'Run Macro With Parallel Thread' that basically runs the macro code as a separate thread call instead preventing your bot execution to get halted. Below is the sample action:

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

topic RE: Ideas to handle unhandled exceptions in Product Forum

Ideas to handle unhandled exceptions

RE: Ideas to handle unhandled exceptions