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?
Reply
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
SendAsyncWebRequest vs SendWebRequest
Paul Timms
SendWebRequest3 is a boolean function, so if this returns true and the reply header has an accepted status, you can assume that the data was sent successfully and perform some actions on the record th...
11:12 4 Apr 2025
Re: Periodic Customer Statement variance(overview vs detailed mode)
Aldevinas Katkus
same v. 2025-02-24. New DB. Just forward balances (purchase, sales invoices) from 2024 and later. In your case does turnover per period differs or just fwd. balance differs and turnover is identical i...
09:56 20 Mar 2025