topic RE: Decipher IDP tool - Error loading statistics. Please check database connection string in Product Forum

Decipher IDP tool - Error loading statistics. Please check database connection string

KrishnaElapavul — Thu, 01 Apr 2021 05:02:00 GMT

I am facing an issue when I logged in to Decipher IDP tool and after selecting "Report tab".
I have configured sql connection string in web config file as well as Decipher server config file. Also note that i am able to create batches and process from P1- P4
Thanks
Krishna
DXC.technology

------------------------------
Krishna Elapavuluri
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

Ben.Lyons1 — Tue, 06 Apr 2021 13:30:00 GMT

Hi Krishna,

I think it might be a setting in the web.config file.

Take a look at the support article here and let me know if that resolves the issue.

Thanks

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

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

KrishnaElapavul — Wed, 07 Apr 2021 13:34:00 GMT

Hi Ben,

Thanks for reply , I have already tried this solution which you have provided . But issue not resolved.
In second part when I provided usr/pwd it's not taking . but same usr/pwd provided in web config and Desipher server config file.

Thanks
Krishna.

------------------------------
Krishna Elapavuluri
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

ramonnunez — Wed, 07 Apr 2021 16:43:00 GMT

Please take a look to this knowledge base article [DECIPHER] How do I fix error "Error loading statistics. Please check the database connection string." when opening the Decipher web client interface?

So it is important to know what type authentication are you using for your database, if you are using sql auth then it would be correcting the external db string in IIS management, but if you are using Windows Auth then you won't use user name and password in your connection string but the IIS server still needs to know which user is going to need for authentication in the db so you will have to provide in that case the user in the identity pool of the decipherAppPool in IIS.

------------------------------
Ramon Nunez
Customer Solutions Engineer
Blue Prism Software Inc
UTC
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

KrishnaElapavul — Mon, 12 Apr 2021 07:31:00 GMT

Thanks Ramon,

Manual edit helped me , It works now.
Thanks
Krishna

------------------------------
Krishna Elapavuluri
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

JonathanAranha — Tue, 06 Jun 2023 01:36:00 GMT

This link is not opening for me, can you help me? I'm having the same problem, in the Application Pools configuration I'm not putting a user linked to AD and he doesn't follow. Is it possible to set a local system configuration?

------------------------------
Jonathan Aranha
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

Ben.Lyons1 — Tue, 06 Jun 2023 07:11:00 GMT

Hi Jonathan,

Sorry, we've updated our support set up since this query was originally raised. Though the troubleshooting section of the Decipher help pages contains much of what was previously available.

I believe this snippet is the solution we provided:

If this doesn't resolve your query, I recommend raising a support ticket so we can help you as quickly as possible.

Thanks

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
SS&C Blue Prism
UK based
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

JonathanAranha — Tue, 06 Jun 2023 17:27:00 GMT

Thanks for sharing, it solved my problem!!!

But I have this other situation below:

Can you help me?

------------------------------
Jonathan Aranha
------------------------------

RE: Decipher IDP tool - Error loading statistics. Please check database connection string

Ben.Lyons1 — Wed, 07 Jun 2023 07:32:00 GMT

Hi Jonathan,

Is the Web SDK service running? Might need to be started/restarted.

Thanks

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
SS&C Blue Prism
UK based
------------------------------