Replication issue with MSSQL source and BQ connector

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Replication between Microsoft SQL Server (MSSQL) v4.0.35 and BigQuery (BQ) connector broke due to a NullPointerException in the source code.


Question

Hi all. :wave:
Maybe someone can help understand the cause of the problem. We have source Microsoft SQL Server (MSSQL) v4.0.35 and connector to BQ. Today for some reason the replication broke and I don’t understand why. Logs:
io.airbyte.cdk.integrations.source.relationaldb.state.FailedRecordIteratorException: java.lang.RuntimeException: java.lang.NullPointerException: Cannot invoke "io.airbyte.integrations.source.mssql.initialsync.MssqlInitialReadUtil$OrderedColumnInfo.ocFieldName()" because "this.ocInfo" is null


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.

Join the conversation on Slack

["mssql-source", "bq-connector", "replication-issue", "null-pointer-exception"]
2

Restarting does not help

3

In google found some similar issue, but haven’t access to read it https://github.com/airbytehq/airbyte/issues/40514

4

Recreating connector helps here. :melting_face: