Extraction Logs

Source Extraction Logs

Extraction enqueued

• Your extraction has been enqueued and it will be processed shortly. No action needed.

Extraction successfully finished

• You extraction was successful, no errors were found.

No data retrieved. Enable extraction's 'allow empty' rule if you accept empty datasets

• No data was found when extracting data. In case this is expected behavior (e.g. you don’t have orders everyday or don’t run ads daily), you can enable the “allow empty” function. Click on the three dots on your source, select Edit and scroll down on the Basic Info tab.

Client error: 'POST https://accounts.google.com/o/oauth2/token' resulted in a '400 Bad Request' response: { "error": "invalid_grant", "error_description": "Token has been expired or revoked." }

• Your account needs to be reauthorized. Navigate to Authorizers and reauthorize your source.

All requests to target systems failed

• When trying to extract your data, all requests failed. For more information on what went wrong, you can test your extraction. Click on the three dots on your source and select Test Extraction.

Flow Action Logs

Job enqueued

• Your extraction has been enqueued and it will be processed shortly. No action needed.

[Number] rows written

• [Number] of rows was successfully loaded into the destination.

Erroneous communication with Google Big Query API.

• Navigate to Authorizers and reauthorize Google BigQuery.

Failed to enqueue write job.

• Writing your data to the destination failed. Navigate to Authorizers and reauthorize your destination.

Stream transfer: write data from stream: ZOHO write: upload file to Zoho: destination response URL: https://www.zohoapis.eu/crm/v3/org: status_code: 403 response: {"code":"CRMPLUS_TRIAL_EXPIRED","details":{},"message":"CRM plus trial expired","status":"error"}

• Your CRM plus trial has expired, please upgrade your ZOHO CRM account.

Stream transfer: write data from stream: [Unknown][][] Erroneous communication with Google Big Query API: failed to prepare table: Failed to create new table '407589665707:data_writer_test.blended_sources_test': googleapi: Error 400: Field videoid already exists in schema, invalid

• Affected field already exists in schema, please rename your field. Navigate to your source and select Edit. Rename your filed in the Data Types tab.

Stream transfer: write data from stream: writing to sheet: Failed to write data to sheet by columns: Failed to write "USER_ENTERED" data batch to sheet: googleapi: Error 400: Invalid data[0]: This action would increase the number of cells in the workbook above the limit of 10000000 cells., badRequest

• Your Google Sheets limit has been reached. Please select another Sheet as a destination.

Json unmarshal: Failed to convert value GBQ data type: Column 'gadate' schema is set to 'TIMESTAMP' and thus the 'integer' type values cannot be inserted to it

• Affected column data type is incompatible with the data type in your destination. You can do one of the following:
  1. Change the data type of the affected column by navigating to your source, selecting Edit and going to the Data Types tab. Change column’s data type to date.
  2. Change the data type in your destination to integer.

Client error: 'POST https://accounts.google.com/o/oauth2/token' resulted in a '400 Bad Request' response: { "error": "invalid_grant", "error_description": "Bad Request" }

• Navigate to Authorizers and reauthorize your destination.

"error": "reading current structure: verifying table name: there is more than one table matching "facebook_ads": [company_production.facebook_ads company_staging.facebook_ads]"

• There are two tables with the same name (facebook_ads) in your storage and we don't know which of them we should use. You can do one of the following:
  1. Change your table name in your flow's settings.
  2. Remove one of the facebook_ads tables.
  3. Use the full path in the flow configuration. For example, instead of facebook_ads, use company_production.facebook_ads.