Fixes are available
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 number
RS01944
Reported component name
WDS FOR RULES
Reported component ID
5725B6903
Reported release
870
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-03-27
Closed date
2015-04-06
Last modified date
2015-04-06
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
[{"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":"870","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
17 February 2022