GENERAL_EXCEPTION,Failure in resolving database version

[diegostammer]

While testing connection to an AWS Aurora PostgreSQL 14.6 database I'm receiving the following error:

SYS-E-HTTPFAIL, Failure in resolving database version..

SYS,GENERAL_EXCEPTION,Failure in resolving database version.,Supported major version numbers range is [9..11]. Source database version number is not supported: 140006 PostgreSQL 14.6 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit

Any help is appreciated.

Qlik Replicate 

[Dana_Baldwin]

Hi @diegostammer 

Which version of Replicate are you using?

Thanks,

Dana

[diegostammer]

April 2020 (6.6.0.904)

Probably, that's the issue.

I didn't even think about Replicate version, because I'd installed it using AWS marketplace. Presumed, it would be in the latest version.
I'll upgrade it and let you know.

Thanks, @Dana_Baldwin 

[Dana_Baldwin · Accepted solution]

Hi @diegostammer 

Yes that should resolve it, version 6.6 only supported versions 9.4.2, 9.4.5, 9.5, 9.6,
10.x, and 11.x.

Also, we stopped releasing patches for that version on April 30, 2022 so better to be on a fully supported version. Reference: Qlik Replicate Product Lifecycle - Qlik Community - 1837201

Thanks,

Dana

[diegostammer]

I've upgraded it to May 2023 (2023.5.0.322) and now it's working.
AWS Marketplace AMI should be upgraded.

Thanks, @Dana_Baldwin 

[nareshkumar]

Hi Dana,

We are using May 2023  Qlik version 2023.5.0.874  where CDC is not working for Aurora Postgres 14.6 getting WAL reader terminated with broken connection / recoverable error.
WAL stream loop ended abnormally. (STATUS_RECOVERABLE)

[john_wang]

Hi @nareshkumar ,

It's hard to tell without detailed information. Would you please open a support ticket with SOURCE_CAPTURE set to Verbose, and decrypt the task log files, Our support team will be more than happy to assist you.

Regards,

John.