IJ28690: BMXAA9233E - ERROR PARSING JSON DATA WHEN PREVIEWING DATA IMPORT IN THE EXTERNAL SYSTEM APPLICATION

APAR status

• Closed as program error.

Error description

• PROBLEM:
  Error when previewing data import in the External
  System application.
  
  BMXAA5598E - Processing of an inbound
  transaction failed. The processing exception is identified in
  document 2 which starts at line {1} and ends at line
  {2}.
  BMXAA9233E - Error parsing JSON data.
  Unexpected
  character: [<] while scanning JSON String for JSON type.
  Invalid JSON.
  BMXAA5598E - Processing of an inbound transaction
  failed. The processing exception is identified in document 3
  which starts at line {1} and ends at line {2}.
  BMXAA9233E -
  Error parsing JSON data.
  
  The problem happens if you use
  recurrence of inbound transactions using Event Filter class or
  Automation script and checking "Publish JSON" check box in the
  Publish Channel.
  
  If you import the same file directly, it will
  be processed successfully.
  
  
  STEPS TO REPRODUCE:
  
  1.) Select a
  Publish Channel
  
  Integration --> Publish Channel --> Duplicate
  MXASSETInterface for example
  
  - Select the Publish JSON?
  checkbox
  
  Save and Enable Listener.
  
  2.) Add the Publish
  Channel to an External System
  
  3.) Create Integration Script or
  Java Class for Integration to force outbound transaction:
  
  In
  this example an Integration Script will be used:
  
  Automation
  Scripts --> Create --> Script for Integration
  
  - Publish
  Channel = select the Publish Channel created in the step 1
  -
  Event Filter
  
  In the Script Details keep the default
  information
  
  Body:
  
  evalresult = False
  
  Enable the script and
  save.
  
  4.) Use an enterprise service to import ASSET
  Information using a flat file.
  
  In this example was used a new
  Object Structure with only ASSET object and MAXDEMO data:
  
  EXTS
  YS1,ASSETTEST,AddChange,EN
  ASSETNUM,ASSETUID,DESCRIPTION,LOCATIO
  N,ORGID,SITEID
  1,35,Motor- 10hp/1750rpm/TEFC/254T
  Frame/440v/3ph/60hz,AIR102,EAGLENA,BEDFORD
  2,35,Motor-
  10hp/1750rpm/TEFC/254T
  Frame/440v/3ph/60hz,AIR102,EAGLENA,BEDFORD
  
  
  Check "Import
  Preview" checkbox.
  
  The issue only happens when using more than
  1 record in the file.
  
  RESULTS:
  
  BMXAA5598E - Processing of an
  inbound transaction failed. The processing exception is
  identified in document 2 which starts at line {1} and ends at
  line {2}.
  BMXAA9233E - Error parsing JSON data.
  
  EXPECTED
  RESULT:
  
  Receive the message:
  BMXAA5621I - The data import
  preview mode is successful.
  
  
  PRODUCT VERSION:
  Tivoli's process
  automation engine 7.6.1.1
  IBM Tpae Integration Framework
  7.6.1.1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAA9233E - ERROR PARSING JSON DATA WHEN PREVIEWING DATA    *
  * IMPORT IN THE EXTERNAL SYSTEM APPLICATION                    *
  ****************************************************************
  

Problem conclusion

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

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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels