Q&A
SQL shadowing RDB interface disabled
Niclas Björkdahl
6-21-22
Operating system: Windows
Hi,

We have customer running Standard ERP with SQL shadowing.
Today the SQL database was down for a while which resulted in StandardERP stopping the SQL shadowing.
All registers in the Relational DB Registers setting went from Valid to Invalid.

2022-06-21 12:27:33 Disabling RDB interface due to previous errors
2022-06-21 12:27:33 waiting 5 seconds to retry sql connection
2022-06-21 12:27:38 connect failed: -1
2022-06-21 12:27:38 ODBC ERROR, SQLSTATE 08001 message '[unixODBC]could not connect to server:
2022-06-21 12:27:38 Disabling RDB interface due to previous errors

2022-06-21 12:27:38 Failed to initialize connection to relational database

Is there a way to enable the RDB interface again or do I have to rebuild all registers with Build all RDB data?
Sanjay Parbhoo
6-22-22
I believe you have to rebuild the registers again.
Reply
Brittany McGrath
8-19-22
Hello, does this post still require assistance?

If no assistance required then we will close the post.
Please advise.
Thank you.
Reply
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Re: Re: WEB server - number of users and sessions
Andis Blicāns, Grasko
Hi, We have client using 8.5 2021-09-26 (build 85400383). The fields "Max Web Users" and "Max Sessions" ar blank. Server is closing itself almost every day. Message in hansa....
15:52 26 Apr 2024
Password Expiry and Minimum Spec
Afternoon, Some of our customers haven't changed their passwords for a while but they're not getting any password expiry message. If I copy their Standard ID into a new user on some test ...
17:22 25 Apr 2024