After you complete the upgrade, certain default views, which are supplied with Smart Instrumentation, might become invalid. This is because during the upgrade, the software makes changes to tables with which the default views are associated. Therefore, we recommend that after completing the upgrade, the System Administrator rebuild the default views for all the domains as follows.
-
When initializing a domain, a View-Only Domain schema password is created using the format <Domain schema logon name>_VIEW, for example: Red Plant_VIEW. If you then change the Domain name, you must still use the original View-Only Domain schema password to rebuild the default views.
-
You can only rebuild the default views supplied with the Smart Instrumentation database. You cannot rebuild any user-defined views.
-
Make sure that all users have logged out of the database before starting this procedure.
-
With the System Administration window open, click DBA > Rebuild Default Views in Domains.
-
From the Domain list, select the domain whose database views you want to rebuild.
-
In the View-Only Domain schema password box, enter the logon password of the View-Only Domain schema. The password characters appear masked.
You can change the password only once, when initializing a new domain. If you did not change the password when initializing the selected domain, enter the
default logon password, which is <Domain schema logon name>_VIEW.
-
If working on SQL Server, type the SQL Server System Administrator’s password.
-
Click OK to start rebuilding the views of the selected domain.