topic RE: AutomateC "database connection string not complete" in Product Forum

AutomateC "database connection string not complete"

AlexanderFilip — Sun, 20 Oct 2019 18:09:00 GMT

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

RE: AutomateC "database connection string not complete"

james.man — Mon, 21 Oct 2019 07:18:00 GMT

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

RE: AutomateC "database connection string not complete"

AlexanderFilip — Mon, 21 Oct 2019 07:50:00 GMT

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

RE: AutomateC "database connection string not complete"

james.man — Thu, 24 Oct 2019 11:22:00 GMT

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

RE: AutomateC "database connection string not complete"

AlexanderFilip — Thu, 24 Oct 2019 13:27:00 GMT

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

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

RE: AutomateC "database connection string not complete"

james.man — Thu, 24 Oct 2019 16:54:00 GMT

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

RE: AutomateC "database connection string not complete"

AlexanderFilip — Fri, 25 Oct 2019 15:35:00 GMT

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

RE: AutomateC "database connection string not complete"

TusharChoudhury — Wed, 18 Dec 2019 14:06:00 GMT

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

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

RE: AutomateC "database connection string not complete"

Kwan_HoYu1 — Fri, 20 Dec 2019 02:54:00 GMT

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

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

RE: AutomateC "database connection string not complete"

DhyanPaary — Sat, 02 Jan 2021 17:07:00 GMT

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

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