Preview Tool

Cisco Bug: CSCul05186 - PI Client Throughput report gets JDBC exception

Last Modified

Nov 27, 2020

Products (1)

  • Cisco Prime Infrastructure

Known Affected Releases


Description (partial)

While creating a Client Throughput report template on Prime Infrastructure, , a JDBC exception is encountered and the report not saved.

The error message:

Failed to run report: JDBC exception on Hibernate data access: SQLException for SQL [insert into ReportSettings (instance_version, titleName, settingName, reportName, isVisible, selectedColumns, hiddenColumns, reportAggregatorType, sortOrder, sortDirection, username, reportView, ignoreReport, assignedVDomainId, AuthEntityId, AuthEntityClass, CLASSNAME, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'SimpleReportSettings', ?)]; SQL state [72000]; error code [12899]; Could not execute JDBC batch update; nested exception is org.hibernate.QueryTimeoutException: Could not execute JDBC batch update

Prime Infrastructure, 

Reports > Report Launch Pad > Client > Throughput > Throughput Report Details 

Saving report template
Bug details contain sensitive information and therefore require a 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.