Bigquery transfer fail with DEADLINE_EXCEEDED on the facebook ads template

[tomlag]

Out of the blue, the Facebook ads transfer started failing with this error message. 

Bigquery transfer failed with system error code DEADLINE_EXCEEDED.

"Timed out when starting to transfer asset AdAccounts. Ensure the datasource is reachable and the datasource configuration Credentials, Network Attachment etc.) is correct"

Also, I can't update the credentials (see image), the error might come from a change in facebook insights API

[tomlag · Accepted solution]

The issue was solved without any intervention the day after

[Snoshone07]

Hi @tomlag it’s really frustrating when the schema shows up in BigQuery but the actual data from Salesforce is missing. Here are some steps that might help you get to the bottom of this:

1. Check Salesforce Permissions: Make sure the service account being used has the right permissions to access all records in the Salesforce object. Sometimes, custom objects need extra permissions that aren’t set by default.

2. Review Salesforce Security Policies: Depending on how your Salesforce security is set up, certain records might be hidden from the API, especially if there are specific access rules in place.

3. Check BigQuery Transfer Logs: The transfer logs can give you useful insights if there were any errors or warnings during sync. Head over to the logs section in BigQuery Data Transfer Service to see if there are any error messages related to this table.

4. Make Sure the Object Isn’t Empty: Even though you mentioned that the object has data, certain filters in Salesforce (like date or status filters) could end up transferring little or no data.

5. Try a Manual Transfer: Run the transfer manually to see if any specific error pops up in the process.

If the issue still isn’t resolved, you might want to try using a tool that integrates Salesforce and BigQuery. For example, Windsor.ai offers data transfers from Salesforce to multiple platforms, including BigQuery, and might help avoid these sync issues.

Hope this helps!