Error message when running Historical Report

[Greeshma Bernad]

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:

1. On the historical reporting client machine, go to the installation directory of the client:\Program Files\Cisco CRS Historical Reports\ReportTemplates\en_US\
2. Open file ICD_Detailed_Call_by_Call_CCDR_en_us.xml in Notepad.
3. Search for tag
4. 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.
5. 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:

1. On the historical reporting client machine, go to the installation directory of the client: \Program Files\Cisco CRS Historical Reports\ReportTemplates\en_US\
2. Open file IVR_Detailed_Call_by_Call_CCDR_en_us.xml in Notepad.
3. Search for tag
4. 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.
5. 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

[bmiller]

I have IPCC 4.0(4), I worked with this issue for quite some time. The work around above did not work for me. I found that uninstalling and reinstalling the Cisco CRS Historical Reports plug-in fixed the issue. For some users problems I refered to Cisco Document ID #108555, because the application did not want to install or uninstall.

Strange that this issue was supposed to be fixed in 4.0(5) and 4.5, but I still see folks with 5.0 (1.2) still having this same problem. Also for reference see Bug Toolkit CSCef56507.