KB: Database Errors, Indexing Errors: Difference between revisions
| Line 1: | Line 1: | ||
=Description= | =Description= | ||
Sometimes the index files that govern search results from the database can be corrupted for several reasons, causing inconsistent | Sometimes the index files that govern search results from the database can be corrupted for several reasons, causing inconsistent inconsistent behavior when searching or loading specifically affected parts of the database. This behavior can be corrected by rebuilding your database indexes so that the data can be reassessed and properly tagged by the index files. This process is considered safe to run in order to correct suspected database indexing errors; however, it is also considered good practice to periodically run this process in order to make sure that the indexes are in order and up to date. | ||
<br> | <br> | ||
Revision as of 19:48, 1 April 2010
Description
Sometimes the index files that govern search results from the database can be corrupted for several reasons, causing inconsistent inconsistent behavior when searching or loading specifically affected parts of the database. This behavior can be corrected by rebuilding your database indexes so that the data can be reassessed and properly tagged by the index files. This process is considered safe to run in order to correct suspected database indexing errors; however, it is also considered good practice to periodically run this process in order to make sure that the indexes are in order and up to date.
Resolution
Please run the CommitCRM Backup Utility prior to Rebuilding the Database Indexes
To run the rebuild indexes, please follow these instructions: (Make sure you're using CommitCRM 5.0 and above)
- 1. Close CommitCRM client on all PCs
- 2. Stop CommitWebInterface and CommitServer services (if installed and used). Leave the Advantage Service running if you are using the CSD.
- 3. Backup the <server>\Commit\Db and <server>\Commit\DbSys folders (use a standard zip/archive utility for this (such as Winzip), and/or, also copy the folder to a backup folder.
- 4. Click here to download a Rebuild Indexes program => Save it in folder <server>\Commit\Utils
- 5. Run the downloaded program and have it rebuild the indexes
Check to see if the problem has been resolved.
If the issue persists, we will need some more information in order for us to investigate:
- Send us the log files via Help > Technical Support.
We'll analyze the logs, get you the support needed to fix this issue.