Rebuilding Stored Procedures and Triggers - Intergraph Smart Instrumentation - Administration & Configuration

SmartPlant Instrumentation Configuration and Maintenance Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
2016 SP1 (11.0.1)

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 .

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.