Fixes are available
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 number
RS03283
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
892
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-29
Closed date
2019-02-27
Last modified date
2019-02-27
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
Document Information
Modified date:
03 November 2021