topic What VBO and Actions are you… in Product Forum

Internal : Could not execute code stage because exception thrown by code stage: Value cannot be null. Parameter name: s

RichardLoughins — Fri, 10 Aug 2018 18:06:00 GMT

I'm trying to get a worksheet as a collection, but whenever I run the action, I get the following error: "Internal : Could not execute code stage because exception thrown by code stage: Value cannot be null. Parameter name: s" Has anyone come across this before and know how to resolve it? I've used this action countless times before and never came across this error. In fact, the first couple of times that I used it on this particular process it worked fine, but has only now stopped working, even though nothing has changed.

What VBO and Actions are you…

AlexanderPugh — Fri, 17 Aug 2018 21:52:00 GMT

What VBO and Actions are you using? What inputs are you passing in? If it's the provided MS Excel VBO, have you made any changes to it? Have you changed anything in the Resource environment? I've had no end of trouble using the MS Excel VBO and have just wholesale rebuilt it. However, if I'm merely getting data out or putting data in an Excel Worksheet I always just use the OLEDB VBO. Its much much more stable.

RE: Internal : Could not execute code stage because exception thrown by code stage: Value cannot be null. Parameter name: s

IanBlackburn1 — Wed, 07 Aug 2019 09:57:00 GMT

We're getting the same issue. Works fine for some case but occasionally throws this out. We've tried adding wait stages thinking it was a response issue but that's not had any impact, though some instances it does it does work for, so try that. If anyone as any other ideas please let me know.

------------------------------
Ian Blackburn
Head of Intelligent Automation
Opus Energy
Europe/London
------------------------------

RE: Internal : Could not execute code stage because exception thrown by code stage: Value cannot be null. Parameter name: s

tjunicho — Wed, 07 Aug 2019 10:04:00 GMT

Hi,

It could occur when another user/resource is using the clipboard at the same time that the action runs.
https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Application-Integration/EXCEL/1323720772/Why-do-I-get-Value-cannot-be-null-Parameter-name-s-error-when-using-the-MS-Excel-VBO.htm

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------

RE: Internal : Could not execute code stage because exception thrown by code stage: Value cannot be null. Parameter name: s

CrystalWohead — Fri, 11 Sep 2020 22:34:00 GMT

Were you able to find a resolution for your issue? I'm experiencing the same and looking for some input.

------------------------------
Manager Accounting Projects
Ulta Beauty
------------------------------