Captools/net Documentation

Database Table Read Error

Database Table Read Error

Previous topic Next topic  

Database Table Read Error

Previous topic Next topic  

If after installing a Captools/net update, you get a "Database Table Read Error", you will need to run the "Configure Captools/net Database" function on the Server Control Panel.

 

DatabaseTableReadError

 

Click "OK" on the resulting dialog.  This will "fixup" your version of the database to reflect any new data tables and/or fields and also new schedulable tasks that can be run by the CTnet Tasker.

 

 

Data Base Corruption Fixup

 

If Captools/net cannot connect to the Captools/net Database and the database cannot be opened in Microsoft's SQL Management Express, then there is a possibility that your Captools/net database files (CaptoolsDB.mdf, CaptoolsDB.ldf) have become corrupted.  One resolution to this is to simply find prior copies of these files in your backups and place those in the Captools/net  Database folder over the current versions of the files.  However, if a recent backup is not available, or if you have done significant work on the database since the last backup, you might be able to recover the database by using a Microsoft SQL tool called the "Database Consistency Checker" described at the following link:

 

 

http://msdn.microsoft.com/en-us/library/ms176064.aspx