Have a Question?
PracticeWorks: Btrieve code 3012 op = 0
This error refers to:
Unable to open PracticeWorks on one or more machines.
Cause:
Pervasive services are not running on the server, or simply need to be restarted (even if the issue only happens on one machine and all others function fine)
Displayed message:
“Local engine not accessible. Btrieve last code 3012 op = 0”
Most Common Solution:
1. Restart the Pervasive services by:
- From the server, click Start
- Click Run
- Type services.msc in the window and hit enter
- Right click on Pervasive PSQL Relational Engine and click Stop
- Right click on Pervasive PSQL Transactional Engine and click Stop
- Right click on Pervasive PSQL Relational Engine and click Start
- Right click on Pervasive PSQL Transactional Engine and click Start
- Close this window
- Open PracticeWorks
NOTE: Pervasive SQL “listens” through Port 3351 on the Server’s IP address. A static IP address is not required here, but it is helpful. If the IP on the server changes without Pervasive Services being restarted, they will still be listening on the original IP address, and workstations will not be able to find it. This is what often times causes 3012 errors, and it is why we begin troubleshooting by restarting the Pervasive Engines.
If the server is still not able to launch PracticeWorks without issue:
2. Ensure the mapped network drives are connected on all workstations (no red x’s).
2. Ensure the mapped network drives are connected on all workstations (no red x’s).
- Open File Explorer from the taskbar or the Start menu, or press the Windows logo key + E.
- Select This PC from the left pane. Confirm the existence of a drive that points to the shared Pworks folder on the server.
- If the drive is not present, then on the Computer tab, select Map Network drive.
- In the Drive list, select a drive letter. (Any available letter will do.)
- Letter should match what’s expected from the current installation.
- In the Folder box, type the path of the folder or computer, or select Browse to find the folder or computer. To connect every time you log on to your PC, select the Reconnect at sign-in check box.
- If manually typing the path, use the computer name, not the IP address.
- Select Finish.
If the issue persists, you can also check the following:
3. Check to make sure that Telnet connects.
-
From the Workstation, go to Start > Control Panel > Programs and Features.
-
On top left click Turn Windows features on or off
-
On the list check the box for Telnet Client > click OK to install.
-
Once installation is complete, open command prompt window.
-
Type in “Telnet <servername> 3351”. Where <servername> = the name of the Pervasive server.
-
Press Enter.
-
If CMD goes blank with blinking curser then it successfully connected. otherwise it will give a message that failed. Will need to resolve for communication on port 3351.
-
This can be caused by the Firewall, or communication issue between workstation(s) and server.
-
Office tech needs to find why 3351 will not connect, as this is considered a networking issue.
4. Make sure server has the network location set to private/Domain.
-
Go to Start > control panel > Network and Sharing center.
-
Under View your active networks check to see if the network is set to public, private, or domain.
-
If set to public, this needs to be changed to private or domain depending on the network.
-
The steps to change the network type depends on the version of Windows.
-
Windows 7/Server 2008:https://goo.gl/5FfHF7
-
Windows 8/8.1: https://goo.gl/sz2W97
-
Windows 10: https://goo.gl/MQnqSK
-
Server 2012:https://goo.gl/2Hbftg
-
5. Network – Group Policy Update
In chronic cases if error persists – look at error.log file for the workstation with the errors. Record the date and time stamp and then compare it to Windows System Event logs to see if there was a Group Policy Update information entry showing as successfully completed at the same time. This process has been known to reset the network connection on completion. This can be resolved by having whomever maintains their network set the Group Policy Update to happen after hours instead of during the day. This is something outside scope of support and should be done by whomever maintains their network.