-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
1.3.0.Final
-
None
-
False
-
False
-
Undefined
-
-
I have a problem with debezium and sql server connector that give us the following error when connector restart after the connection to sql server is lost:
com.microsoft.sqlserver.jdbc.SQLServerException: Error converting string value 'etutcdate(' into data type datetime2 using culture ''.
And this is the full error stack:
2020-10-06 14:55:08,681 INFO || [Consumer clientId=abc-dbhistory, groupId=abc-dbhistory] Join group failed with org.apache.kafka.common.errors.MemberIdRequiredException: The group member needs to have a valid member id before actually entering a consumer group. [org.apache.kafka.clients.consumer.internals.AbstractCoordinator] com.microsoft.sqlserver.jdbc.SQLServerException: Error converting string value 'etutcdate(' into data type datetime2 using culture ''. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016) com.microsoft.sqlserver.jdbc.SQLServerException: Error converting string value 'etutcdate(' into data type datetime2 using culture ''. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016) com.microsoft.sqlserver.jdbc.SQLServerException: Error converting string value 'etutcdate(' into data type datetime2 using culture ''. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016) 2020-10-06 14:55:16,158 WARN || [Producer clientId=connector-producer-sysint-sqlserver-abc-runinit-connector-0] Error while fetching metadata with correlation id 3 :
CREATE TABLE [dbo].[Payment]( [IDPayment] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [Date] [datetime] NULL, [IDData] [int] NULL, [TrackNumber] [int] NOT NULL, [Note] [varchar](50) NOT NULL, [IsVerified] [bit] NOT NULL, [Date2] [datetime] NULL, [IDAccount] [int] NOT NULL, [OrderNumber] [int] NOT NULL, [OrderQuantity] [int] NULL, [Import] [bit] NOT NULL, [ImportDate] [datetime] NULL, [Processed] [bit] NOT NULL, [ProcessedAuto] [bit] NOT NULL, [Transfer] [bit] NOT NULL, [TransferNote] [varchar](50) NULL, [VerifiedTransfer] [bit] NOT NULL, CONSTRAINT [PK_Payment] PRIMARY KEY CLUSTERED ( [IDPayment] ASC )
- duplicates
-
DBZ-2698 Some column default values are not extracted correctly while reading table structure
- Closed