Peachtree Accounting 2011 - Automatic Backup fails with Unhandled Exception

Question

I have Automatic Backup set up for a number of companies, which has been working fine until last night. Every one failed, and I get the same error if I try to open the program and manually load one, seen below. Looking up the 7013 code, this seems to be the Pervasive PSQL code for "Named database does not exist". I can backup fine within Peachtree, and all other activities within Peachtree are also fine. Data Verification returns no errors, and this happens on every computer. 
 Peachtree was installed for network use, so I believe the problem lies in the /Company/ directory it initially links to. My fear is that, when deleting the folder of a client I restored temporarily, I somehow deleted other necessary files/folders by accident. Unfortunately, I don't have anything to compare the folder against. An attempt to do a repair install did not work, neither on the server where the files are hosted nor a user's computer. 
 The error will appear whenever I try to load a PTC file, or even just when I select a Peachtree folder for "Company Directory". Selecting a non-Peachtree folder has the expected "This is not a Peachtree folder" message. 
 Anything to be done? I imagine a full uninstall and re-install on the main server would work, but backing up all those companies manually and restoring them would be quite the chore. 
 
 See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** Sage.Peachtree.DataAccess.DTIException: DTI PvGetDbDataPath returned error: 7013 at Sage.Peachtree.DataAccess.PervasiveDTISession.GetDbDataPath(String dbName) at PeachtreeBackup.BackupController.GetDBNFromPath(String dbnServer, String companyPath) at PeachtreeBackup.AutomaticBackupConfigForm.ValidateCompanyDirectory(String companyPath, BackupConfig& config) at PeachtreeBackup.AutomaticBackupConfigForm.BrowseButtonHandler(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Robernaut · Accepted Answer

Success! I was able to replace the DBNames.cfg file and automatic backup is now churning through the various stores! Here are the steps I took, but remember that you do this at your own risk and I cannot guarantee success or no further problems . 
 
 Open the folder C:\Program Files\Pervasive Software\PSQL\DBNamesDirectory (if you're on 64-bit, it will be Program Files (x86) ) on the computer hosting your Peachtree files 
 If the file ~PVSW~.LOC is there, go into Services and Stop Pervasive PSQL Workgroup Engine ( If that file is not there, you do not need to shut down the service unless Windows complains when you try to move the file) 
 Move the file dbnames.cfg to another location (I do not recommend outright deleting it, in case you need to put it back) 
 If you shut down the Pervasive PSQL Workgroup Engine service, Start it 
 Within Peachtree, manually open each company you need to back up. Peachtree will automatically create the dbnames.cfg file and add each company to it as they are opened 
 Once you have opened each company individually, close PeachTree 
 Run Automatic Backup as needed 
 
 I don't know if it's 100% necessary to open each file, but I did just in case. If I happened to forget to open one and it fails to backup, I will post an update saying that you have to open each one for sure. 
 I don't know how this problem began, but because we deal with a lot of companies and it's been four years of using that one file I imagine it got corrupted or overloaded somehow. It could have been something I did when I restored a company on Wednesday, or that could have just been coincidence. Either way, I'm glad I have it fixed, I hope I didn't annoy anyone with my rambling, and hopefully this helps anyone else that might have the problem.

Sage 50 US

Peachtree Accounting 2011 - Automatic Backup fails with Unhandled Exception

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING