Extraction Logs
  • 3 Minutes to read
  • Dark
    Light

Extraction Logs

  • Dark
    Light

Article Summary

For Flow Action Logs for see below.

Source Extraction Logs

No Action Required

Error MessageMeaning
Extraction enqueuedYour extraction has been enqueued and it will be processed shortly. No action needed.
Extraction successfully finishedYou extraction was successful, no errors were found.

Reauthorize Your Account

Error MessageSolution
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.
Error unauthorized_client - refresh_token is invalidYour account is unauthorized. Navigate to Authorizers and add your service.

No Data Retrieved

Error MessageSolution
All requests to target systems failedWhen 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.
No data retrieved. Enable extraction's 'allow empty' rule if you accept empty datasetsNo 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. Data Sources - Allow Empty

Change Source Schema

Error MessageSolution
Failed to save data to storage: Failed to update source data: Server error: PUT https://storage.prod.dataddo.com/v1.0/replace resulted in a 500 Internal Server Error response:\n{"status":"Internal Server Error","error":"replace: Failed to cast values of column 'column_name' (type:integer, id:XXXXXX): failed to cast string value '--' to integer"}\n\nYou will need to change the data type of column called column_name. In this case we will need to change the type from integer to string since we are received string values. For more information check our article here.

Flow Extraction Logs

No Action Required

Error MessageMeaning
Job enqueuedYour 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.

Reauthorize Your Account

Error MessageSolution
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.
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.
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.

Change Table Schema

Error MessageSolution
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 itAffected 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.
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, invalidAffected field already exists in schema, please rename your field. Navigate to your source and select Edit. Rename your filed in the Data Types tab.
"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.
Table does not contain 'app_clicks' columnThe issue arises due to a schema mismatch between the source and destination tables. Specifically, the 'app_clicks' column is missing in the destination table. Additionally, double-check that the data flow directs information to the correct destination table. Each flow should be set up to send data to a different table.

Connector Specific Logs

Error MessageSolution
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., badRequestYour Google Sheets limit has been reached. Please select another Sheet as a destination.


Was this article helpful?

What's Next