topic RE: Automate.exe Crashes when using Run Macro in Product Forum

Automate.exe Crashes when using Run Macro

Siva_Ramakrishn — Mon, 17 May 2021 06:02:00 GMT

Automate.exe getting crashed intermittently on Runtime resource while using Run Macro action.

I have tried both MS Excel VBO and MS Excel Extended VBO still facing the same issue.

I am not able to figure out the issue as this is happening intermittently.

I am using Version 6.7.

Any leads or inputs would be appreciated.

Thanks in advance.

------------------------------
Siva Ramakrishna
------------------------------

RE: Automate.exe Crashes when using Run Macro

michaeloneil — Mon, 17 May 2021 07:10:00 GMT

Hi

Can you post the error message you are getting when this crashes?

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Automate.exe Crashes when using Run Macro

henrynli — Mon, 17 May 2021 07:51:00 GMT

Hi Siva,

Not sure if you took reference to KB article : https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Studio/Code-Stages/1158824822/How-do-I-fix-error-Exception-has-been-thrown-by-the-target-of-an-invocation-when-running-a-Process.htm

If that doesnt help, share with us the error details so people experienced the same issue could jump in and help.
Thks,

------------------------------
Henry Li
------------------------------

RE: Automate.exe Crashes when using Run Macro

Siva_Ramakrishn — Mon, 17 May 2021 08:00:00 GMT

There is no error message, Automate.exe on Runtime Resource is just getting killed.

In Control Room Runtime Resource status shows as disconnected.

------------------------------
Siva Ramakrishna Mangisetty
------------------------------

RE: Automate.exe Crashes when using Run Macro

Siva_Ramakrishn — Mon, 17 May 2021 08:02:00 GMT

Hi Henry,

Thanks for the link and that not what I am looking for.

There is no error message, Automate.exe on Runtime Resource is just getting killed. This is happening intermittently but not every time I run the process.

In Control Room Runtime Resource status shows as disconnected.

------------------------------
Siva Ramakrishna Mangisetty
------------------------------

RE: Automate.exe Crashes when using Run Macro

GopalBhaire — Mon, 17 May 2021 08:03:00 GMT

Hi Siva,

Can you check the logs in Event Viewer?

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Automate.exe Crashes when using Run Macro

michaeloneil — Mon, 17 May 2021 09:17:00 GMT

Hi

Sorry I meant check the logs for any errors when the process was running. Can you also tell us what your macro is trying to do? My suspicion is that the listener on your machine is sitting in the forefront of your screen in front of the application you are trying to interact with and that the macro is actually closing it because its selecting the listener when executing the actions.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Automate.exe Crashes when using Run Macro

Siva_Ramakrishn — Mon, 17 May 2021 09:32:00 GMT

HI Michael,

There is no error in the log. I have attached the Flow of the code and log file, it runs till 'Write to Clipboard' action according to logs and that's it. Run Macro is where the issue is.

My Macro deals with only Excel files which operated in background, It is not interacting with any forefront application, I believe Macro is not closing listener.

Thanks,

------------------------------
Siva Ramakrishna Mangisetty
------------------------------

RE: Automate.exe Crashes when using Run Macro

michaeloneil — Mon, 17 May 2021 09:55:00 GMT

Ah ok it could be that this macro needs the application open depending on what its doing and how its been written. Have you tried adding a 'Show' stage and running the process again? It might yield the same result but best to rule out all possibilities.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Automate.exe Crashes when using Run Macro

Siva_Ramakrishn — Mon, 17 May 2021 10:05:00 GMT

I tried that as well but no luck

------------------------------
Siva Ramakrishna Mangisetty
------------------------------

RE: Automate.exe Crashes when using Run Macro

michaeloneil — Mon, 17 May 2021 10:26:00 GMT

can you share the vba macro code? There might be something in there that gives a clue of what could be causing it.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------