Qlik Replicate: Aurora PostgreSQL unlimited size data types

[Alan_Wang]

PostgreSQL hosted on Aurora behaves differently than an on-prem instance of PostgreSQL when data types of unlimited size are processed from the source by Qlik Replicate. Qlik Replicate will truncate all the data in those columns to NULL values. 

This can lead to tasks not loading all tables or a high CPU load.

Resolution

We recommend setting a size limit on the data type to prevent this behaviour or setting an internal parameter unboundedVarcharMaxSize and giving it a value based on your capacity. This parameter will assign the value to the data type for the size limit if the column is originally unlimited in size.

For information on how to set internal parameters, see Setting advanced connection properties.

Example:

With an internal parameter value at 200:

varying character will turn to varying character(200)
varying character(100) will stay as varying character(100)

Environment

Qlik Replicate 

Internal Investigation ID(s) 

0066686