Data Integrity Checks
|
Access this form with Administrative user rights using Organization>Data Integrity Checks. This requires exclusive access to the system database and IIS Server. |
Use this form to check the integrity of your data files. It allows you to conduct a complete check of data, which identifies errors in the tables.
Data Integrity checks take time to process. It is recommended that the first time you run integrity checks you do so at a time you can afford to be out of the software for some time. You need to benchmark how long the integrity checks take to process for your organization. The amount of time needed for the checks to complete varies based on the hardware configuration and the size of the database being checked.
For SYSTEM ADMINISTRATORS with Employee Web Services, the data integrity check requires exclusive access to the system database, including the IIS server. Before running a data integrity check, you will need to sever the connections to the IIS server running EWS or shut down IIS while running the data integrity checks. Otherwise, the operation fails with an error message.
Multicurrency Users
If you experience failing data integrity checks associated with Cash, Accounts Payable, and Accounts Receivable balances, use Activities>Revalue Multicurrency to adjust functional currency balances for foreign cash accounts to accurately reflect current exchange rates and record appropriate realized gains and losses.
If you own the MIP Advance system and get the message that you do not have exclusive access, be sure to review the System>Manage Concurrent Users and System>Manage Services forms; sending emails to the users accessing the system which explain the need for exclusive access, remind them to save their changes and log out of the system quickly. Afterwards, if you still need to establish exclusive system access, open System>Manage Services. Click the 
Set Maintenance Mode button and set the organization and system databases offline. This will set the system into maintenance mode and prevent others from logging on to the system but it will also kick the logged on user's out of their databases; thus losing any unsaved work. Once the Data Integrity Checks are complete, you will need to clear these check boxes on the Set Maintenance Mode form and place the organization and system databases back online.
Select: Click the check box to select the test you want the system to perform. A check mark appears next to selected items.
Module: The system displays the module for which the corresponding test applies. Only installed modules appear in this column.
Description: The system displays the description (or name) of each test. For more information, see Description of Individual Integrity Checks.
- Click Start to run integrity checks anytime you suspect that problems with your computer system may have damaged your data.
- Make sure that a network backup procedure does not interfere with running a data integrity check overnight. To ensure there is no interference with the process, run the checks on a workstation.
- Review the information displayed on the Data Integrity Checks Message screen.
