Resolving Pervasive.SQL 3006 error found in AnterraDataCenter Log files
The Pervasive.SQL.3006 error is a result of a timeout between the Pervasive Client and Server which creates a broken or interrupted connection. This can happen if AnterraDataCenter is on a different server from the Sage Pervasive database, or if the table being accessed in Sage is very large.
The solution is to enable reconnect for Pervasive and increase the timeout in the Pervasive Microkernel. Follow these steps on the client server to fix (or the Sage server if running AnterraDataCenter on it):
- Click Start, Programs, Pervasive, PSQL and run Control Center & Documentation
- On the right-hand side of the window select Configure MicroKernel Router
- In the Properties for Microkernel Router select the Communication Protocols tab.
- On the right-hand side, you should see an option for Enable Auto Reconnect, click to put a tick in this box. You can also optionally increase the timeout to higher than the default 15 seconds.
- Exit the control center, saving the changes if prompted, then restart the workstation
Related Articles
AnterraDataCenter 5.x Prerequisites Documentation
AnterraDataCenter™ Prerequisites Documentation Contents Required Software Components Sage ODBC Sage ODBC is required to be fully operational for each computer running the AnterraDataCenter™ tools. This requires a Sage server or client install with a ...
Set up SQL Data connections for Sage Crystal Reports
32 Bit DSN Manager 1. Create a DSN pointing to the SQL Database. 2. Connect to Sage SQL Server and Instance that has anterraDataCenter database. 3. Use Windows Authentication. 4. Change the database to your anterraDateCenter database. 5. Use Defaults ...
Sage 300 CRE Upgrade Guide for anterraDataCenter
Background Upgrading Sage 300 CRE to V17 or V18 can interrupt ADC syncs and disable your Windows Server Scheduled Tasks. We have prepared this guide to assist you in upgrading anterraDataCenter and preventing sync and scheduled task outages. Please ...
Why can't I log in to AnterraBI
Having trouble logging in? We've found that most users can't log in because they've either forgotten their password, forgotten their email, or have received an error message. Forgot password Your password will be the one you set when you created ...
Allow Non-Administrator Users to Run ADC Updates
Running All Connections This is the easiest configuration and allows any user to run the configured connections for all active tables. Create a shortcut to ADCUpdate.exe (located in the anterraDataCenter installation folder). You can place this ...