KNOWLEDGE BASE

Extract Refresh Fails And Reaches The Backgrounder Query Limit When Connecting To Web Data Connector


Published: 18 Mar 2021
Last Modified Date: 18 Mar 2021

Issue

The web data connector domain has been added to the safe list, but the extract refresh job fails and reaches the backgrounder query limit when connecting to the web data connector.

Environment

  • Tableau Server 
  • Web Data Connector

Resolution

  • Besides the main domain URL, please add the entire domain to the secondary safe list by using a wildcard as in the following example:
             http://example.com/.*

 1. If you are adding the safe list by the TSM command, please add the above URL in the secondary safe list.             
     tsm data-access web-data-connectors add --name "Name" --url http://example.com --secondary http://example.com/.*

 2. If you are adding the safe list by using a JSON file, the file should be defined like this.
=============
{
    "configEntities": {
        "web-data-connector-settings": {
            "_type": "webDataConnectorSettingsType",
            "enabled": true,
            "refreshEnabled": true,
            "whitelist": {
                "http://exapmle.com": {
                    "secondaryWhitelist": [
                        "http://example.com/.*",
                        ]
                    }
                }
            }
        }
    }
}
=============
  • If the issue still occurs, try to check if other domains are using when connecting to the WDC and add all necessary domains in the wildcard format.

Cause

The domains added in the safe list are incomplete.
Did this article resolve the issue?