topic RE: Error Message - DB String in Product Forum

Error Message - DB String

Tejaskumar_Darji — Mon, 09 Aug 2021 06:45:00 GMT

Hey Team,

I installed Decipher on a new machine and I'm seeing the below message in Decipher UI.

Can anybody help with which file/setup do I need to check for DB string.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Error Message - DB String

Ben.Lyons1 — Mon, 09 Aug 2021 07:14:00 GMT

Hi Tej,

The configuration file can be found in C:\Program Files (x86)\Blue Prism\Decipher Server and is called 'Ssiserver.exe.config'. You will need to open this as an administrator, likely in Notepad ++ or similar.

There will be a section called 'Connection Strings' where you will see the the current configuration. e.g.

<connectionStrings>
<add name="SsiServerDb" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DecipherServerDb;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="SsiServerDbReporting" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=DecipherServerDbReporting;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="SsiServerDbPublic" connectionString="" providerName="System.Data.SqlClient" />
</connectionStrings>

Check the respective user access is configured for each database being used (the reporting db is only used in 1.2, so you can ignore that if you're on 1.1).

It's likely that the system user of the new machine needs to be granted access to the db.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: Error Message - DB String

Tejaskumar_Darji — Mon, 09 Aug 2021 09:03:00 GMT

I've mentioned "." as a default connection string in both config files.
and I checked DB has NT authority permission.
Please check the below image.

The connection string looks ok to me, can you please check.
Is there anything else that am I missing?

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Error Message - DB String

chris.mcgowan — Mon, 09 Aug 2021 09:47:00 GMT

Hi Tejaskumar,

This is a known issue, please see the below Support Centre article.

http://portal.blueprism.com/customer-support/support-center#/path/1499878042

Regards

Chris

------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------

RE: Error Message - DB String

Tejaskumar_Darji — Wed, 11 Aug 2021 11:03:00 GMT

Thanks Chris. The issue got resolved as per the steps mentioned in the above support article link that you provided. Appreciate your help.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------