Hi, I am currently running a connection from MSSQL...
# ask-community-for-troubleshooting
s
Hi, I am currently running a connection from MSSQL to Snowflake and I have the following issue: When selecting a couple of tables (tested with 20 our of 120) everything works well, but when I try with a full sync (so all the streams in the sources) I get the following error:
Copy code
errors: $.type: does not have a value in the enumeration [RECORD, STATE, LOG, SPEC, CONNECTION_STATUS, CATALOG]
2022-06-21 18:03:40 ERROR i.a.w.p.a.DefaultAirbyteStreamFactory(lambda$create$1):70 - Validation failed: {"type":"TRACE","trace":{"type":"ERROR","emitted_at":1.655834620083E12,"error":{"message":"Something went wrong in the connector. See the logs for more details.","internal_message":"java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SynchroTiers'.","stack_trace":"[io.airbyte.db.jdbc.StreamingJdbcDatabase.unsafeQuery(StreamingJdbcDatabase.java:75), io.airbyte.db.jdbc.JdbcDatabase.queryMetadata(JdbcDatabase.java:217), io.airbyte.integrations.source.mssql.MssqlSource.getWrappedColumn(MssqlSource.java:145), io.airbyte.integrations.source.mssql.MssqlSource.queryTableFullRefresh(MssqlSource.java:80), io.airbyte.integrations.source.mssql.MssqlSource.queryTableFullRefresh(MssqlSource.java:52), io.airbyte.integrations.source.relationaldb.AbstractDbSource.getFullRefreshStream(AbstractDbSource.java:299), io.airbyte.integrations.source.relationaldb.AbstractDbSource.createReadIterator(AbstractDbSource.java:245), io.airbyte.integrations.source.relationaldb.AbstractDbSource.getSelectedIterators(AbstractDbSource.java:192), io.airbyte.integrations.source.relationaldb.AbstractDbSource.getFullRefreshIterators(AbstractDbSource.java:149), io.airbyte.integrations.source.relationaldb.AbstractDbSource.read(AbstractDbSource.java:122), io.airbyte.integrations.base.ssh.SshWrappedSource.read(SshWrappedSource.java:54), io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:155), io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107), io.airbyte.integrations.source.mssql.MssqlSource.main(MssqlSource.java:450)]","failure_type":"system_error"}}}
2022-06-21 18:03:41 INFO i.a.w.p.KubePodProcess(close):708 - (pod: airbyte / source-mssql-sync-1636-0-oyvka) - Closed all resources for pod
so it looks like there is a certain stream in my source which causes the whole sync to fail. I checked the logs for further details but cannot find the respective stream which is causing it. What is the best way to troubleshoot and debug further? Appreciate any hint, thank you!
update: I went through the tables and checked the column names and there is indeed a column name called
SynchroTiers
. I will exclude the table and kick it off again. Is this worth a bug ticket?
x
#how-to-troubleshooting-debugging is an interesting topic. The way it is creating its connectors actually running the process from the connector’s container. Not sure how, trying python logging method but not getting any info related.