cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1899
Views
15
Helpful
5
Replies

No Historical Data after Daylight Saving Time

Kevin Martin
Level 1
Level 1

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

***Please Mark and Rate helpful posts***
2 Accepted Solutions

Accepted Solutions

Pablo Leiva
Level 1
Level 1

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

View solution in original post

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

View solution in original post

5 Replies 5

Pablo Leiva
Level 1
Level 1

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

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.

***Please Mark and Rate helpful posts***

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

That fixed it.  Thanks for your help.

***Please Mark and Rate helpful posts***

Thanks great Mike!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: