Qlik Replicate - Right Truncation of data when replicating from or to PostgreSQL

dima_etkin — Wed, 20 Jul 2022 22:22:09 GMT

This article describes a situation involving a PostgreSQL source or target (any supported flavour) when during the replication a message similar to the below can be received from the task:

String data, right truncation Line xxx

Environment

Postgres Source + Target with predetermined datatype length (Relational or similar)
Any supported source + Postgres Target

Resolution

Add "additionalConnectionProperties" internal parameter with "LFConversion=0" value to Postgres Endpoint. ODBC connection string parameters for PostgreSQL database are documented here

Cause

There is Postgres ODBC Driver feature that automatically translates "\n" (LF, 0x0a, New Line) in the data stored in this DB to "\n\r" (LF/CR, 0x0a0d, New Line+Carriage Return) upon data retrieval using the ODBC driver. Usually this is unnoticeable, until it causes cos it may increment the length of the source string beyond the designated length of the same column on the target causing symptoms similar to right truncation...

Internal Investigation ID(s)

Case 00043675

article Qlik Replicate - Right Truncation of data when replicating from or to PostgreSQL in Official Support Articles

Qlik Replicate - Right Truncation of data when replicating from or to PostgreSQL

Environment

Resolution

Cause

Related Content

Internal Investigation ID(s)