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.
This dialog box is used by the System Administrator to identify abnormal database behavior and solve it by rebuilding the stored procedures and triggers in the database if the software displays inappropriate SQL messages when using Smart Instrumentation.
To open this dialog box, click DBA > Rebuild Stored 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.
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 Smart Instrumentation.