topic Re: GENERAL_EXCEPTION,Failure in resolving database version in Qlik Replicate

GENERAL_EXCEPTION,Failure in resolving database version

diegostammer — Fri, 18 Aug 2023 17:42:52 GMT

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.

Re: GENERAL_EXCEPTION,Failure in resolving database version

Dana_Baldwin — Fri, 18 Aug 2023 17:50:32 GMT

Hi @diegostammer

Which version of Replicate are you using?

Thanks,

Dana

Re: GENERAL_EXCEPTION,Failure in resolving database version

diegostammer — Fri, 18 Aug 2023 18:39:08 GMT

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

Re: GENERAL_EXCEPTION,Failure in resolving database version

Dana_Baldwin — Fri, 18 Aug 2023 18:53:48 GMT

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

Re: GENERAL_EXCEPTION,Failure in resolving database version

diegostammer — Fri, 18 Aug 2023 18:57:11 GMT

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

Re: GENERAL_EXCEPTION,Failure in resolving database version

nareshkumar — Sun, 23 Mar 2025 18:48:26 GMT

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)

Re: GENERAL_EXCEPTION,Failure in resolving database version

john_wang — Sun, 23 Mar 2025 23:43:02 GMT

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.