Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 05:10 PM
Hello we recently setup our production environment and are getting the error "Error loading statistics. Please check the database connection string." when on the Home page and the Reports page.
I've gone through all the steps here: [DECIPHER] How do I fix error "Error loading statistics. Please check the database connection string." when opening the Decipher web client interface? with no luck. The environment setup should be the exact same as our test env and we do not get the error there (the only differences is we encrypted data at rest for prod when doing the server install).
We are using windows auth to connect via a service account. All the connection strings look correct and the service account is set as the user for the Decipher Application Pool in IIS Manager. I can also grab data from the decipher database using queries and authenticating with the same service account.
I should also mention that everything else seems to be working in Decipher besides the statistics data.
I've gone through all the steps here: [DECIPHER] How do I fix error "Error loading statistics. Please check the database connection string." when opening the Decipher web client interface? with no luck. The environment setup should be the exact same as our test env and we do not get the error there (the only differences is we encrypted data at rest for prod when doing the server install).
We are using windows auth to connect via a service account. All the connection strings look correct and the service account is set as the user for the Decipher Application Pool in IIS Manager. I can also grab data from the decipher database using queries and authenticating with the same service account.
I should also mention that everything else seems to be working in Decipher besides the statistics data.
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 07:45 PM
I figured it out! Really dumb reason... I didn't have a space between "Integrated" and "Security" in the connection string. After adding one it worked.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 07:45 PM
I figured it out! Really dumb reason... I didn't have a space between "Integrated" and "Security" in the connection string. After adding one it worked.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-09-21 09:09 AM
Hi Ben B,
Easily done, glad you got it working!
Thanks
Ben L
Easily done, glad you got it working!
Thanks
Ben L
Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based