Summary
Error occurred while executing model.airbyte_utils.dialogicscripts. The error is related to a column data type mismatch between ‘name’ column in Postgres and MSSQL. The error message suggests that the ‘name’ column cannot participate in a columnstore index in MSSQL. The user has tried removing all indexes in the MSSQL table but the error persists in Airbyte logs.
Question
Hello All,
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) ”)
I’m trying to do sync from postgres sql to mssql so got this error, how can i resolve it.
I have tried this -
. Removed all the indexes in mssql table.
. name column has type string in postgres and in destination we gave text so it’s failing, also we had removed all indexes for that table still error is presists in airbyte logs
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.