ProTracker Advantage loses connection to the database

ProTracker Advantage loses connection to the database

 

ProTracker does not automatically disconnect from the server. It requires a reliable connection to the host server. There may be entries in the log file that indicate that the program lost its connection to the server, but not for any reason explained by activity in the program such as data corruption. Then the cause must be external.

You may wish to consult with your local IT person for assistance on the other causes listed below.

Here are some possible sources of network disconnection. Be sure to check the server *AND* workstation for each listed item:

 

  1. A Backup process is running. Check the backup schedule to ensure that it does not coincide with the disconnection. Try temporarily disabling your backup for a day.
  2. A virus scan/security scan is running. Check the scan schedule. Try temporarily disabling the scan.
  3. A scheduled task is running. Check Start > Programs > Accessories > System Tools > Scheduled Tasks
  4. A 3rd party software update is in progress. Do you run software that requires regular udpates, such as tax software?
  5. There is a problem with the network hardware such as a bad network card or switch
  6. There is a problem with network drivers that requires an update. Check Windows Update and the manufacturer's website.
  7. The server, workstations, or network card is entering power saving mode. Check Control Panel > Power Options and the control panel for your network card.
  8. The workstation is set to autodisconnect from network shares
  9. A licensing problem with the server. Are there enough CALs for the number of clients connecting to the server?
  10. Firewalls (windows, McAfee, etc.) can introduce random disconnections from network shares. Try temporarily disabling the firewall. Windows Firewall can be accessed in Control Panel > Windows Firewall
  11. Issues with DHCP on the server

 

Here are some possible solutions

Solution #1 - Disable UAC or edit the registry:

Some Programs Cannot Access Network Locations When UAC Is Enabled
http://technet.microsoft.com/en-us/library/ee844140%28WS.10%29.aspx

Solution #2 - Force the workstation to maintain connections:

Mapped Drive Connection to Network Share May Be Lost
(http://support.microsoft.com/kb/297684)
1. Go to the affected workstation
2. Select Start > Run
3. Type "cmd", click OK
4. Type "NET CONFIG SERVER /AUTODISCONNECT:-1", press Enter

Solution #3 - Force Server to maintain connections:

Mapped Drive Connection to Network Share May Be Lost
(http://support.microsoft.com/kb/297684)
1. Go to the computer that hosts your shared documents (i.e. your server)
2. Select Start > Run
3. Type "cmd", click OK
4. Type "NET CONFIG SERVER /AUTODISCONNECT:-1", press Enter

Solution #4 - Force workstation to maintain connections:
(http://technet.microsoft.com/en-us/library/bb490717.aspx)
1. Click the Start button
2. Type "cmd" in the search box
3. Right-click "cmd" and select "Run as Administrator"
4. Type "net use [drive letter]: \\SERVER\FOLDER /persistent:yes" substituting drive letter and server path, press Enter

If #4 resolves the issue, the above command can be added to the workstation's logon script to permanently resolve the issue.

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.