topic Re: Azure synapse -- target in Qlik Replicate

Azure synapse -- target

suvbin — Wed, 14 Feb 2024 03:30:35 GMT

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.

Re: Azure synapse -- target

aarun_arasu — Wed, 14 Feb 2024 05:53:06 GMT

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/td-p/1847472

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

Regards

Arun

Re: Azure synapse -- target

aarun_arasu — Wed, 14 Feb 2024 05:55:52 GMT

Hello @suvbin ,

Below is the additional reference material.

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

Regards

Arun

Re: Azure synapse -- target

aarun_arasu — Wed, 14 Feb 2024 05:57:13 GMT

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

Re: Azure synapse -- target

suvbin — Wed, 21 Feb 2024 06:36:43 GMT

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