Stephan Claus
06/21/2022, 6:56 PMerrors: $.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!Stephan Claus
06/21/2022, 7:09 PMSynchroTiers
. I will exclude the table and kick it off again. Is this worth a bug ticket?Xiaodan Wang
07/11/2022, 12:58 PM