Historical Repoting Crashing with Error 5022

[john.heyer]

When trying to run a report, Historical Reports crashes. The error message is

"An Exception Error occurred. Application exiting. Check the log file for error 5022."

I'm using verion 3.1(3.2) with MSDAC 2.7

[Howatzer247]

Just a follow up to my previous post. Our issue was only with custom reports that we created. We created our custom reports by copying an existing rpt template, however it appears that HRC did not like this. We then created the custom reports from scratch and that resovled our 5022 error and successfully ran the reports.

NOTE: Cisco uses Crystal Reports XI.

This is what we have.

Report Editor - Crystal Reports XI

IPCCS - 5.0(2)SR01ES01_Build016

HRC - 5.0(2.5)

[marco.silva]

The alterations to the client files explained in the BUG workaround solved my problems. I've changed the "IVR_Detailed_Call_by_Call_CCDR_en_us.xml" and the "ICD_Detailed_Call_CSQ_Agent_en_us.xml" files :

SELECT distinct top 3000 callednumber

FROM db_cra.dbo.contactcalldetail

where origcallednumber not in ('')

does anyone knows what is the maximum argument for the "top" instruction that you can put in the SQL Query above descripted?