Identify and Fix the Procedures Linked to ‘All Bases’

This script will capture the Procedures that are linked to ‘All Bases’.

The Procedures linked to ‘All Bases’ and the tables containing this Procedure records will prevent you from upgrading to the current version of AVEVA Mobile Operator 2020. Therefore, you must fix these Procedures prior to the upgrade.

Resolution

As a part of the resolution, the Procedures that are linked to ‘All Bases’ will be moved to another valid base by running the following script.

update sat_procedures set Base_FK = ‘<valid Base_ID>’

where Procedure_PK = '<ID of the Procedure linked to ‘All Bases’>’

After running the script, you can continue with the Database script for the upgrade.