Database Sanity Checks

System Maintenance Menu -> Configure System Settings -> System Tab -> Texada Settings -> 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:

String formatting tool
 timezone reset
 timezone set
 timestamp text logging
 writing to text files
 tsi http library
 

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

BKTX
 MD5
 STRFORMT
 TSIENC
 tsiResetTZ
 tsiSetTZ
 tsiTxtLog
 tsiWriteTxt
 tsihttplibv
 

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:

othings in SQL only which can be ignored

othings in PRO only which are an issue such as tables that do not exist

odifferences between SQL and PRO which can be critical if PRO has a larger column size than SQL.

Topic Keyword: SANCHCK