Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suvbin
Creator II
Creator II

Azure synapse -- target

Hi Team ,

Facing the below error, 

00020556: 2024-02-13T19:03:06 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 511 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot create a row of size 10082 which is greater than the allowable maximum row size of 8060. Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated., SqlState: 01000, NativeError: 3621 Line: 1 Column: -1 [1022502] (ar_odbc_stmt.c:5003).

 

Source : SQL Server 

Target : Azure Synapse Analytics

Please help on this.

 

 

 

Labels (3)
1 Solution

Accepted Solutions
aarun_arasu
Support
Support

Hello @suvbin ,

 

Thanks for reaching out the Qlik Community

The above error means the attre ptable hit the SQL server row size limitation so you need to split tables between several tasks so that the attrep_changes tables can be created with less number of columns and this is known behavior.

Below are some reference article

https://community.qlik.com/t5/Qlik-Replicate/An-error-on-attrep-changes-CDC-table-appears-in-the-log...

https://stackoverflow.com/questions/3905934/cannot-create-a-row-of-size-8937-which-is-greater-than-t...

Regards

Arun

 

View solution in original post

4 Replies
aarun_arasu
Support
Support

Hello @suvbin ,

 

Thanks for reaching out the Qlik Community

The above error means the attre ptable hit the SQL server row size limitation so you need to split tables between several tasks so that the attrep_changes tables can be created with less number of columns and this is known behavior.

Below are some reference article

https://community.qlik.com/t5/Qlik-Replicate/An-error-on-attrep-changes-CDC-table-appears-in-the-log...

https://stackoverflow.com/questions/3905934/cannot-create-a-row-of-size-8937-which-is-greater-than-t...

Regards

Arun

 

aarun_arasu
Support
Support

aarun_arasu
Support
Support

Hello team,   If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer

Regards

Arun

suvbin
Creator II
Creator II
Author

Thank you @aarun_arasu , we have splitted the tables among the other tasks. Its working fine now.