Cisco Bug: CSCum48680 - DE1548 - Exception generated when report/KPI name too long for TCA
Last Modified
Jul 03, 2014
Products (1)
- Cisco Prime Performance Manager
Known Affected Releases
1.4(1) 1.5
Description (partial)
Symptom: The following exception is generated in PPM gateway log (sgmConsole) when KPI and report name are over 100 chars long. Result is that TCA is created but never fires. 2014/01/08 10:34:14: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'StarOS KPI LTE to Gn/Gp Handover Success Rate - P-GW 15 Minu&' to length 100. 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) 2014/01/08 10:34:14: at com.cisco.mwg.sgm.db.PreparedStatement.executeUpdate(PreparedStatement.java:268) 2014/01/08 10:34:14: at com.cisco.mwg.sgm.db.DBQueryManagerImpl.executeUpdate(DBQueryManagerImpl.java:358) 2014/01/08 10:34:14: at com.cisco.mwg.sgm.db.UpdateQuery.execute(UpdateQuery.java:149) 2014/01/08 10:34:14: at com.cisco.mwg.sgm.db.DBConnectionPool$CachedQueryProcessor.run(DBConnectionPool.java:1385) 2014/01/08 10:34:14: at java.lang.Thread.run(Unknown Source) 2014/01/08 10:34:14: Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR 'StarOS KPI LTE to Gn/Gp Handover Success Rate - P-GW 15 Minu&' to length 100. 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) 2014/01/08 10:34:14: at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) 2014/01/08 10:34:14: ... 14 more Conditions: When KPI and report name are over 100 chars long.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Status
- Severity
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases