Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

No Historical Data after Daylight Saving Time

I'm running CRS 7.0(1)SR05 and have found out that since sunday (daylight savings time), our historical reporting is saying that "There were no report data to view in the date range selected.....".  I know there is data since we take generally between 300 - 500 calls a day.  Any ideas?

Thanks in advance,

Michael

2 ACCEPTED SOLUTIONS

Accepted Solutions
Silver

Re: No Historical Data after Daylight Saving Time

Hello Michael,

First, check in SQL db to see if data is available for those dates. If there's data there, we know the problem is with the Historical Reporting.

- Do you have an HA node?

Please go to System> Datastore Control Center> Publisher Activation page from Appadmin. It will display the Historical datastore; are there any error messages shown? What is the replication status? You can send a screenshot.

Pablo

Silver

Re: No Historical Data after Daylight Saving Time

Actually it seems you do have an HA server.

You can check the ContactCallDetail table in db_cra.

Please try this; select the Publication Snapshot Agent and click the Reset Publisher button - click OK. It could take about a minute to refresh. Hopefully when it comes back, the error should be gone. This should fix the replication problem. Please also check the Repository and Agent datastores to see the status and try the same if necessary. Check if that makes any difference.

HTH

Pablo

5 REPLIES
Silver

Re: No Historical Data after Daylight Saving Time

Hello Michael,

First, check in SQL db to see if data is available for those dates. If there's data there, we know the problem is with the Historical Reporting.

- Do you have an HA node?

Please go to System> Datastore Control Center> Publisher Activation page from Appadmin. It will display the Historical datastore; are there any error messages shown? What is the replication status? You can send a screenshot.

Pablo

Community Member

Re: No Historical Data after Daylight Saving Time

Do you know what table the data will be in?  I do not believe we have HA and here is the screenshot of that view.

Silver

Re: No Historical Data after Daylight Saving Time

Actually it seems you do have an HA server.

You can check the ContactCallDetail table in db_cra.

Please try this; select the Publication Snapshot Agent and click the Reset Publisher button - click OK. It could take about a minute to refresh. Hopefully when it comes back, the error should be gone. This should fix the replication problem. Please also check the Repository and Agent datastores to see the status and try the same if necessary. Check if that makes any difference.

HTH

Pablo

Community Member

Re: No Historical Data after Daylight Saving Time

That fixed it.  Thanks for your help.

Silver

Re: No Historical Data after Daylight Saving Time

Thanks great Mike!

1392
Views
15
Helpful
5
Replies
CreatePlease to create content