Fixes are available
APAR status
Closed as program error.
Error description
A SQL exception is thrown in DC when trying to generate a ruleApp. This happens when the main rule project depends on another rule project which is having a large BOM and only on Derby V10.8.2, or 10.9.1 >> FFDC Exception:java.sql.SQLException SourceId:com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getClob ProbeId:1064 Reporter:com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet@ebd03ace java.sql.SQLException: The data in this BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be committed, its connection closed or it has been freed. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException (Unknown Source) ... at ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.getCLobV alue(IlrElementDAOJDBC.java:5291) at ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.getCLob( IlrElementDAOJDBC.java:5315) ... at ilog.rules.teamserver.ejb.ruleset.IlrRulesetArchiveGenerator.add BOMsToBaseline(IlrRulesetArchiveGenerator.java:1042) at ilog.rules.teamserver.ejb.ruleset.IlrRulesetArchiveGenerator.add NonPackageElementsToBaseline(IlrRulesetArchiveGenerator.java:988 ) at ilog.rules.teamserver.ejb.ruleset.IlrRulesetArchiveGenerator.gen erateRulesetArchive(IlrRulesetArchiveGenerator.java:160) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.generateR CEArchive(IlrSessionFacadeImpl.java:3985) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.generateR ulesetArchive(IlrSessionFacadeImpl.java:3941) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.createRul eAppArchive(IlrSessionFacadeImpl.java:4371) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.generateR uleAppArchive(IlrSessionFacadeImpl.java:4297) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand ler.invoke(IlrTransactionalInvocationHandler.java:35) at com.sun.proxy.$Proxy51.generateRuleAppArchive(Unknown Source) at ilog.rules.teamserver.model.impl.IlrAbstractSession.generateRule AppArchive(IlrAbstractSession.java:633) at ilog.rules.teamserver.web.beans.RuleAppBean.generateRuleApp(Rule AppBean.java:365)
Local fix
Workaround: Use Derby 10.5.3 instead
Problem summary
With the latest version of Derby we need to process BLOB and CLOB attribute differently.
Problem conclusion
The derby dao driver is modified to include specific code to process LOB data.
Temporary fix
Comments
APAR Information
APAR number
RS01421
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-09
Closed date
2013-10-10
Last modified date
2013-10-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Fixed component name
WS DECISION CTR
Fixed component ID
5725B6900
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
03 November 2021