Error syncing tables from MS SQL Server to Snowflake with CDC enabled

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

Summary

Error encountered while syncing tables from MS SQL Server to Snowflake with CDC enabled. Error messages include ‘VIEW SERVER STATE permission was denied’ and ‘Building schema history has timed out’.


Question

Hello everyone
I tried syncing few tables from MS SQL Server to Snowflake using Airbyte. CDC is enabled on these tables at source. Please refer the SS for the error we’re getting.
I tried syncing a single table with only 281 records, but still got the same error.

Few log error messages:

ERROR main i.a.c.i.b.IntegrationRunner(runInternal):216 caught exception! java.lang.RuntimeException: java.lang.RuntimeException: Building schema history has timed out. Please consider increasing the debezium wait time in advanced options.

  "internalMessage" : "java.lang.RuntimeException: java.lang.RuntimeException: Building schema history has timed out. Please consider increasing the debezium wait time in advanced options.",
  "internalMessage" : "Some streams either received an INCOMPLETE stream status, or did not receive a stream status at all: null.patients, null.enc, null.users, null.edi_facilities\nio.airbyte.commons.exceptions.TransientErrorException: Some streams were unsuccessful due to a source error. See logs for details.",```
Please let me know if someone can help out. Thank you.

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1721386841826679) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["syncing-tables", "ms-sql-server", "snowflake", "cdc-enabled", "error", "view-server-state", "building-schema-history", "debezium-wait-time"]
</sub>
2

Hi <@U07BF2QAYMQ> - this seems likely to be a permissions issue VIEW SERVER STATE permission was denied on object 'server', database 'master'.'

Are you able to confirm steps outlined in <Microsoft SQL Server (MSSQL) | Airbyte Documentation up CDC for MSSQL>? Particulalry section “3. Create a user and grant appropriate permissions”.