topic Re: RetCode: SQL_ERROR SqlState: 55000 NativeError in Qlik Replicate

RetCode: SQL_ERROR SqlState: 55000 NativeError

Lakshman — Thu, 15 Sep 2022 12:42:34 GMT

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

Re: RetCode: SQL_ERROR SqlState: 55000 NativeError

Arun_Arasu — Thu, 15 Sep 2022 13:03:02 GMT

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_source.htm

Thanks & Regards,

Arun

Re: RetCode: SQL_ERROR SqlState: 55000 NativeError

Lakshman — Thu, 15 Sep 2022 13:04:21 GMT

** PROTECTED ?????

Thank you, Arun. We will do accordingly

Re: RetCode: SQL_ERROR SqlState: 55000 NativeError

Arun_Arasu — Thu, 15 Sep 2022 13:17:00 GMT

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_postgresql_source.htm

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

Re: RetCode: SQL_ERROR SqlState: 55000 NativeError

Alan_Wang — Thu, 15 Sep 2022 22:01:02 GMT

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_postgres_setting_up.htm

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