KB: Database Errors, Indexing Errors: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
 
(23 intermediate revisions by 5 users not shown)
Line 1: Line 1:
=Description=  
=Description=  
Some of our customers have found that data from tickets gets mixed in with the wrong tickets. This issue can also present itself as missing data. '''Have no Fear''', for your data is quite safe. This issue is caused by an indexing error mostly caused by multiple connections to the same data within the database, causing the data not to be written to where it's supposed to go...
Sometimes the database indexes that govern search results from the database can be corrupted for several reasons, causing 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. It may also be a good practise to run it once every several months in order to make sure that the indexes are in order and up to date. In some cases, reindexing your database may also increase the overall system performance.
 
<br>


=Resolution=
=Resolution=
We fix this issue by '''Rebuilding the Database Indexes'''
'''Please run the RangerMSP 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.
To run the rebuild indexes, please follow these instructions: (Make sure you're using RangerMSP 5.0 and above)


:* 4.      [http://www.commitcrm.com/downloads/commit-rebuild-indexes-50.exe Click here] to download a Rebuild Indexes program => Save it in folder <server>\Commit\Utils
# Close RangerMSP client on all PCs
# Stop RangerMSP services if installed and used (RangerMSP WebInterface, RangerMSP Server and RangerMSP RMMServer services).
# Stop any third-party services or programs that access RangerMSP database.
# Leave the Advantage Service running if you are using the SQL Database.
# Backup the <server>\RangerMSP\Db and  <server>\RangerMSP\DbSys folders (use a standard zip/archive utility for this (such as Winzip), and/or, also copy the folder to a backup folder.
# Download the utility:  
#*If you are using '''version 25 or above'''  - [http://{{SERVERNAME}}/downloads/CRM-Rebuild-Indexes.exe Click here] to download a Rebuild Indexes program  


:* 5.       Run the downloaded program and have it rebuild the indexes
#*If you are using '''version 18 to 24'''  - [http://{{SERVERNAME}}/downloads/crm-rebuild-indexes-v18.exe Click here] to download a Rebuild Indexes program
#*If you are using '''version 16 or 17'''  - [http://{{SERVERNAME}}/downloads/crm-rebuild-indexes-v16.exe Click here] to download a Rebuild Indexes program
#*If you are using '''version 5 to 15  - '''[http://{{SERVERNAME}}/downloads/crm-rebuild-indexes-v5-to-v15.exe Click here] to download a Rebuild Indexes program
# '''Save it in folder <server>\RangerMSP\Utils'''
# Run the downloaded program and have it rebuild the indexes


----
----
Line 23: Line 29:


----
----
:*          Send us the log files via Help > Technical Support.
:*          Send us the log files via '''Help > Technical Support'''.


We'll analyze the logs, get you the support needed to fix this issue.
We'll analyze the logs, get you the support needed to fix this issue.


[[Category:KB|Database]]
[[Category:KB|Database]]

Latest revision as of 06:18, 9 July 2020

Description

Sometimes the database indexes that govern search results from the database can be corrupted for several reasons, causing 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. It may also be a good practise to run it once every several months in order to make sure that the indexes are in order and up to date. In some cases, reindexing your database may also increase the overall system performance.


Resolution

Please run the RangerMSP Backup Utility prior to Rebuilding the Database Indexes

To run the rebuild indexes, please follow these instructions: (Make sure you're using RangerMSP 5.0 and above)

  1. Close RangerMSP client on all PCs
  2. Stop RangerMSP services if installed and used (RangerMSP WebInterface, RangerMSP Server and RangerMSP RMMServer services).
  3. Stop any third-party services or programs that access RangerMSP database.
  4. Leave the Advantage Service running if you are using the SQL Database.
  5. Backup the <server>\RangerMSP\Db and <server>\RangerMSP\DbSys folders (use a standard zip/archive utility for this (such as Winzip), and/or, also copy the folder to a backup folder.
  6. Download the utility:
    • If you are using version 25 or above - Click here to download a Rebuild Indexes program
    • If you are using version 18 to 24 - Click here to download a Rebuild Indexes program
    • If you are using version 16 or 17 - Click here to download a Rebuild Indexes program
    • If you are using version 5 to 15 - Click here to download a Rebuild Indexes program
  1. Save it in folder <server>\RangerMSP\Utils
  2. 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.