Rebuilding Stored Procedures and Triggers - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Internal Setup

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Help
Version_SPI_custom
2018 (12.0)

This procedure allows you to identify abnormal database behavior and correct it by rebuilding the stored procedures and triggers in the database.  Stored procedures and triggers are portions of code that run automatically when you perform certain actions that affect the database.  For example, when you delete a loop, there is a stored procedure that runs to delete an associated loop drawing.  You can re-create stored procedures either for the Admin schema or for the Domain schema.

The System Administrator should perform this procedure if inappropriate SQL error messages are displayed in Smart Instrumentation.

Normally, you should run this option from the Administration module; however, you can run it from the Internal Setup Utility if for some reason you cannot log on to the Administration module.