IJ50318: SELF-REFERENCE OBJECT STRUCTURE CREATES DUPLICATE RECORDS WHEN IT HAS CHILD TABLES

APAR status

• Closed as program error.

Error description

• Problem Description
  Self-reference object structure creates duplicate records when
  it has child tables
  
  STEPS TO REPRODUCE:
  The steps below use MAXDEMO as an example:
  1)Go to Object Structure application and duplicate MXWOHIER
  object.
  Create a new Object with name MXWOHPF.
  
  Include the table WPTOOL and use the relationship WPTOOL.
  
  2)Create a new Enterprise Service MXWOHPF and use the Object
  Structure MXWOHPF.
  
  3)Assign and enable the Enterprise Service MXWOHPF into the
  External System EXTSYS1
  
  4)Import the XML below:
  
  <?xml version="1.0" encoding="UTF-8"?>
  <SyncMXWOHPF xmlns="http://www.ibm.com/maximo"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  creationDateTime="2023-03- 01T03:49:05-05:00" transLanguage="EN"
  baseLanguage="EN" messageID="1141816776605462396544">
  <MXWOHPFSet>
  <WORKORDER action="AddChange">
  <WONUM>F100374-01</WONUM>
  <SITEID>BEDFORD</SITEID>
  <DESCRIPTION>CMPWO</DESCRIPTION>
  <WPTOOL>
  <ITEMNUM>FORK</ITEMNUM>
  <ITEMQTY>1.0</ITEMQTY>
  </WPTOOL>
  </WORKORDER>
  </MXWOHPFSet>
  </SyncMXWOHPF>
  
  
  RESULTS:
  Wptool will be created twice in the Workorder F100374-01. The
  Workorder is processed twice.
  
  Observation:
  If wonum is restricted Work Order is created twice and each with
  one tool.
  
  EXPECTED RESULTS:
  Workorder should proceed once.
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.3
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * _MAXIMO_                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SELF-REFERENCE OBJECT STRUCTURE CREATES DUPLICATE RECORDS    *
  * WHEN IT HAS CHILD TABLES                                     *
  ****************************************************************
  

Problem conclusion

• the fix for this APAR is contained in the future maintenance
  package.
  

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:

Modules/Macros

• _MAXIMO_
  

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels