Guest

Preview Tool

Cisco Bug: CSCte49457 - Database error while generating Manager / Assistant reports

Last Modified

Nov 03, 2012

Products (1)

  • Cisco Unified Communications Manager (CallManager)

Known Affected Releases

7.1(4.99021.1)

Description (partial)

Symptom:
Description:
Database error while generating Manager / Assistant reports.

Conditions:
Steps:
1. Create around 2000 users using UDP.
2. Insert Managers/Assistants using BAT (for the above users)
3. Go to BAT Admin -> Managers/Assistants -> Generate Manager Reports OR Generate Assistant Reports
4. Submit the job for generating the report (for the 2000 managers / assistants)

Observation:
1. After some time, in the Job Scheduler, the transaction shows as "Completed" but the transaction details shows that only a few records are processed. 
2. Log File shows that some records were not processed, but there is no error message 
3. If after step# 4, while the transaction is still in 'Processing' stage, we try to open the report file generated, the file is blank.
4. If we open the Log File to check the status, we get error as "Unmapped Exception java.io.FileNotFoundException" in the log file 
5. After this, if we go to "Find and List Managers (or Assistants) To Delete" page and click the Find button, we get error message as "Error occured during find.java.sql.SQLException:Memory allocation failed during query processing" 
6. If we go to the Generate Manager Reports page again and click on Find button, we get error message as "Error occured during find.java.sql.SQLException: Cannot write sorted rows" 
7. On Upload/Download, Add FIle page also I get error 
8. If i logout of CUCM and try to login again, I get "Database communication error" on the login page 

NOTE: Observation# 5, 6, 7, 8 are reproducible intermittently
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.