Object

[MatteoPavone]

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

[RaúlHernández]

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

[MatteoPavone]

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

[NicholasZejdlik]

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

[MatteoPavone]

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

[NicholasZejdlik]

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

[RaúlHernández]

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