PH30006: MONGODB ADAPTER BASED ITX MAPS READING ANY INTEGER LARGER THAN 2,147,483,647 FAIL INPUT VALIDATION AS MONGODB SWITCHES TO 64BIT

APAR status

• Closed as program error.

Error description

• This issue can be seen when using the MongoDB adapter as a
  source on any IBM Tranformation Extender (ITX) map, reading an
  integer that is larger than 2,147,483,647.
  
  After 2,147,483,647, then Mongo switches to using a NumberLong
  format, as it can no longer output the number as a 32bit
  integer, and switches to a 64bit integer model.
  
  The ITX map will fail, as the data no oonger matches the
  metadata, and the reason will be listed as invalid input.
  

Local fix

• ITXCQ - ITX00060566
  PB / PB
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users of MongoDB adapter.
  
  Problem Description:
  MongoDB adapter returns the Extended BSON data type values
  (NumberLong, NumberDecimal, NumberInt) for numerical values
  instead of plain-decimal/long/int values to the map which
  results in transformation failures.
  
  Platforms Affected:
  All
  

Problem conclusion

• Fixed multiple issues with MongoDB adapter where it now reports
  error when connectivity to MongoDB fails, suppresses the driver
  logging by default, returns numerical data in relaxed mode
  instead of extended BSON data type to avoid transformation
  failures.
  
  Applies to:
  9.0.0.4, 10.0.0.0, 10.0.3.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels