Learn about Database Integrity Utility

Lists improper or invalid data within the AVEVA Mobile Operator database that may cause problems with operation of the current version or with the upgrade process. Where possible, the recommended solution for each problem in the following list, which is sorted in alphabetical order, is provided.

Note: If a listed "Resolution" involves a SQL command that returns the error "Subquery returned more than 1 value…" then you must disable the triggers in the table affected by the query in order to successfully run the SQL command.
For example, the "Resolution" for the "Procedures with invalid (Dup Refs) chains" causes the error quoted above. The command begins with "update ismgt_profiles," so we will open the ISMGT_PROFILES table and disable its triggers.
To do so, open SQL Server Management Studio and connect to the database. Expand ISMGT_PROFILES and its list of triggers.

Right-click each trigger listed and select Disable. Then, run the SQL command again.
If it succeeds, you may proceed with any remaining "Resolution" steps before re-enabling the trigger(s).
If it fails, or if you are uncomfortable taking the above steps, contact Technical Support for assistance.