11-05-2010 04:08 AM - edited 03-14-2019 06:50 AM
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
11-10-2010 05:31 AM
Hello Dominic,
One questions. Do you a single server deployment or you have HA?
11-10-2010 07:07 AM
Hi Walter, It is a single deployment.
11-10-2010 12:26 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide