Hello! I am with a datetime error that I think som...
# replication-troubleshootingj
Joviano Cicero Costa Junior
11/23/2022, 5:23 PMHello! I am with a datetime error that I think somebody already had the same issue:
2022-11-22 215445 ERROR c.n.s.DateTimeValidator(tryParse):82 - Invalid date-time: No timezone information: 2021-09-14T112452.000000
Does anyone help me how to get fix?
m
Marcos Marx (Airbyte)
11/23/2022, 5:32 PMWhat connector and platform are you using?
j
Joviano Cicero Costa Junior
11/23/2022, 5:41 PMSource: MySQL
Target: Snowflake
Platform: Self-hosted on AWS
m
Marcos Marx (Airbyte)
11/23/2022, 6:15 PMDid the sync finished?
j
Joviano Cicero Costa Junior
11/23/2022, 6:19 PMYep, I tried yesterday, after 3 attemps it's finished with failed status
Joviano Cicero Costa Junior
11/23/2022, 11:05 PMSorry, I gave to you few information. The problem ocurs just at the normalization process. If I run the process without normalization the sync runs successfully.
So, I think the problem is when transforming timestamp collected from MySQL (and converted to string/json into RAW table) back to relational format.
Joviano Cicero Costa Junior
11/24/2022, 7:12 PMAnother information, running individually the same tables the all process ran successfully.
Joviano Cicero Costa Junior
11/24/2022, 7:53 PMI was test sync with all tables again and get no error at this time.
u
user
12/06/2022, 9:07 PMHello Joviano Cicero Costa Junior, it's been a while without an update from us. Are you still having problems or did you find a solution?
j
Joviano Cicero Costa Junior
12/27/2022, 7:36 PMThanks for replying, but I didn't do anything and the problem hasn't reoccurred.
s
Saj Dider (Airbyte)
01/02/2023, 7:00 PM@Joviano Cicero Costa Junior happy to hear the problem hasn’t reoccured. Let us know if you run into any further issues!
8 Views