Check the Database - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

SmartPlant Instrumentation DBChecker Utility

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Help
Version_SPI_custom
2016 SP1 (11.0.1)

It is recommended that only trained users with advanced knowledge of and administration options should use the utility.  If such knowledge is lacking, it is recommended to use Customer Support assistance when using the utility for the first time.

  1. In the DBChecker Utility window.

  2. Click Connect to connect to the Admin schema of your database.

  3. From the Domain box, select a target domain.

  4. Under Output data file path, do one of the following:

    • Accept the default path where the software creates the log files on completion of the database check.  The default location is the home folder.

    • Click Browse to specify another path. 

      If you previously ran the DBChecker Utility, the software has already created the log files.  Specifying a different path prevents you from overwriting existing data in the files complog.txt and recreate.txt.

  5. Under Check tables and related items, select Tables, and then select a combination of the check boxes.

    If you want to check reference data, you must select the Initial records check box.  Initial records are rows in which all fields of primary keys are zeros.  When checking reference data, the software checks existence of required rows in pertinent tables.

  6. If needed, under Check other database items, depending on your database platform, do one of the following:

    • On Oracle, select Invalid objects and/or Disabled foreign keys.

    • On SQL Server, select Disabled foreign keys

  7. Click Run to start the database check.

    • On completion of the database check, the software creates the files complog.txt and recreate.txt.  If database problems are found, the software opens the Check Results dialog box, where you can analyze the problems and fix suggestions, and select all or specific problems which you want to fix on the fly or at a later stage.  If you choose to repair the database yourself, it is recommended that you run the DBChecker Utility once more to verify that all the problems have been fixed. 

    • If the DBChecker Utility generates corrective statements identical to the ones successfully used before to resolve the problem the user can execute them at their own discretion.  When contacting Customer Support, make sure you forward to Customer Support the three log files generated by the DBChecker Utility and await instructions on how to execute them.