CCX 7.0.(1) Historical Reports - No data

[Dominic Ellis]

Hi,

The historical reports were running ok. We now receive a 'no data to view' when running reports

for any date range. I have checked Purge and the data base is showing 74% of 2048mb and

purge data older that 13 months.

Purge schedule is set for older than 99 months

Auto purge is set to purge when the database exceeds 70% of 2048mb

Auto purge data for the oldest 15days

Has anyone seen this before? or know how I can check to see data is still available.

any ideas greatefully received.

Thanks

dominic

[Walter Solano]

Hello Dominic,

One questions. Do you a single server deployment or you have HA?

[Dominic Ellis]

Hi Walter, It is a single deployment.

[Pablo Leiva]

Hi Dominic,

Try this. From the cmd run the following MSDE query:

osql -E -S HOSTNAME\CRSSQL -Q "USE db_cra SELECT * FROM ContactCallDetail WHERE (startDateTime >= 'MM/DD/YYYY') AND (startDateTime <= 'MM/DD/YYYY')"

This will tell us if there is data available for the selected range of date.

HTH