Summary
After upgrading Airbyte to version 0.63.13, encountering errors while syncing with MSSQL connector due to connection closure. Seeking possible causes and solutions.
Question
Hello folks,
We upgraded our airbyte to 0.63.13 and when trying to sync using mssql connector we are facing below error
2024-08-19 06:50:47 source > INFO main i.a.c.d.j.AbstractJdbcCompatibleSourceOperations(convertDatabaseRowToAirbyteRecordData):47 Failed to serialize column: DEVICE_ID, of type varchar, with error SQL Server returned an incomplete response. The connection has been closed.
2024-08-19 06:50:47 source > ERROR main i.a.c.d.j.StreamingJdbcDatabase$toUnsafeStream$1(tryAdvance):99 SQLState: 08S01, Message: The connection is closed.
2024-08-19 06:50:47 source > ERROR main i.a.c.u.CompositeIterator(close):144 exception while closing java.lang.RuntimeException: java.sql.SQLException: Connection is closed
Its the same data that the earlier version of airbyte used to sync. If anyone know the possible causes or solutions please do let me know .
I will be happy to provide more details .
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.