Rebuild Stored Procedures and Triggers - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide (2019)

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1

  • This procedure should only be carried out when you are specifically instructed to do so by Customer Support.

  • Make sure that all users have logged out of the Smart Instrumentation database before starting this procedure.  When you start rebuilding stored procedures and triggers, no users should attempt to log on to Smart Instrumentation.

Create a Batch Rebuild File

As in batch upgrade, you can create a .bat file that rebuilds stored procedures and triggers for multiple domains simultaneously. The following procedure describes how to create a batch rebuild file.

  1. In Notepad, create a batch file (for example, BatchRebuild.bat).

  2. Enter a line for each domain you are asked to rebuild stored procedures and triggers for, as shown in the example below:

    Upgrade -9999 //rebuild stored procedures and triggers for admin schema

    Upgrade -<proj_id> //rebuild stored procedures and triggers for a specific domain

  3. Double-click the batch file to run it and rebuild stored procedures and triggers for the defined domains.

    You can schedule the batch file to run at a convenient time using Windows scheduler (for example, during the night or over the weekend).

Rebuild Stores Procedures and Triggers Manually

  1. With the System Administration window open, click DBA >Rebuild Stored Procedures and Triggers.

  2. Do one of the following:

    • Click Admin schema to rebuild stored procedures and triggers of the Admin schema.

    • Click Domain schema and then, under Domain, select a domain for which you can rebuild stored procedures and triggers.

  3. Click OK.

    • When rebuilding stored procedures and triggers of the Admin schema, the Domain list is redundant.

    • If the process stops for any reason, you can restart the process and the process continues from where it stopped.  If you get an error that cannot be corrected, contact Intergraph Support with the error description.  It is recommended that you have your log file available when contacting Intergraph Support.

  4. On the Rebuild Stored Procedures dialog box you can click Browse to specify the log file path and filename, if you do not want to use the default Log.txt file.  This file contains information of the current session and any errors that may have occurred in previous sessions.  The log file is concatenated, if you use the same log file name.

  5. Click OK to start rebuilding the stored procedures and triggers of the selected schema.

At the end of the process, an appropriate message is displayed and an additional log file Logerror.txt is generated in the Smart Instrumentation home folder.  The data in the Logerror.txt file is incremented between sessions. Send the Logerror.txt file to Intergraph Support after you complete the process.

See Also

Smart Instrumentation Database Schemas
Connecting to the Smart Instrumentation Database