AutomateC "database connection string not complete"

[AlexanderFilip]

Hello,
it's 4 hours I'm stuck with this error: automateC doesn't work, it tells me "database connection string not complete" ... plase is there someone that could help me?
I've tried everytihng to solve it but notihng...I've even edited the automateC.exe.config....

Thanks
Alexander

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

[james.man]

Have you verified that the database connection and "Test Connection" button in the graphical interface work correctly?  I'd try to debug it form the GUI first before trying to use the command line command.  If you could show a screen capture of your connection details, it would help people in diagnosing the issue you have.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

[AlexanderFilip]

Thank you James, these are all the screenshots: DB Test is OK, running process from Control Room is OK, running it from AutomateC has strange error....

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

[james.man]

Can you try specifying the specific connection name that you want to use in your command?  For example:

automatec.exe /run "HelloWorld" /user admin BluePrism2019 /dbconname "LocalDB"



------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

[AlexanderFilip]

Yes, I tried but I get this. there should be a solution...I kindly ask for your help 😞

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

[james.man]

Something is definitely off if the connection "LocalDB" is not found, as it is the same connection name that exists in the screenshot that you showed.  

I would double check the Blue Prism configuration file to see if the "LocalDB" connection information is saved inside there.  The location of the file is by default located at:

C:\ProgramData\Blue Prism Limited\Automate V3\Automate.xml. 

Note that you may need to copy paste "C:\ProgramData\Blue Prism Limited\Automate V3" into Windows Explorer to see the folder, as "ProgramData" is a hidden folder by default.  Double check to make sure that there is an entry for LocalDB as a "connection", for example:

<connections>
  ...
  <connection>
    <name>LocalDB</name>
    ...
    ...
  </connection>
  ...
</connections>

Another thing that you can try is to start your command prompt using administrator privileges.  Perhaps it's the case that your command prompt is unable to read the XML configuration file above, and thus cannot read the connection details that it needs to run a process.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------

[AlexanderFilip]

Hello James, thanks a lot for the suggestions, but.. 😞
I didn't find the file Automate.xml in the folder path you've mentioned. But I've found a file Automate.config in the path: 
C:\Users\alexander.filip\AppData\Roaming\Blue Prism Limited\Automate V3
This is the content:

<?xml version="1.0" encoding="utf-8"?>
<config>
<editsummariesarecompulsory>True</editsummariesarecompulsory>
<startprocessengine>True</startprocessengine>
<maxundolevels>10</maxundolevels>
<currentconnection>
</currentconnection>
<sqlcommandtimeout>30</sqlcommandtimeout>
<databaseinstallcommandtimeout>15</databaseinstallcommandtimeout>
<datapipelinecommandsendtimeout>3</datapipelinecommandsendtimeout>
<archivepath>C:\Users\alexander.filip\OneDrive - UiPath\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>
<windowsauth />
<extraparams>
</extraparams>
</connection>
<connection>
<name>LocalDB Connection</name>
<server>(LocalDB)\BluePrismLocalDB</server>
<dbname>BluePrism</dbname>
<databasefilepath>C:\Users\alexander.filip\AppData\Local\Blue Prism Limited\databases\BluePrism.mdf</databasefilepath>
<windowsauth />
<extraparams>
</extraparams>
</connection>
<connection>
<name>local</name>
<server>(LocalDB)\BluePrismLocalDB</server>
<dbname>BluePrism</dbname>
<databasefilepath>
</databasefilepath>
<windowsauth />
<extraparams>
</extraparams>
</connection>
<connection>
<name>test</name>
<server>(localdb)\BluePrismLocalDB</server>
<dbname>BluePrism</dbname>
<databasefilepath>
</databasefilepath>
<user>test</user>
<password enc="true">
<secstr obf="BluePrism.Common.Security.EncryptingObfuscator" enc="sE4yJ+aYDkZRk9bf1cp5mg==:dbaxTo7nUyngTWgX4PGvng==" />
</password>
<extraparams>
</extraparams>
</connection>
<connection>
<name>test2</name>
<server>(localDB)\BluePrismLocalDB</server>
<dbname>BluePrism</dbname>
<databasefilepath>
</databasefilepath>
<windowsauth />
<extraparams>
</extraparams>
</connection>
</connections>
<businessobjects />
</config>


I've tried also with Administrator privileges but same error. I'm attaching the printscreen

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

[TusharChoudhury]

Hi .. I am facing same problem , is there any solution for this ?

------------------------------
Tushar Choudhury
------------------------------

[Kwan_HoYu1]

Hi, I am also facing the same exact issue. Any solution on this? Thanks!

------------------------------
Kwan Ho Yu
------------------------------

[DhyanPaary]

Hi , If faced the same issue . I used the Dbconname as "LocalDB Connection". It worked for me

------------------------------
Dhyan Paary
------------------------------