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
Set up SQL Data connections for Sage Crystal Reports
Overview Sage 300 CRE uses Crystal Reports to generate formatted reports. To connect Crystal Reports, and thus the Sage report designs to your data which ADC has extracted into SQL Server, you will need to: Create a 32-bit ODBC connection called a ...
AnterraDataCenter Prerequisites Documentation
AnterraDataCenter™ Prerequisites Documentation 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 purchased ...
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 ...
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 ...
'Timberline Version Changed' appears when anterraDataCenter opens
Background When anterraDataCenter opens, a dialog box with the title "Timberline Version Changed" appears Each time anterraDataCenter opens, a message appears that has the following text in it: "Timberline version has recently been updated. SQL ...