IZ64359: NULL POINTER EXCEPTION ON INBOUND IF WHEN OBJECT HAS A DATE FIELD IN PRIMARY KEY

APAR status

• Closed as program error.

Error description

• Inbound IF transactions to an object which has a date
  datatype attribute as part of primary key will fail
  with a null pointer exception.
  
  To reproduce:
  
  Use Maximo 7.1.1.5 maxdemo system setup for IF.
  
  1. Create Object structure CEXCHANGE add Mbo EXCHANGE
  
  2. Create Publish Channel CEXCHANGEInterface
  3. Create Enterprise Service CEXCHANGEInterface.
  5. Add Pub Channel and Enterprise Srvc to External System.
  Enable. Enable.
  6. Data Export one exchange rate.
  7. Modify root xml from Publish to Sync, change exchange rate
  8. Import xml.
  9. Fails with null pointer exception:
  
  29 Oct 2009 12:14:20:921 [ERROR]  java.lang.NullPointerException
  
  at java.util.Calendar.setTime(Calendar.java:1032)
  at java.text.SimpleDateFormat.format(SimpleDateFormat.java:785)
  at java.text.SimpleDateFormat.format(SimpleDateFormat.java:778)
  at java.text.DateFormat.format(DateFormat.java:314)
  at psdi.util.MXFormat.dateTimeToString(MXFormat.java:1007)
  at
  psdi.iface.mos.MosProcessImpl.createMboSet(MosProcessImpl.java:1
  076)
  at
  psdi.iface.mos.MosProcessImpl.createMboSet(MosProcessImpl.java:1
  005)
  at
  psdi.iface.mos.MosProcessImpl.processMboSet(MosProcessImpl.java:
  978)
  at
  psdi.iface.mos.MosProcessImpl.setMainMaximoTable(MosProcessImpl.
  java:544)
  at
  psdi.iface.mos.MosProcessImpl.fillMaximoTables(MosProcessImpl.ja
  va:369)
  at
  psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl
  .java:273)
  at
  psdi.iface.mic.MicSetIn.processExternalData(MicSetIn.java:151)
  at psdi.iface.mic.MicService.processDataIn(MicService.java:1189)
  at
  psdi.iface.mic.MicService.processExternalData(MicService.java:10
  95)
  at
  psdi.iface.load.FileLoaderProcess.processData(FileLoaderProcess.
  java:470)
  etc..
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Only users which use objects where key       *
  *                 include date filed                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: see issue                               *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  NULL POINTER EXCEPTION ON INBOUND IF WHEN OBJECT HAS A DATE
  FIELD IN PRIMARY KEY
  

Problem conclusion

• Set column name instead of column value when getting data for a
  date field
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO INTEGRAT

• Fixed component ID

  5724R46I1

Applicable component levels

• R711 PSY

     UP