Page History

Troubleshooting Empty Reports

Analytics reports may not display data due to an end-user error or a system failure. 
In  In order to troubleshoot empty reports and rule out a system failure, follow these steps:

1. Verify usage data collection. You may also execute the following SQL query against the CardioLog database, to see if usage events are registered:
    
   Select top 100 * from tab_temp_event_log

   where EventType = 0 /* Views */

   and Timestamp <= GETDATE() /* Today's date. Edit date range if needed */

   and Timestamp >= GETDATE()- 7

   and Url like 'http://www.intlock.com/%' /* You can add this line to test event collection for a specific website */

    

2. Verify that the CardioLog Scheduling Service has started and usage data processing is working.  You may also execute the following SQL query against the CardioLog database, to see check if usage events are being processed correctly:
   
   
   Select top 100 * from tab_event_log

   where EventType = 0 /* Views */

   and Timestamp <= GETDATE() /* Today's date. Edit date range if needed */

   and Timestamp >= GETDATE()- 7

   and SearchUrl like 'http://www.intlock.com/%' /* You can add this line to test event processing for a specific website */

3. Refresh the report data:

• Open the CardioLog Report Center and view the empty report in edit mode (click Click the report in the navigation pane and select Edit). For enhanced performance and quick loadingload times, cached data is displayed in cached mode while editing an existing report. Report widgets in cached mode may display old data, and are will be presented with a white filter layer. To view current data for a widget, click Refresh. To refresh data for all widgets in an edited report, click Refresh on the top tool bar.
• If you can see data in the report, click Generate Report on the top tool bar.
• If you cannot see data in the report, clear  clear the reports report data cache data. 

In addition, verify the following with the end-userreport details:

1. The report scheduling type (daily/weekly/monthly) corresponds with the report date range. For instanceexample, when creating a daily report, scheduled once a day, use the "Last Day" date range (and not "This Day"). By default, the report scheduling service is scheduled to run once a day at 00:00, making the report emptywhich might render an empty report.
   
2. The All report filters are correct. For instanceexample, make sure the web site on which the report is basedpage being analyzed, has not been changed (, deleted or updated, or has changed its URL changed).. For charts and meters, confirm that the data is within the margins of the minimum and maximum values.