IJ36912: DELETING A WO CAN RESULT IN DELETION OF UNRELATED INSPECTIONRESULT RECORDS.

APAR status

• Closed as program error.

Error description

• Work Order Tracking / Conduct an Inspection
  
  Under certain conditions, deleting a WO can result in the
  deletion of InspectionResult records that are not related to the
  WO being deleted.
  
  
  STEPS TO REPRODUCE:
  
  
  1)  Confirm Default Insert Site is BEDFORD.
  
  
  
  2)  Go To Work Order Tracking.
  
  
  3)  Create a new WO with Location = AIR211.
  
  
  
  4)  Add a row to the "Multiple Assets, Locations, and CIs"
  table with Location = AIR212.
  
  
  
  5)  Save the WO.
  
  
  
  6)  Enter "1001" in the Inspection Form field on both the WO
  and the "Multiple Assets, Locations, and CIs" table row.
  
  
  
  7)  Save the WO.
  
  
  
  8)  Go into SQL Developer (or other SQL Tool) and run the
  following:
  
  SELECT * FROM InspectionResult ORDER BY InspectionResultID DESC
  ;
  
  
  
  9)  Find the MULTIASSETLOCCI record just added for Location
  AIR212 and make a note of the ReferencObjectID and the
  InspectionResultID.
  
  
  
  10) Back in Work Order Tracking, create another WO but change
  the "Work Order" field (delete the wonum generated) to the value
  in the ReferencObjectID above.
  
  
  
  11) Save the WO.
  
  
  
  12) Delete the WO that was just saved.
  
  
  
  13) Repeat the SQL statement in Step 8.
  
  RESULTS:
  
  MULTIASSETLOCCI record for Location AIR212 no longer appears
  because it was deleted.
  
  SQL logging enabled and set to INFO: the following statement
  will be logged:
  
  select * from inspectionresult where referenceobjectid =
  '4558' and siteid = 'BEDFORD'
  
  several lines below the above sql statement  the following
  statement will be logged:
  
  delete from inspectionresult where inspectionresultid=? and
  rowstamp=?
  
  Bind value for INSPECTIONRESULTID = 485 (the actual value
  should match the ReferencObjectID from Step 9.)
  
  The problem is the code is searching for InspectionResult
  records related to the WO without checking the ReferencObject
  field which results in the deletion of unrelated
  InspectionResult records.
  
  
  
  EXPECTED RESULTS:
  
  a) If a WO is deleted, it should only delete InspectionResult
  records WHERE ReferenceObjectID = :WONum and SiteID = :SiteID
  and ReferenceObject IN ('PARENTWO', 'WOACTIVITY', 'WORKORDER').
  
  b) Attempts to delete a WO with related InsepctionResult
  records in a Status other than PENDING (or synonym) should
  result in an error.
  
  c) An error should also be raised if a related PARENTWO
  InspectionResult record is found and it has related WOACTIVITY,
  WORKORDER, or MULTIASSETLOCCI records belonging to a different
  WOs.
  
  
  
  REPORT IN VERSION:
  
  Maximo: 7612 ,  Work Center 7604
  

Local fix

• na
  

Problem summary

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: | Release 7.6.1.3 of Base Services
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels