JR61501: MONGODB ODBC DRIVER RETURNS NULL KEY VALUES OF SECOND COLLECTION OF A LEFT JOIN

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as Vendor Solution.

Error description

• When a left join is used with MongoDB ODBC Driver, the driver
  may return NULL key values for the keys from the second
  collection. This version also fixes a problem where in in some
  cases the driver fails to properly normalize the collections
  (some collections may be missing after normalization).
  
  
  
  Note: Please create fresh schema map files after the driver is
  installed.
  
  
  
  This is a problem with the MongoDB ODBC Driver and has been
  fixed in the following builds:
  
  MongoDB Driver version: 08.01.0224 (B0486, U0336)
  
  MongoDB JAR version: 6.0.2.000430 (C0371.F000331.U000176)
  
  SchemaTool version: #71
  
  
  
  Please use ODBC Driver branded on or after 23rd September, 2019.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• This is a problem with the MongoDB ODBC Driver and has been
  fixed in the following builds:
  
  MongoDB Driver version: 08.01.0224 (B0486, U0336)
  MongoDB JAR version: 6.0.2.000430 (C0371.F000331.U000176)
  SchemaTool version: #71
  
  Make sure to create fresh schemamap files using schematool
  utility after the new driver has been installed.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels