Duplicate Activities causing query to fail when trying to delete.

When attempting to delete an Activity, the user receives an error message.  When tapping "View Details" on the error message, the user receives the below message of "More than one result was returned from Query.getSingleResult".

The cause of the duplicates has not been addressed.  Follow the below procedure to manually check and delete the duplicate from the database.

Step-1: Open the HANA Database Explorer using the link: SAP HANA Database Explorer for SAP HANA Cockpit

Step-2: Open the list of tables and search for the table TAE_TURNAROUND to get the information about the turnaround in question.

 

After the explorer is open from the left open the first database and right-click on Tables then click on Show Tables.

 

 

In the list of tables search for TAE_TURNAROUND on the top right search bar.

Validate the Schema Name to be USR_BOKFEKW1UQIR49ZB0UMWNTMFE and look for the Table name and right click and select Open Data.

 

 

Step-3: Find the required Turnaround Id.

Compare with the TUNRAROUND_NAME and copy the corresponding TURNAROUND_ID.

 

 

Step-4: Run a qery to get duplicate activities.

Open an SQL Console and paste the following query: SELECT ACTIVITY_ID FROM USR_BOKFEKW1UQIR49ZB0UMWNTMFE.TAE_ACTIVITY WHERE TURNAROUND_ID =

'6d32f860-c786-4fc4-9053-8dff9568ea7a' AND DELETED = 0 GROUP BY ACTIVITY_ID HAVING COUNT(ACTIVITY_ID) > 1;

Replace the text in red with the copied TURNAROUND_ID.

 

 

Click run and you should see the activities that are duplicated for that Turnaround.

Step-5: Delete/Change them one-by-one.

Open the Table TAE_ACTIVITY and Open Data and paste a selected activity id in the Search, it should display all the duplicated copies.

 

 

 

  

To Delete: To delete an activity set the deleted to 1 by clicking once in the cell to enter edit mode and set it to 1 and hit save.

 

 

 

 

To Keep Both Activities: Again enter edit mode this time on the ACTIVITY_ID column and change a number the id ranges from 1-9 and a-e. Hit save to save the new activity id.

 

 

 

 

Step-6: Run the same query to verify all duplicates have been deleted/changed.

From the SQL Console execute the same query and verify that this time there are 0 rows in the output.

 

• Related Articles

• Equipment Category Completeness graph shows any activities added after the Turnaround Start Date as “Remaining”

  The Equipment Category Completeness graph shows any activities added after the Turnaround Start Date as “Remaining”. This is a code bug. Workaround: There is no workaround for this issue. It will be corrected in the next release.

• When exporting the data to MS Excel for Activities, Equipment, or Scope, any date values are exported in a text value

  When exporting the data to MS Excel for Activities, Equipment, or Scope, any date values are exported in a text value. This causes an issue when bulk importing the data back end, the user receives an error this is not a valid date or date is missing. ...

• Equipment Area Null or Empty causing issues adding to Wall Chart

  The Equipment Area is not a required field when defining a piece of Equipment either via the Administrator -> Equipment App, or via the Bulk Import utility. However, when adding an Equipment to the Turnaround there is logic checking the Area to see ...

• Document Load Error using the SAP Documents or AsInt Inspection App

  Users are receiving the below "An exception has occurred.  Please contact SAP support for further investigation" when trying to add a Document to SAP master data using the SAP Documents App within the SAP IAM (Intelligent Asset Management) suite. ...

• CORE Inspection Widows Authentication Validation

  The CORE Inspection for Widows uses the Microsoft Cloud Authentication service to confirm the user on the Desktop or Mobile Windows device.  To check if the user is a valid Microsoft Online user, click the below and verify the login. ...