Ideas to handle unhandled exceptions

[StephanieStrydo]

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
------------------------------

[devneetmohanty07]

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

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