RS01944: SQLDATAEXCEPTION WHEN DEPLOYING A RULEAPP WITH LONG RULEAPP/RULE SET DESCRIPTION

Operational Decision Manager V8.7.1 Download Document
Operational Decision Manager V8.7.1 Refresh Pack

APAR status

• Closed as fixed if next.

Error description

• When deploying a ruleapp from a deployment configuration
  an exception about a truncation error with a string
  longer than 256 such as the following occurs:
  [3/27/15 12:52:56:730 CDT] 000000ab sql           W   An error
  occurred when executing the SQL query.
                                   java.sql.SQLDataException: A
  truncation error was encountered trying to shrink VARCHAR 'This
  operation aggregates the complete logic. Its purpose is&' to
  length 256.
   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.
  getSQLException(Unknown Source)
   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(
  Unknown Source)
   at org.apache.derby.impl.jdbc.TransactionResourceImpl.
  wrapInSQLException(Unknown Source)
   at org.apache.derby.impl.jdbc.TransactionResourceImpl.
  handleException(Unknown Source)
   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(
  Unknown Source)
   at org.apache.derby.impl.jdbc.ConnectionChild.handleException(
  Unknown Source)
   at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(
  Unknown Source)
   at org.apache.derby.impl.jdbc.EmbedPreparedStatement.
  executeStatement(Unknown Source)
   at org.apache.derby.impl.jdbc.EmbedPreparedStatement.
  executeUpdate(Unknown Source)
   at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.
  executeUpdate(Unknown Source)
   at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
  pmiExecuteUpdate(WSJdbcPreparedStatement.java:1187)
   at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
  executeUpdate(WSJdbcPreparedStatement.java:804)
   at ilog.rules.res.persistence.impl.jdbc.helper.
  IlrDatabaseUtility.executeUpdate(IlrDatabaseUtility.java:105)
   at ilog.rules.res.persistence.impl.jdbc.helper.
  IlrRulesetsTable.insert(IlrRulesetsTable.java:166)
   at ilog.rules.res.persistence.impl.jdbc.
  IlrGenericRepositoryDAO.addRuleApp(IlrGenericRepositoryDAO.java:
  351)
  ....
  

Local fix

• Use a shorter ruleapp/ruleset description
  

Problem summary

• The description column is limited to 256 characters in the RES
  table. The description should be truncated.
  The fix will be included in the version following 8.7.0
  

Problem conclusion

Temporary fix

• Manually truncate description that are longer than 256
  characters.
  

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

Applicable component levels

• R870 PSY

     UP