IJ37745: THE ATTEMPT TO DELETE THE PARENT OF A LOCATION HAS THE UNDESIRED EFFECT THAT IT DELETES THE LOCANCESTOR TABLE ROWS EVEN THOUGH I

APAR status

• Closed as program error.

Error description

• Description:
  The attempt to delete the parent of a Location has the undesired
  effect that it deletes the locancestor table rows even though it
  was "undeleted"
  
  STEP 1
  Locations -> NEW
  
  LOC200, Type OPERATING Save
  More Actions -> Associate Systems with Location -> NEW Row
  System: LAN
  Parent: LEG-1
  Open Drilldown -> See that the Child and parent is there ok
  
  Request these SQL from database:
  select * from maximo.locancestor where location='LOC200';
  select * from maximo.locancestor where location='LEG-1';
  NOTE: This will return the rows that show the parent child
  relationship
  
  STEP 2
  Locations -> LOC200
  See section Parent of LOC200 in the LAN System
  Delete icon of the LEG-1 row
  Undelete icon of the LEG-1 row
  Save
  
  Request these SQL from database:
  select * from maximo.locancestor where location='LOC200';
  select * from maximo.locancestor where location='LEG-1';
  NOTE: There is no data returned.
  Open Drilldown -> See that the Child and parent are still there
  
  CURRENT ERROUNEOUS RESULT:
  The maximo.locancestor table has no data
  
  EXPECTED RESULT:
  Since the delete action was undeleted, the data should still be
  present.
  
  PRODUCT:
  TPAE 7611
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The attempt to delete the parent of a Location has the       *
  * undesired effect that it deletes the locancestor table rows  *
  * even though it was "undeleted"                               *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Produc_
  

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