JR50504: ALERTDB.GETEVENTALERTDEFS - DB2 SQL ERROR: SQLCODE: -811, SQLSTATE: 21000, SQLERRMC: NULL

IBM WebSphere Partner Gateway, Advanced Edition, v6.2.1 Fixpack 4
IBM WebSphere Partner Gateway, Enterprise Edition, v6.2.1 Fixpack 4

APAR status

• Closed as program error.

Error description

• Environment:  AIX WPG 6.2.1.3 DB2 9.5.10
  *
  Customer is experiencing an issue where when WPG sends out
  alerts that they encounter a SQL -811 and so the messages are
  rolled back and the messages become in a Blocked state on the
  AlertEventQ.  Here is an example of the error message in the
  logs:
  
  [6/5/14 19:20:02:272 UTC] 00000223 AlertDB E
  com.ibm.bcg.alertEng.AlertDB dbError AlertDB.getEventAlertDefs
  - Error: com.ibm.db2.jcc.a.SqlException: DB2 SQL error:
  SQLCODE: -811, SQLSTATE: 21000, SQLERRMC: null at
  com.ibm.db2.jcc.a.lg.d(lg.java:1344) at
  com.ibm.db2.jcc.b.gb.k(gb.java:351) at
  com.ibm.db2.jcc.b.gb.e(gb.java:96) at
  com.ibm.db2.jcc.b.w.e(w.java:83) at
  com.ibm.db2.jcc.b.vb.h(vb.java:164) at
  com.ibm.db2.jcc.a.lg.q(lg.java:1315) at
  com.ibm.db2.jcc.a.mg.d(mg.java:2404) at
  com.ibm.db2.jcc.a.ng.X(ng.java:115) at
  com.ibm.db2.jcc.a.ng.execute(ng.java:98) at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJ
  dbcPreparedStatement.java:938) at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbc
  PreparedStatement.java:614) at
  com.ibm.bcg.co.db.CallableStatementWrapper_DB2.execute(CallableS
  tatementWrapper_DB2.java:107) at
  com.ibm.bcg.alertEng.AlertDB.getEventAlertDefs(AlertDB.java:174)
  at com.ibm.bcg.alertEng.AlertDB.getEventAlerts(AlertDB.java:67)
  at
  com.ibm.bcg.alertEng.eventAlert.EventAlertGenerator.getAlerts(Ev
  entAlertGenerator.java:48) at
  com.ibm.bcg.alertEng.eventAlert.AlertEventEngineMessageHandler.p
  rocessReceivedMsgObj(AlertEventEngineMessageHandler.java:146)
  at
  com.ibm.bcg.util.jms.MessageHandler.processReceivedMessage(Messa
  geHandler.java:139) at
  com.ibm.bcg.alertEng.eventAlert.AlertEventEngineMessageHandler.o
  nReceive(AlertEventEngineMessageHandler.java:128) at
  com.ibm.bcg.server.common.TransControllerBean.onReceive(TransCon
  trollerBean.java:105) at
  com.ibm.bcg.server.common.EJSLocalStatelessTransController_5c554
  616.onReceive(Unknown Source) at
  com.ibm.bcg.server.common.BaseMDB.onMessage(BaseMDB.java:194)
  at
  com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(Mes
  sageEndpointHandler.java:1093) at
  com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpo
  intHandler.java:778) at
  com.sun.proxy.$Proxy22.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:900) at
  com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaW
  ork.run(SibRaSingleProcessListener.java:552) at
  com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at
  com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
  [6/5/14 19:20:02:294 UTC] 00000223 AlertEventEng 3
  com.ibm.bcg.alertEng.eventAlert.AlertEventEngineMessageHandler
  processReceivedMessage Rollback process triggered
  *
  Keywords: SQLException SQL Exception WPG Alerts Alert 811
  

Local fix

Problem summary

• APAR JR50504 delivered for the mentioned issue.
  

Problem conclusion

• iFix delivered. Closing APAR
  

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

  WEB PART GTWAY

• Fixed component ID

  5724L6900

Applicable component levels

• R621 PSY

     UP