Guest

Preview Tool

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
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.