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?
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
David Delač
Hello Paul! You can make use of transactions variables to store record number once you've received expected reply. Function / Procedure that is calling SendAsyncWebRequest should have trans...
08:14 17 Apr 2025
David Delač
Hi Aldevinas, You need to customise ReadImportTaguser2 since it was added between mentioned versions, to support the changes. Best regards, David D....
14:11 15 Apr 2025