RS03283: SQLCODE=-302, SQLSTATE=22001, DRIVER=3.61.65

IBM Operational Decision Manager V8.10.1 Download Document
Operational Decision Manager for z/OS 8.10.1 Mod Pack
Operational Decision Manager V8.10.1 Mod Pack
Operational Decision Manager V8.9.2.2 Fix Pack
Operational Decision Manager for z/OS 8.9.2.2 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 18
Operational Decision Manager V8.9.2.1: Interim Fix 20
Operational Decision Manager V8.9.2.1: Interim Fix 22
Operational Decision Manager V8.9.2.1: Interim Fix 23
Operational Decision Manager V8.9.2.1: Interim Fix 24
Operational Decision Manager V8.9.2.1: Interim Fix 26
Operational Decision Manager V8.9.2.1: Interim Fix 27
Operational Decision Manager V8.9.2.1: Interim Fix 28
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.9.2.1: Interim Fix 34

APAR status

• Closed as program error.

Error description

• IlrSQLInvocat E   SELECT PROJECT, ELTORIGINALID, TYPE FROM
  DB2USER3.BRSTUDIO WHERE UUID = schemas/XXX/YYY/ZZZ
          Error: com.ibm.db2.jcc.am.SqlDataException: The value
  of a host variable in the EXECUTE or OPEN statement is out of
  range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001,
  DRIVER=3.61.65
          at com.ibm.db2.jcc.am.ed.a(ed.java:668)
          at com.ibm.db2.jcc.am.ed.a(ed.java:60)
          at com.ibm.db2.jcc.am.ed.a(ed.java:127)
          at com.ibm.db2.jcc.am.gn.c(gn.java:2554)
          at com.ibm.db2.jcc.am.gn.a(gn.java:2061)
          at com.ibm.db2.jcc.t4.cb.n(cb.java:829)
          at com.ibm.db2.jcc.t4.cb.i(cb.java:265)
          at com.ibm.db2.jcc.t4.cb.c(cb.java:54)
          at com.ibm.db2.jcc.t4.q.c(q.java:44)
          at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
          at com.ibm.db2.jcc.am.gn.ib(gn.java:2056)
          at com.ibm.db2.jcc.am.hn.b(hn.java:3897)
          at com.ibm.db2.jcc.am.hn.b(hn.java:4027)
          at com.ibm.db2.jcc.am.hn.dc(hn.java:683)
          at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:657)
          at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuer
  y(WSJdbcPreparedStatement.java:1220)
          at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(W
  SJdbcPreparedStatement.java:738)
          at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown
  Source)
          at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
          at java.lang.reflect.Method.invoke(Method.java:508)
          at
  ilog.rules.teamserver.transaction.logger.IlrStatementInvocationH
  andler.executeStatement(IlrStatementInvocationHandler.java:59)
          at
  ilog.rules.teamserver.transaction.logger.IlrPreparedStatementInv
  ocationHandler.invoke(IlrPreparedStatementInvocationHandler.java
  :32)
          at com.sun.proxy.$Proxy56.executeQuery(Unknown Source)
          at
  ilog.rules.teamserver.ejb.service.dao.util.IlrHandleBrstudioData
  .isArtifactUuidAlreadyKnown(IlrHandleBrstudioData.java:161)
          at
  ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.checkUUI
  Ds(IlrElementDAOJDBC.java:12489)
          at
  ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.checkUUID
  s(IlrSessionFacadeImpl.java:7595)
          at
  sun.reflect.GeneratedMethodAccessor791.invoke(Unknown Source)
          at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
          at java.lang.reflect.Method.invoke(Method.java:508)
          at
  ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand
  ler.invoke(IlrTransactionalInvocationHandler.java:74)
          at com.sun.proxy.$Proxy188.checkUUIDs(Unknown Source)
          at
  ilog.rules.teamserver.model.impl.IlrAbstractSession.checkUUIDs(I
  lrAbstractSession.java:2165)
          at
  ilog.rules.teamserver.model.dataaccess.DataProvider.prepareCreat
  e(DataProvider.java:1294)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users in the Decision Center                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SQL Exception with DB2 when synchronizing a resource with a  *
  * FQN longer than 46 chars.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The problem is fixed.
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R892 PSY

     UP