Ricardo Cordero comments

Results 6 comments of


                                            Ricardo Cordero

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

Any updates on this issue? it is possible to tunning the mssql source kafka/debezium params? i tried to add some kafka/debezium params via the "jdbc params" option in mssql source...

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

Hi @Cir02, @pankaj-lmg, @sakent If I can please ask for a full log of the error. I have a theory on what is going on here, but I haven't been...

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

> From your log I see that the value causing this error (`2024-05-10 19:00:01.604805 +03:00`) only has 6 digits of precision: 604805, while our conversion is expecting the default 7...

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

> What's odd is that this issue was opened with an error indicating a failure to convert a value with 7 precision digits (`2020-04-22 09:16:20.6566667 +00:00`). i can confirm in...

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

> Thanks for the log @Cir02 . I've been trying to repro this and was unable. We recently updated the JDBC driver we use with mssql to the latest one,...

[source-MSSQL] incremental append failed due to `datetimeoffset` with CDC as update method

hello there! in our company have found the posible cause of the issue. in our case, some records with type `DATETIMEOFFSET(7)` were causing the parse exception 'java.time.format.DateTimeParseException'. All of these...