Preview Tool

Cisco Bug: CSCvt20866 - SQLException -syntax error has occurred seen with Headset Inventory page in a scenario

Last Modified

Jul 21, 2020

Products (1)

  • Cisco Unified Communications Manager (CallManager)

Known Affected Releases


Description (partial)

SQLException -syntax error has occurred seen with Headset Inventory page in a scenario

1)Login to CCMAdmin.
2)Access the path Device->Headset->Headset Inventory Summary. In Headset Inventory Summary page, Besides Headset Inventory by Status section as against the model ,click on the link available under each of the section namely-- Active (Seen in the last 30 days)-Inactive (Not Seen in the last 30 days)-Unassigned (No End User association)
This yields in links mentioned in Defect summary.
Modify the content of the URL as mentioned in Defect summary.

This results in ?
HTTP Status 500 ?
type: Exception Report
Description: http.500

SQLException A syntax error has occurred.
Root Cause:
Note: The full stack trace of the root cause is available in the server logs.

Ideally ,irrespective of content being added to URL or removed-
1)Either,Page must reload without any change in content and page must be displayed as is
2)This Page is not yet implemented message must be displayed
3)Access to the requested resource has been denied

Option mentioned above must be displayed and not the syntax error as shown.
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.