Azure synapse -- target

[suvbin]

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.

[aarun_arasu · Accepted solution]

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]

Hello @suvbin ,

Below is the additional reference material.

https://learn.microsoft.com/en-us/sql/relational-databases/pages-and-extents-architecture-guide?view...

Regards

Arun

[aarun_arasu]

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]

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