IJ41573: INSPRESULTSTATUS RECORDS NOT DELETED WHEN INSPECTIONRESULT RECORDS ARE DELETED

APAR status

• Closed as program error.

Error description

• Whenever a Status-able object in Maximo is deleted, any related
  Status History records are also deleted. That is not happening
  with InspResultStatus records when the related InspectionResult
  records are deleted.
  
  STEPS TO REPRODUCE:
  
  1) In Work Order Tracking, add a new WO in BEDFORD Site with
  Location = AIR100 and Inspection Form = 1001
  2) Add a row to the "Multiple Assets, Locations, and CIs" table
  with Location = AIR101 and Inspection Form = 1001
  3) SAVE the WO.
  4) You should see the Inspection Result fields populated on the
  WO and on the "Multiple Assets, Locations, and CIs" table row.
  Make a note of their values.
  5) Delete the WO.
  6) In SQLDeveloper run the following:
  
  SELECT * FROM InspectionResult ORDER BY ResultNum DESC ;
  SELECT * FROM InspResultStatus ORDER BY ResultNum DESC ;
  
  You will see that the InspectionResult records with the
  ResultNum values from STEP 4 no longer exist but their related
  InspResultStatus records still do.
  
  EXPECTED RESULTS:
  That the records would have been deleted.
  
  
  Reported in Version:
  
  IBM Maximo 7.6.1.2
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Whenever a Status-able object in Maximo is deleted, any      *
  * related                                                      *
  * Status History records are also deleted. That is not         *
  * happening                                                    *
  * with InspResultStatus records when the related               *
  * InspectionResult                                             *
  * records are deleted.                                         *
  ****************************************************************
  

Problem conclusion

• This will be fixed in a future release.
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels