Database Sanity Checks

This program is intended as a to be run by Texada Support as a service utility to check the status of various aspects of the Oracle and MSSQL Database on LINUX and on Windows.
The Last Refreshed Data indicates when the sanity check was run that returned the status information for the listed areas.

The Sanity check has been updated to check:

The following checks should be performed and display an OK to indicate success:

ACTIONS:
Additional actions provided by buttons on the Sanity Check screen include:

• Refresh the messages:
  Click the REFRESH button to update the messages as of the current time.

• Check for Locked Record:
  Click the LOCKING TESTS button to view details on any locked records.

• Compare the Database Values:
  Click the COMPARE DB button to initiate a compare utility on the database.
  The results are listed in a text file that is created in the pro4data directory.

  The checking utility compares the database to the application, and reports differences including:

  • things in SQL only which can be ignored
  • things in PRO only which are an issue such as tables that do not exist
  • differences between SQL and PRO which can be critical if PRO has a larger column size than SQL.