Source MSSQL: replication error

Connector Questions & Issues
, , ,
1
  • Airbyte version: 04026
  • OS Version / Instance: centos 7
  • Deployment: Docker
  • Source Connector and version: Microsoft SQL Server (MSSQL) alpha
  • Destination Connector and version:Microsoft SQL Server (MSSQL) alpha
  • Step where error happened: Sync job

Steps to Reproduce

1.create new connector
2.run sync

I noticed that the types of fields differ in the connector and in the real database. The screenshot shows this

image
image958×572 47.9 KB

Logs

28 of 152 ERROR creating table model dbo.calltypes… [ERROR in 0.69s]
26 of 152 ERROR creating table model dbo.clientsprioritymanualy… [ERROR in 0.89s]
Unhandled error while executing model.airbyte_utils.dialogicscripts
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘name’ has a data type that cannot participate in a columnstore index. Omit column ‘name’. (35343) (SQLMoreResults)”)
29 of 152 ERROR creating table model dbo.dialogicscripts… [ERROR in 0.83s]
Unhandled error while executing model.airbyte_utils.emailsharedaccounts
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘password’ has a data type that cannot participate in a columnstore index. Omit column ‘password’. (35343) (SQLMoreResults)”)
Unhandled error while executing model.airbyte_utils.dial_rule
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘dial_rule_name’ has a data type that cannot participate in a columnstore index. Omit column ‘dial_rule_name’. (35343) (SQLMoreResults)”)
31 of 152 ERROR creating table model dbo.dial_rule… [ERROR in 1.08s]
30 of 152 ERROR creating table model dbo.emailsharedaccounts… [ERROR in 1.10s]
Unhandled error while executing model.airbyte_utils.donotcallagain
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘reversedno’ has a data type that cannot participate in a columnstore index. Omit column ‘reversedno’. (35343) (SQLMoreResults)”)
33 of 152 ERROR creating table model dbo.donotcallagain… [ERROR in 0.95s]

(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘Data’ has a data type that cannot participate in a columnstore index. Omit column ‘Data’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘ccname’ has a data type that cannot participate in a columnstore index. Omit column ‘ccname’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘lockdate’ has a data type that cannot participate in a columnstore index. Omit column ‘lockdate’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘t’ has a data type that cannot participate in a columnstore index. Omit column ‘t’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘msgbody’ has a data type that cannot participate in a columnstore index. Omit column ‘msgbody’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘dpd’ has a data type that cannot participate in a columnstore index. Omit column ‘dpd’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘t’ has a data type that cannot participate in a columnstore index. Omit column ‘t’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘endtime’ has a data type that cannot participate in a columnstore index. Omit column ‘endtime’. (35343) (SQLMoreResults)”)
(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘scriptname’ has a data type that cannot participate in a columnstore index. Omit column ‘scriptname’. (35343) (SQLMoreResults)”),retryable=,timestamp=1673010830978]]]

2

Hey @SerhiiZahuba, could you please include the full logs! That help me debug this. Thanks!