RS01421: [DC]SQLEXCEPTION ON DERBY DATABASE WHEN GENERATING A RULEAPP

Operational Decision Manager V8.5.1 Mod Pack
Operational Decision Manager V8.0.1.2 Fix Pack

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 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