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.
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.
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
David Delač
Hi Aldevinas, Please post your customisations so I can help you....
11:40 20 Feb 2025
Piotr Wycichowski
The register for Order Classes is common for Sales orders and Service orders. When I set an Order Class to create an Activity - it works for Sales Order, while for Service Orders - not. Is any setting...
09:30 18 Feb 2025