https://linen.dev logo
Join Slack
Powered by
i have an issue with salesforce connector
# replication-troubleshooting
t
i have an issue with salesforce connector
i have this error in logs
Copy code
2022-11-24 13:39:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
Capture d’écran 2022-11-24 à 14.54.29.png
• airbyte 0.40.17
Copy code
2022-11-25 09:11:57 source > SourceSalesforce runtimes:
Syncing stream AcceptedEventRelation 0:00:00.442906
2022-11-25 09:11:57 source > Syncing stream: Account 
2022-11-25 09:12:45 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:45 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:45 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
2022-11-25 09:12:46 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: Invalid timezone offset: +0000
looks like to have this error on “Account” stream
s
Not with this connector but i am having invalid date-time errors in my issue described here
m
@thomas trividic did the sync finished?
t
it failed
m
I found this issue https://github.com/airbytehq/airbyte/issues/17319 which is close to yours. I’d suggest to downgrade the destination connector and try again to see if works. I don’t see any relevant changes to date formating in S3 destination changelog too: https://docs.airbyte.com/integrations/destinations/s3#changelog
t
i can try this thanks
c
@thomas trividic - did downgrading work? I’m getting the same error with Salesforce Account and I am on airbyte 
0.40.22
t
i did not tried but i can’t easily downgrade the software by myself
u
It isn't downgrade the platform version. It is only the destination version: ![](

https://airbyte7538.zendesk.com/attachments/token/Ofwsl4CNz4oQwWQ2SbrvRSQxr/?name=image.png▾

)
t
ok thanks
c
I’m having the issue in Snowflake - what version should that be?
m
@Carolina Buckler please send a new message and show the error you’re getting and what version of connectors and platform you’re using
a
@Marcos Marx (Airbyte) Has there been any progress on this issue? I am getting similar issues with date-time fields as null in my destination source.
Copy code
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column CreatedDate at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column Churn_Date__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column LastViewedDate at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column SystemModstamp at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column LastActivityDate at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column LastModifiedDate at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column Backfill_Start__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column First_MQL_Date__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column First_SAL_Date__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column First_SQL_Date__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column Keys_Demo_Date__c at Account
2023-01-26 18:35:40 [42mnormalization[0m > WARN: Unknown type for column LastReferencedDate at
• Airbyte Version: 
0.40.0-alpha
 • Salesforce: 
0.2.5
• BigQuery: 
1.1.14
I recognize my destination of BigQuery is a few versions out of date but I'm a bit hamstrung without a staging env right now to upgrade
m
@Antonia no updates because my last messages didn’t get a reply. Can you share the complete log file? The snippet you shared is only showing warns not errors.
👍 1
a
Here are the logs for just the Account object where the date errors are occurring
logs-8109.txt
m
@Antonia I saw from your logs you’re using the deprecated Salesforce connector 
airbyte/source-salesforce-singer:0.2.5
. Please I strongly recommend to you use the Airbyte native one. The last update of this connector was last year, compared to native one which was 3 days ago. https://hub.docker.com/r/airbyte/source-salesforce-singer/tags https://hub.docker.com/r/airbyte/source-salesforce/tags
a
Thank you! Let me try to add a new connector and see how things are flowing
👍 1
m
Hello! We are facing the same issue and we do use the official salesforce connector. Any suggestions how to solve it?
Open in Slack
PreviousNext
Powered by