topic RE: Object in Product Forum

Object

MatteoPavone — Thu, 07 May 2020 17:29:00 GMT

Hi!
I'm trying to launch a process from cmd, I use the action "Start Process" in the vbo utility. I insert the path where I find the cmd.exe and write an argument but the process doesn't recognize it, i.e. it opens a cmd window without argument.
Can someone help me? I hope I've been clear.
Thanks

------------------------------
MatP
------------------------------

RE: Object

RaúlHernández — Fri, 08 May 2020 04:46:00 GMT

Hi, Matteo.

You can try to write a .bat file to start your process from CMD and make sure it works manually.

Then you can use blue prism to start this .bat file.

Best regards.

------Original Message------

Hi!
I'm trying to launch a process from cmd, I use the action "Start Process" in the vbo utility. I insert the path where I find the cmd.exe and write an argument but the process doesn't recognize it, i.e. it opens a cmd window without argument.
Can someone help me? I hope I've been clear.
Thanks

------------------------------
MatP
------------------------------

RE: Object

MatteoPavone — Fri, 08 May 2020 08:14:00 GMT

Hi Raul!
Thanks for your answer!
So I write the .bat file and then I use "Start Process" with "cmd.exe" and argument the path of the .bat file right?

Thanks again
Matteo

------------------------------
Matteo Pavone
------------------------------

RE: Object

NicholasZejdlik — Fri, 08 May 2020 13:38:00 GMT

You can call the batch file directly with Start Process. Also, the way to call command prompt directly and have it execute a command would be like so:
cmd.exe /K ping google.com

Depending on the commands you are executing, you can also call the command directly from Start Process. In the example above, you could call Ping from Start Process.

Also, if you need to read the output of a process, it is possible, though you would need to write your own code stage to do it. There's a StackOverflow post describing how to it, in case you need it.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: Object

MatteoPavone — Fri, 08 May 2020 14:35:00 GMT

Essentially I need to run cmd and relative arguments to run a query because when I use the object "get collection" I had a memory problem (System. OutOfMemoryException)

------------------------------
Matteo Pavone
------------------------------

RE: Object

NicholasZejdlik — Fri, 08 May 2020 20:20:00 GMT

I've noted that Blue Prism tends to make several copies of a collection, at least version 5 does, whenever you pass it as input or receive in the output. Each action seems to create its own copy of the collection. Normally this is not an issue for most things, but on large data sets that can rapidly become a problem. One solution in your case might be to create your own code stage to pull the collection from SQL and manipulate it from within the same code stage rather than output the collection back to Blue Prism. It's not the ideal solution, but it might be easier than calling up command line.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: Object

RaúlHernández — Sat, 09 May 2020 04:10:00 GMT

Yes, Matteo Pavone.

You can first write you .bat file to execute the cmd.exe and all the commands you need. But make sure this .bat file works fine by double clicking it.

After that, you can use blue prism to start the .bat file.

------Original Message------

I've noted that Blue Prism tends to make several copies of a collection, at least version 5 does, whenever you pass it as input or receive in the output. Each action seems to create its own copy of the collection. Normally this is not an issue for most things, but on large data sets that can rapidly become a problem. One solution in your case might be to create your own code stage to pull the collection from SQL and manipulate it from within the same code stage rather than output the collection back to Blue Prism. It's not the ideal solution, but it might be easier than calling up command line.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------