Response List Items with Duplicate Application-ApplicationItem

This script returns the Response List and Items having duplicate application and application item ID. The combination of application and application item id should be unique with in the system and cannot be blank.

Resolution:

Application ID and Application Item ID should be unique with in the system.You may have to fix the issue by manually updating the Application item ID for each of the Response List and Item.

After manually updating the duplicate IDs in the database, run the FindResponseListNItemWithDuplicateApplicationIdNApplicationItemId.sql script again to confirm that there are no further duplicate Application ID and Application Item IDs.

For example, suppose the Application item ID Pressure valve 1st Inspection is duplicate for the Application ID [A8BFF123-78ED-419B-B208-7149C84C8713]. You need to manually change the Application Item ID Pressure valve 1st Inspection to another value in the database which does not exist for that Application ID [A8BFF123-78ED-419B-B208-7149C84C8713].

The following template script will update the Application Item ID in the table(s).

UPDATE SAT_Response_Lists SET Application_Item_ID = <new value> Where Application_ID = <reported Application_ID> and Application_Item_ID = <reported Application_Item_ID>

UPDATE SAT_Response_List_Items SET Application_Item_ID = <new value> Where Application_ID = <reported Application_ID> and Application_Item_ID = <reported Application_Item_ID>

Note:
- A System of records, which is Application ID and Application Item ID, must uniquely identify the Response List (or Response List Item) from an external system (such as, an SAP system or an extension application using AVEVA Mobile Operator Extensibility SDK).
- User must have the knowledge of their system to select a <new value> for Application Item ID. The combination of Application ID and Application Item ID must be distinct.