Database consistency checks
Database consistency checks ensure that the data in the PolicyCenter database is correct according to consistency rules. For example, the creation date for a row must always be earlier or the same as the update date. These checks are available from a command prompt tool, a web service, and the page. Database consistency checks always run asynchronously, as a batch process. The page shows the results of running the consistency checks and the SQL commands that the checks run.
Consistency issues might take some time to resolve, so run consistency checks early in the data import project. Contact Guidewire Support for information on how to resolve consistency issues. Continue to run consistency checks periodically and resolve issues so that your database is ready when you begin the data import procedure.
Optionally, after loading the staging table data into the operational tables on the live PolicyCenter database, run consistency checks again.
Example commands are shown below.
- API method: SystemToolsAPI.submitDBCCBatchJob()
- Command prompt tool:
system_tools -passwordpassword -checkdbconsistency
See also