Prepare the data and the PolicyCenter database

You must perform multiple tasks before you load data from staging tables.

Procedure

  1. If you changed the data model, run the server to perform upgrades. The staging table import tools require that source data be converted to the same format as the server data.
  2. Create zone data files. Create zone data files in comma separated value (CSV) format.
  3. Set the server to the maintenance run level. Set each PolicyCenter server to the maintenance run level by using the system_tools command prompt tool or the web service SystemToolsAPI.setRunLevel method.
  4. Back up the operational tables in the database. Back up operational tables before import.
  5. Clear the staging tables, the error tables, and the exclusion tables. Use web service APIs or command-line tools.
  6. Run PolicyCenter database consistency checks, Database consistency checks verify that the data in your operational tables does not contain any data integrity errors. Run database consistency checks using the web services SystemToolsAPI. checkDatabaseConsistency method, or running the command prompt tool as shown below. 
    system_tools -password password -checkdbconsistency