running process from command line

[AlexanderFilip]

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

[AlexanderFilip]

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

[ewilson]

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

[AlexanderFilip]

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

[ArunPandiyan1]

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