topic Re: Extended Excel VBO error in Control Room and Scheduler in Product Forum

Extended Excel VBO error in Control Room and Scheduler

NickiKristensen — Thu, 12 Dec 2019 10:31:00 GMT

Hi all,

We have a problem with our Extended Excel VBO, but only when running a process containing it is running in Control Room or Scheduler.
If we run the process in Process Studio, no problems what so ever.
We receive the following error: "ERROR: Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation."

I have tried following this help article as well as this but to no avail.

Have anyone found a solution to this issue? We are running on Windows Server 2016, display language English, but the location is Danish.
I have changed the "Language for non-Unicode programs" to English, but still no luck.

Thanks in advance

------------------------------
Nicki Kristensen
RPA Developer
IBC International Business College
------------------------------

RE: Extended Excel VBO error in Control Room and Scheduler

AndreyKudinov — Thu, 12 Dec 2019 14:58:00 GMT

I assuming you are testing on the same PC/VM, right?
Could you post a code that doesn't work? If any action crashes, then it could be something in init code - if you simply open VBO and run it's action, then init stage won't run.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Extended Excel VBO error in Control Room and Scheduler

GopalBhaire — Fri, 13 Dec 2019 06:51:00 GMT

Try repairing the Office installation.

Also instead of adding code stage on initialize page, can you try modifying the culture in Global Code (Although it is similar)

Dim culture = New Globalization.CultureInfo("en-US", True)

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

RE: Extended Excel VBO error in Control Room and Scheduler

NickiKristensen — Fri, 13 Dec 2019 07:14:00 GMT

Hi Andrey,
I'm using the same VM when testing the scheduler and when using Process Studio directly.
When running the actions manually in Object Studio (including Initialise), I encounter no problems.

------------------------------
Nicki Kristensen
RPA Developer
IBC International Business College
------------------------------

RE: Extended Excel VBO error in Control Room and Scheduler

NickiKristensen — Fri, 13 Dec 2019 07:18:00 GMT

Hi Gobal,

I will try repairing Office.

I don't have the section in Global Code that you're mentioning, am I supposed to add it manually? In that case where?

------------------------------
Nicki Kristensen
RPA Developer
IBC International Business College
------------------------------

RE: Extended Excel VBO error in Control Room and Scheduler

GopalBhaire — Fri, 13 Dec 2019 07:49:00 GMT

It's present on line 615 Dim culture = Thread.CurrentThread.CurrentCulture just replace it with Dim culture = New Globalization.CultureInfo("en-US", True)

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

RE: Extended Excel VBO error in Control Room and Scheduler

NickiKristensen — Fri, 13 Dec 2019 09:07:00 GMT

I have tried both suggestions now, still no luck 😞

------------------------------
Nicki Kristensen
RPA Developer
IBC International Business College
------------------------------

Re: Extended Excel VBO error in Control Room and Scheduler

GabrieleRodono — Thu, 18 Apr 2024 09:59:27 GMT

Hi all,

I have the same problem reported in the thread (Excel VBO actions work in debug, but not executing from Control Room or Scheduling). I have already tried the proposed solutions but none of them solved the issue.

Are there any new solutions that have resulted in solving the issue?

Thanks in advance.