RetCode: SQL_ERROR SqlState: 55000 NativeError

[Lakshman]

Hi Qlik Replicate team,

We made a connection between src(Postgres sql) to tgt(DB2) and tried running a CDC task. But getting this error message and unable to proceed further. Please do the needful.
Error: RetCode: SQL_ERROR SqlState: 55000 NativeError: 1 Message: ERROR: logical decoding requires wal_level >= logical;

Organization: Toyota

Task: UTTMS_PG_DB2_CDC

PFA: Log

Thank you,

Lakshman

[Arun_Arasu]

Hi @Lakshman ,

Can you please verify if the below prerequisites is met

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/PostgreSQL/prereq_postgresql_so...

Thanks & Regards,

Arun

[Lakshman]

** PROTECTED ?????

Thank you, Arun. We will do accordingly

[Arun_Arasu · Accepted solution]

Thanks @Lakshman  , on further looking at the log , it seems to be you are using Source endpoint 'Amazon RDS for PostgreSQL' .

Below is the user guide for it , please go thru the prerequisites  and make sure you have set all the required permission for CDC as described in the document

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/AWS%20RDS%20PostgreSQL/aws_post...

Also the log says database version is 'PostgreSQL 14.2 ' .. Below are the supported version 

PostgreSQL 9.6, 10.x, 11.x, 12.x, and 13.x

Please refer the below support matrix for the same

https://help.qlik.com/en-US/replicate/May2022/pdf/Replicate-Support-Matrix.pdf

Hope this helps

Thanks & Regards,

Arun

[Alan_Wang · Accepted solution]

Hi @Lakshman 

The rds.logical_replication parameter should be set to 1. Here is the documentation to setup postgres for RDS to enable CDC.

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/AWS%20RDS%20PostgreSQL/aws_post...

As noted by Arun, Replicate's support matrix does not include Postgres 14.x