The following source column(s) contain data that exceed(s) the size limit of the corresponding target column

[Leandro_Medeiros]

Hi everyone,

I´m facing a new issue with QLIK Replicate because the Task does not replicate the column size from the source to the target table correctly. 

ERROR in the attrep_apply_exceptions:

The following source column(s) contain data that exceed(s) the size limit of the corresponding target column:
source column "TRMC80" is 32 bytes while target column "TRMC80" is 8 bytes;
source column "MOTY80" is 16 bytes while target column "MOTY80" is 4 bytes;
source column "HDID80" is 48 bytes while target column "HDID80" is 12 bytes;

Endpoints types in use:

Souce: IBM DB2 for LUW

Target: Microsoft SQL Server 2022 (160 Compatibility)  

Any help will be very appreciated.

Thank you !!

Best Rgds,

Leandro Medeiros

[john_wang · Accepted solution]

Hello @benwinkeler ,

Sorry for the delay, I was away on a business trip the past few days.

Yes, it is possible to customize the data type mapping by modifying the DB2 syntax. I’ve attached the modified syntax file "DB2.2024.11.CODEUNITS32.json" for you. You can import it into your Replicate instance and start using it. The detailed steps are available in the article “Replicate – How to Customize Target Endpoint Syntax.”

Please take note that all string data types in the endpoint will be mapped to VARCHAR(nn CODEUNITS32)—regardless of whether the source was defined as OCTETS, CODEUNITS16, or CODEUNITS32.

Good luck,

John.

[benwinkeler]

Thank you for the explanation and sample data mapping file.

The article is not readable for me, but I know how to upload the custom mapping and use the syntax.

I tested this and it works for me. Although not perfect, I guess it will do.

[john_wang]

Thank you for you outstanding support! @benwinkeler