IV70736: MIF ERROR: ORA-01400: CANNOT INSERT NULL INTO ("MAXIMO"."MAXINTERRORMSG"."ERROR")

APAR status

• Closed as program error.

Error description

• When MIF processing raises a NullPointerException the following
  ORA error is observed because the actual MIF ERROR value is
  NULL:
  
  [2/19/15 9:14:58:250 MST] 000000a1 SystemOut     O 19 Feb 2015
  09:14:58:250 [ERROR] [WAMMIF21] [] ORA-01400: cannot insert
  NULL into ("MAXIMO"."MAXINTERRORMSG"."ERROR")
  
  java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
  cannot insert NULL into ("MAXIMO"."MAXINTERRORMSG"."ERROR")
  
   at
  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
   at
  oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at
  oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
   at
  oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
  ment.java:207)
   at
  oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPrepar
  edStatement.java:1044)
   at
  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
  atement.java:1329)
   at
  oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
  ePreparedStatement.java:3584)
   at
  oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OracleP
  reparedStatement.java:3665)
   at
  oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
  OraclePreparedStatementWrapper.java:1352)
   at
  psdi.iface.jms.MessageErrorHandler.insertErrorTable(MessageError
  Handler.java:797)
   at
  psdi.iface.jms.MessageErrorHandler.updateErrorTable(MessageError
  Handler.java:957)
   at
  psdi.iface.jms.MessageErrorHandler.handleError(MessageErrorHandl
  er.java:383)
   at
  psdi.iface.jms.JMSContQueueProcessor.processMessage(JMSContQueue
  Processor.java:245)
   at
  psdi.iface.jms.JMSListenerBean.onMessage(JMSListenerBean.java:20
  3)
   at
  com.ibm.ejs.container.WASMessageEndpointHandler.invokeJMSMethod(
  WASMessageEndpointHandler.java:138)
   at
  com.ibm.ws.ejbcontainer.mdb.MessageEndpointHandler.invokeMdbMeth
  od(MessageEndpointHandler.java:1146)
   at
  com.ibm.ws.ejbcontainer.mdb.MessageEndpointHandler.invoke(Messag
  eEndpointHandler.java:844)
   at com.sun.proxy.$Proxy27.onMessage(Unknown Source)
   at
  com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEn
  dpoint(JmsJcaEndpointInvokerImpl.java:233)
   at
  com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDis
  patcher.java:919)
   at
  com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaW
  ork.run(SibRaSingleProcessListener.java:592)
   at
  com.ibm.ejs.j2c.work.WorkProxy$RunWork.run(WorkProxy.java:281)
   at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:298)
   at javax.security.auth.Subject.doAs(Subject.java:495)
   at
  com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:13
  2)
   at
  com.ibm.ejs.j2c.work.WorkProxy$RunWork.run(WorkProxy.java:284)
   at
  com.ibm.ws.security.util.AccessController.doPrivileged(AccessCon
  troller.java:63)
   at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:666)
   at
  com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
  [2/19/15 9:14:58:250 MST] 000000a1 SystemOut     O 19 Feb 2015
  09:14:58:250 [ERROR] [WAMMIF21] [] BMXAA4210E - Database error
  number 1400 has occurred. Invalid SQL queries are logged in the
  log file. Check the SQL query to identify the error.
   ORA-01400: cannot insert NULL into
  ("MAXIMO"."MAXINTERRORMSG"."ERROR")
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Any user which gets NullPointer Exception during processing  *
  * transaction from Queue                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When Null pointer Exception happen during the processing the *
  * message or this transaction is null. So when message         *
  * reprocessing i writing to error table ERRORCODE column it    *
  * tries to insert null but column configures as required. So   *
  * insert fails.                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The only way to avoid this problem now is to make column     *
  * nullable                                                     *
  ****************************************************************
  

Problem conclusion

• Check need to be added for null error message and put message
  stating that nullpointer exception was thrown
  

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

• MIF
  

Fix information

• Fixed component name

  MAXIMO SYSTEMS

• Fixed component ID

  5724R46AV

Applicable component levels