when i am loading the data from CRM to synapse dedicated sql pool i am getting this error.{ "errorCode": "2200", "message": "ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operati

Murthy Chirudi 0 Reputation points
2024-03-05T12:29:36.5866667+00:00

{ "errorCode": "2200", "message": "ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=The statement failed. Column 'fwci_classcodetest' has a data type that cannot participate in a columnstore index.,Source=.Net SqlClient Data Provider,SqlErrorNumber=35343,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=35343,State=1,Message=The statement failed. Column 'fwci_classcodetest' has a data type that cannot participate in a columnstore index.,},],'", "failureType": "UserError", "target": "DataLake To Synapse FWCI Daily CRM", "details": [] }

Windows 10 Setup
Windows 10 Setup
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,915 questions
0 comments No comments
{count} votes