IJ37736: JSON MAPPING INCLUDES BRANCH FROM JSON OBJECT MAPPING SECTION EVEN WHEN ITS CONDITIONS ARE NOT MET

APAR status

• Closed as program error.

Error description

• JSON Mapping includes branch from JSON Object Mapping section
  even when its conditions are not met. An asset record is changed
  (not the description) and saved. Afterwards the description from
  another asset is changed to anything else and saved. In Message
  Tracking check the last 2 messages.  One will have the geometry
  branch empty, but still there, while the other has the geometry
  branch with information in it.
  Outbound message when conditions are met:
  [{"maximoObjectInfo":{"whereClause":"FACILITYID='HYD-114'","fea
  tureClass":"WHYDRANT","mboName":"ASSET","mboUniqueIdName":"ASSE
  TUID","mboUniqueIdValue":2790,"systemRecord":"ARCGIS"},"attribu
  tes":{"LOCDESC":"NO_GEO"},"geometry":{"x":"1037087.2248575911",
  "y":"1860642.1780218557"}}]
  Outbound message when conditions are not met:
  [{"maximoObjectInfo":{"whereClause":"FACILITYID='HYD-114'","fea
  tureClass":"WHYDRANT","mboName":"ASSET","mboUniqueIdName":"ASSE
  TUID","mboUniqueIdValue":2790,"systemRecord":"ARCGIS"},"attribu
  tes":{"LOCDESC":"11132"},"geometry":{}}]
  The geometry is being included (albeit empty) even when the
  condition set in JSON Mapping is not being met.
  
  STEPS TO REPRODUCE:
  1. Go to JSON Mapping.
  2. Open an outbound JSON Mapping record.
  3. Go to the Properties tab.
  4. Choose a row from JSON Object Mapping which contains a
  property path that's not in the root of the JSON object.
  5. Add a condition to it. (eg. attr$DESCRIPTION=="TEST")
  
  RESULT:
  When the condition isn't met, Maximo still includes the branch
  in the outbound JSON object, but empty, which causes errors in
  the other system which is receiving the message.
  
  EXPECTED RESULT:
  Branch not to be included in the outbound message.
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2
  IBM Maximo Spatial Asset Management 7.6.1.0
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Json Mapping produced empty object or array when a condition *
  * to exclude the object is defined in JSON mapping             *
  ****************************************************************
  

Problem conclusion

• Fixed
  

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 SPATIAL

• Fixed component ID

  5724T3900

Applicable component levels