Summary

Check database integrity in the following situations:

• When you experience problems with the database.
• After you make a major change to the system.
• When you synchronise data into the database. Checking integrity helps prevent you from importing invalid source data or references into PayGlobal.

Database integrity addresses the contents of the database. The Check Database Integrity command checks the validity of the database to make sure that it contains logical data. For example, it checks the parent and child tables to ensure valid relationships.

Note: Database structure is the way in which the database is designed. The Check Database Structure command checks this aspect of the database.

Procedure

1. Use Lock System before using the Check Database Integrity command to prevent other users accessing PayGlobal and causing possible data corruption.
2. Double-click the Check Database Integrity command to see the Check Database Integrity form.
3. Select the tables that you want to check, or press Ctrl+Space bar to select all checkboxes.

   You can use the following buttons to control how the tables are displayed on the Check Database Integrity form

   • Click Hide Empty to hide empty tables
   • Click Record Count to display the number of records in each table.
4. Select checkboxes for the options that you require.

   Important: Do not select the Fix dates dynamically option.

5. Click one of the following options:
   • Check all tables that use the selected table(s) (slower)
   • Check all codes in the selected table(s).
6. Check that the date checking values are correct.

   Note: If your database contains dates after the Check date values are below value (such as long service leave dates), then they will appears as 'errors' in the audit log.

7. Click Check.

After PayGlobal checks your database structure, it performs a referential integrity check on the tables in your database, and lists any problems in the resultant audit log.

Note: The Check Database Integrity command does not check if required fields are missing.

Indexing issues

Indexing issues can cause integrity check failures. Before you try to fix errors that affect many records, run Standard Reindex, and then re-run Check Database Integrity. If the results change after reindexing, then try to identify the cause ot the errors.

Troubleshooting Upgrades

When you upgrade PayGlobal, it automatically runs the Check Database Structure command. If your database is flagged as invalid, then use the information in the resultant audit log to investigate these table errors with the Check Database Integrity command.

1. Double-click the Check Database Integrity command.
2. On the Check Database Integrity form, select the tables with errors that were listed in the audit log.
3. Do not select the Fix dates dynamically checkbox, but select all other checkbox options.
4. Select the Check all tables that use the selected table(s) radio button.
5. Click Check.
6. Use the resultant information to fix the problems with the tables.
7. Run the Check Database Structure command to check that the database structure is valid.