Problem
When running the Call Custom Variables Report or Detailed Call by Call CCDR Report on the CRS Historical Reporting Client (HRC), any of the following errors/conditions occur:
- Error message: "An Exceptional Error occurred. Application Exiting. Check the log file for error 5022"
- The report never gets generated and the HRC just hangs
- Error message: "The number of filter parameter values exceeded maximum entries (32765) that VB listbox can hold. Only the first 32765 filter parameter values will be available for selection."
Workaround
This issue occurs when CRS Historical Reporting Client 3.5(x), and the number of Calling Number, Called Numbers, or Original Called Numbers in ContactCallDetail table exceeds 32,767.So, download only a partial list of calling/called/originalCalled numbers, not the full list which is greater than 32,767 items:
Perform these steps for IPCC Express 3.x:
- On the historical reporting client machine, go to the installation directory of the client:\Program Files\Cisco CRS Historical Reports\ReportTemplates\en_US\
- Open file ICD_Detailed_Call_by_Call_CCDR_en_us.xml in Notepad.
- Search for tag
- Change the following statement which is 4 lines below
SELECT distinct origcallednumber FROM
db_cra_ccdr..contactcalldetail
to:
SELECT distinct top 10 origcallednumber FROM
db_cra_ccdr..contactcalldetail where origcallednumber not in ('')
The result is that, instead of dowloading the entire list of Original Called Numbers from the server (in their case, there are 35,757 numbers), only the first 10 will be downloaded. Or you can use some number other than 10 if you want more numbers downloaded. You can also modify the line which selects CalledNumber in the same fashion. - Save the file. No need to restart any service. You would need to log out and log in again to the historical reporting client if you modify the file on
the fly.
Perform these steps for IPCC Express 4.x:
- On the historical reporting client machine, go to the installation directory of the client: \Program Files\Cisco CRS Historical Reports\ReportTemplates\en_US\
- Open file IVR_Detailed_Call_by_Call_CCDR_en_us.xml in Notepad.
- Search for tag
- Change the following statement which is 4 lines below
SELECT distinct origcallednumber FROM
db_cra..contactcalldetail
to:
SELECT distinct top 10 origcallednumber FROM
db_cra..contactcalldetail where origcallednumber not in ('')
The result is that, instead of dowloading the entire list of Original Called Numbers from the server (in their case, there are 35,757 numbers), only the first 10 will be downloaded. Or you can use some number other than 10 if you want more numbers downloaded. You can also modify the line which selects CalledNumber in the same fashion. - Save the file. No need to restart any service. You would need to log out and log in again to the historical reporting client if you modify the file on
the fly.
Note: Similar procedure is applicable to Detailed Call CSQ Agent report by modifying the corresponding xml
This issue is fixed in IPCC Express 4.0(5) and 4.5