Qlik Replicate : Postgres as a source error replicating column from a view

shashi_holla — Mon, 27 Mar 2023 07:43:37 GMT

The following warning is logged while replicating a view from a Postgres source endpoint. This causes the NCLOB/String columns to be NULL on the target.

[SOURCE_UNLOAD ]V: Value for column 'XXXXX' was truncated. bind type: -8, data len: 10 (10, after truncation: -2), bind len: 0, statement: XXXXXX

Resolution

Set the Limited LOB size to exceed the max data volume on the source (default 8 KB)

Note: 64KB is an example. The actual value depends on the column size on the source.
Change the column data type:
1. Table Settings
2. Transform
3. Change from NCLOB to WSTRING (64000) and set the data length to the same as the max LOB column length above.
Add the following internal parameter on your source Postgres:

unboundedVarcharMaxSizeODBC
Value: Set it to max data length provided on the table column.

For more information on how to set Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
Run the task.

article Qlik Replicate : Postgres as a source error replicating column from a view in Official Support Articles

Qlik Replicate : Postgres as a source error replicating column from a view

Resolution

Environment