Procedure for HRSS 3.4 or later

1. Back up the PayGlobal database that you want to check.

   You should take a backup of your database before you run any major database processes.

2. Navigate to the bin folder in your HRSS directory.
3. Double-click IntegrityChecker.exe.

   Note: The Integrity Checker automatically uses the database specified in the Config Editor.

   The Select the tables page appears.

   

4. Ensure that all tables are selected.

   Only the tables that affect HRSS are checked so you should select all tables and all rules to ensure that PayGlobal will be compatible with HRSS.

5. Click Next.

   The Select the rules page appears.

   

6. Ensure that all rules are selected (see Rules).

   The "Keys valid" rule has options that you can configure in the Options for rule section.

   Note: When you have selected a rule that may update your database, the following message appears:
   "One or more of the rules you have selected may alter your data. It is recommended that you backup your database before continuing. Do you want to continue?"
   - Click Yes to go to the next page.
   - Click No to return to the rules selection page.

7. Click Next.

   The Begin integrity checking page appears.

8. Click Start.

   A two-stage progress bar and status messages are displayed while the tables are checked by each rule. You can click the Cancel button to cancel the process, which allows the rule that is currently running to complete before the integrity check is terminated. If you cancel the process, then any changes that have already been made to the database are not rolled back.

   The Displaying database integrity check results page appears, which displays a summarised list of violations.

   

   To view more information about the integrity check, click the View audit log button.

   The audit log shows which tables and records have problems, which rules were violated, and the errors that were corrected. The audit log is saved in the ...HRSS\bin folder and has the prefix "Database_Integrity_Check".

9. Click Finish.

   Important: Any errors that the integrity checker finds must be fixed before you use HRSS.
   If the integrity checker finds errors that you cannot correct, then contact Customer Support who may need to book a consultant to fix the errors in your database for you.

Topic: 7594