Rebuild Procedures and Triggers Dialog Box - Intergraph Smart Instrumentation - Help

SmartPlant Instrumentation Internal Setup

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
2016 SP1 (11.0.1)

This option allows you to identify abnormal database behavior and correct it by rebuilding the stored procedures and triggers in the database. Normally, the System Administrator accesses this feature 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.

To open this dialog box from the Internal Setup Utility, click Settings > Rebuild Procedures and Triggers.

Select a schema you want to rebuild:

Admin schema

Allows you to rebuild the Admin schema.

Domain schema

Allows you to rebuild the schema of the domain you select from the Domain list.

Domain

Allows you to select the target domain if you choose to rebuild a Domain schema.

OK

Opens the Rebuilding Stored Procedures and Triggers dialog box where you can accept or specify a log file path and start the process. See Rebuilding Stored Procedures and Triggers.

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