IT17426: MAPPING NODE JAVA NULLPOINTER EXCEPTION WHEN SELECTING DEFAULT DATE VALUE FROM AN ISERIES (AS400) DATABASE

APAR status

• Closed as program error.

Error description

• A JDBC SQL "SELECT" call from the Mapping node fails with a Java
  NullPointer exception when it accesses a table in an iSeries
  (AS400) database where a column with datatype "DATE"  contains a
  default value "0001-01-01"
  

Local fix

• Populate the DATE type column with a valid non default value.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of the IBM Integration Bus Mapping Node making an SQL
  Selection from an AS400 database table which has a column with
  data type "DATE" that contains a default value.
  
  
  Platforms affected:
  z/OS, MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  A JDBC SQL "SELECT" call from the Mapping node fails with a Java
  NullPointer exception when it accesses a table in an iSeries
  (AS400) database where a column with datatype "DATE"  contains a
  default value "0001-01-01"
  
  An error and Java stack trace similar to the following example
  may appear in the system log:
  
  XProcessException java.lang.NullPointerException'
  
  {com.ibm.broker.ct.mapping.MappingNode@-f3afe52.getCurrentXQuery
  Script
   { MapResourceManager.getXQueryForMap , 'root map
  identifier:{default}:AS400Connect_Mapping'
   { MapResourceManager.getQName , 'supplied
  string:{default}:AS400Connect_Mapping'
   { MapResourceManager.getQName ,
  'QName:{default}AS400Connect_Mapping'
   } MapResourceManager.getQName
   { MapResourceManager.getXQueryForMap , ': QName we're looking
  for={default}AS400Connect_Mapping'
   MapResourceManager.getXQueryForMap 'Not yet cached valid
  XQuery, so invoke prepare for map {default}AS400Connect_Mapping'
   { MapResourceManager.prepareMap ,
  'Map:{default}:AS400Connect_Mapping Contxt: MAPPING_NODE_ERRHND'
  
  
  There are a number of resource name changes between WebSphere
  Message Broker and IBM Integration Bus Version 9.0.  For details
  visit
  http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e
  tools.mft.doc/bb23814_.htm
  

Problem conclusion

• The product no longer throws a Java NullPointerException when
  retrieving a default date from a database table column of type
  "DATE".
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.8
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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 BUS

• Fixed component ID

  5724J0540

Applicable component levels

• RA00 PSY

     UP