topic RE: running process from command line in Product Forum

running process from command line

AlexanderFilip — Wed, 06 Nov 2019 07:28:00 GMT

Hello,
when I run my process from Control Room it works fine.
When I run it from command line with automateC.exe I got the following SqlConnection exception:

C:\Program Files\Blue Prism Limited\Blue Prism Automate>automateC /run HelloWorld /user admin BluePrism2019
Database error - Unable to determine whether database exists - The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.

I've also given all the required permissions to Administrative Tools -> Local Security Policy -> Local Policies -> User Rights Assignment -> Impersonate a client after athentication, but it is still not working.

Why is that if from the control room it works? What is the difference between automate and automateC ???

Thanks in advance,
Alex

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

jegendra — Mon, 11 Nov 2019 00:55:00 GMT

Hi Alex

Automate - GUI version of the Blue Prism application
AutomateC - Command-line version of Blue Prism application

Before executing the Blue Prism Process "HellowWorld" using the command automateC /run HelloWorld /user admin BluePrism2019,
you need to run the GUI version of the runtime resource or Interactive Client first.

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

RE: running process from command line

AlexanderFilip — Mon, 11 Nov 2019 15:59:00 GMT

Hello Jegendra,
thank you for your reply. With the GUI version my process works fine. No isuess at all. If I use the AutomateC it does not work.
Could you please help me?

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

jegendra — Wed, 13 Nov 2019 05:13:00 GMT

Hi Alex,

Please find the steps below to execute the process from command prompt

First command
automate /resourcepc /public /user admin BluePrism2019

Second command
automateC /run HelloWorld /user admin BluePrism2019

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

RE: running process from command line

AlexanderFilip — Wed, 13 Nov 2019 14:47:00 GMT

Hello Jegendra,
thank you for your suggestion but I tried and it didn't work. I'm attaching the output.
Whate else can I do?

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

DiogoFurlan — Thu, 14 Nov 2019 14:19:00 GMT

Hello, Alexasander

You can try specifing the connection name with the following parameter.
Something like: automate /resourcepc /public /user admin BluePrism2019 /dbconname "Connection Name"

Cheers

------------------------------
Diogo Furlan
Analyst
Grupo NC
America/Sao_Paulo
------------------------------

RE: running process from command line

AlexanderFilip — Fri, 15 Nov 2019 10:35:00 GMT

Thank you Diogo,
I've tried but same error unfortunately.
What else could be done?

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

vivek.kumar.goel — Mon, 18 Nov 2019 03:55:00 GMT

If your Blue Prism instance connected via SSO? If yes, you need to open MSDOS as that user and then try. Please also note that you may want to include the resource switch if you are trying to run it on different machine
If your BP instance is having local users (for example admin), then you may want to include /user and password switches.

------------------------------
Vivek Goel
RPA Architect
Avanade
Asia/Singapore
------------------------------

RE: running process from command line

AlexanderFilip — Mon, 18 Nov 2019 11:32:00 GMT

Thanks Vivekbut I've already did all those tryies: msdos open both with my user and both with admin.
I'm trying to run it on my machine and I always specify /user admin password
What else could be done?

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

vivek.kumar.goel — Wed, 20 Nov 2019 04:22:00 GMT

Open Blue Prism , Login to BP...

And then try running the simple command

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

RE: running process from command line

AlexanderFilip — Sat, 23 Nov 2019 08:25:00 GMT

Thanks a lot Vivek, but I've already tried this in my previous posts and it didn't work, you can see the screenshots in the thread history 😞

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

ewilson — Sun, 24 Nov 2019 13:42:00 GMT

Can you verify whether the file Automate.config exists in the folder C:\ProgramData\Blue Prism Limited\Automate V3?

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: running process from command line

AlexanderFilip — Fri, 29 Nov 2019 14:21:00 GMT

Hello Eric,
yes, it exists, this is its content:

<?xml version="1.0" encoding="utf-8"?>
<config>
<configuration>

<configSections>

</configSections>

</configuration>
<editsummariesarecompulsory>True</editsummariesarecompulsory>
<startprocessengine>True</startprocessengine>
<maxundolevels>10</maxundolevels>
<currentconnection>LocalDB</currentconnection>
<sqlcommandtimeout>30</sqlcommandtimeout>
<databaseinstallcommandtimeout>15</databaseinstallcommandtimeout>
<datapipelinecommandsendtimeout>3</datapipelinecommandsendtimeout>
<archivepath>C:\Users\alexander.filip\Documents</archivepath>
<connections>
<connection>
<name>LocalDB</name>
<server>(LocalDB)\BluePrismLocalDB</server>
<dbname>BluePrism</dbname>
<databasefilepath>C:\Users\alexander.filip\AppData\Local\Blue Prism Limited\databases\BluePrism.mdf</databasefilepath>
<user>test</user>
<password enc="true">
<secstr obf="BluePrism.Common.Security.EncryptingObfuscator" enc="edlYjBuk12cj9jKZB0g/Kw==:YqxpOgCpjg9PuaGZuagdxg==" />
</password>
<extraparams>TrustServerCertificate=true;</extraparams>
</connection>
</connections>
<businessobjects />
</config>

Thanks,
Alex

------------------------------
Alexander Filip
------------------------------

RE: running process from command line

ArunPandiyan1 — Sun, 27 Dec 2020 12:49:00 GMT

Did someone get the solution? Am facing the same issue. But not the database error. Facing "unable to connect to resource PC" error. And the process can be triggered by the control room.

------------------------------
Arun Pandiyan
------------------------------