Viewing data source Refresh Info and Error Log

Overview

You can check individual data sources for refresh information and refresh errors.  

About data source refresh intervals

Klipfolio attempts multiple times to connect to a data source before disabling it. The recheck interval is designed to ensure that the maximum amount of time is given to retrieving any new data and to allow any errors to be cleared.

Refresh attempts use the following intervals:  

  1. After one failure, Klipfolio attempts to refresh again every 5 minutes until success.
  2. After three failures, Klipfolio attempts to refresh again every 30 minutes until success.
  3. After five failures, Klipfolio attempts to refresh again every 6 hours until success.
  4. If 20 failures, the data source is disabled.

In the event that a data source is disabled, consult the Error Log to help with diagnose the problem

How to view Refresh Info and the Error Log

Refresh Info and the Error Log are available on the same screen. Use the following steps to locate the Refresh Log of a data source file.

  1. Click the Library link.
  2. Navigate to the Data Sources tab.
  3. Select the data source file you want to view.
  4. Under General, click Refresh InfoBoth Refresh Info and the Error Log can be found on this screen. 
  5. Click on Edit to change the Refresh interval or request a Refresh Now

Analyzing the Error Log:

You can obtain the following information about a data source in the Error Log.

  • The last refresh date and time.
  • The length of time to refresh the data.
  • The kind of data source.
  • The last time to update the data.
  • The current size of the data source.
  • The result of refreshing the data source. Click the Error link to check for any generated error message.

Note: Data in the Refresh Log is purged weekly and is current for the last ten minutes.

Status Codes:

Use the following error codes to help with troubleshooting data source connection issues.

400: Bad Request The resource can no longer be found.
403: Forbidden Logon credentials are incorrect.
500: Internal Error The query request failed to resolve.

Troubleshooting checklist for data sources that fail to refresh

  1. Some APIs, like Google Analytics, impose a limit on the number of requests per profile, number of concurrent requests per profile, and the number of tokens per Google user account. For more information on the Google Analytics API, see Configuration and Reporting API Limits and Quotas
  2. Some OAuth tokens expire and must be re-authorized on a regular basis. For example, a Facebook OAuth token must be re-authorized every two months.
  3. Some APIs impose a limit to the size of file you can upload. For example, most Box users are restricted to a maximum file size of 250 MB.
  4. Some data sources, such as SQL data sources inside your firewall, might require you to white-list our Klipfolio dashboard IP addresses. For more information on our IP addresses, see Frequently Asked Questions
  5. A query might be incorrect. For example, a Google Analytics query returns a "Connection Service" error if there is a line break at the end of a query.
  6. A file name might be incorrect. For example, if a file in Dropbox has been replaced with a file using a different file name.

Related links: