Failed to sync from salesforce

Troubleshooting
#1
  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: AWS EC2
  • Deployment: Docker
  • Airbyte Version: 0.36.1-alpha
  • Source name/version: Salesforce 1.0.9
  • Destination name/version: Snowflake 0.4.24
  • Step: sync
  • Description:
    Hi everybody,

During sync from Salesforce to Snowflake, I saw the following in the logs:

2022-05-13 13:58:19 source > Syncing stream: Attribute_Bundle_Item_Mapping__Tag
2022-05-13 13:58:19 source > Giving up for returned HTTP status: 400, body: [{"errorCode":"INVALIDENTITY","message":"Entity '01I0e000000FMSK.Tag' is not supported by the Bulk API."}]
2022-05-13 13:58:19 source > Cannot receive data for stream 'Attribute_Bundle_Item_Mapping__Tag' using BULK API, sobject options: {'activateable': False, 'associateEntityType': ... a very long json object

Do you know how I could fix this?
Thank you!

#2

Hey can you share the complete logs? Also was the sync successful

#4

Here are the logs:

logs-47.txt (38.7 KB)

Sync did not work:

image
image3212×304 56.1 KB

But the schema and tables in the destination (snowflake) were created

#5

Hey just to understand can you try a different destination and see if that works. This can help us narrow down the problem

#6

Sure!
Will Postgres do?
EDIT:
logs-56.txt (29.9 KB)

#7

What do you think?
To me it looks like a problem of the Salesforce connector

#8

Yeah can you raise a github issue around this and all the details so that team can look and get back to you