topic Re: About "Apply changes", when autocommit is off (MySQL) in Qlik Replicate

About "Apply changes", when autocommit is off (MySQL)

iti-attunity-sup — Tue, 26 Aug 2025 05:48:24 GMT

Source：Aurora MySQL
Target：Aurora MySQL

Hello support team.

Q1. When autocommit = off in target MySQL, "Apply changes" can not be processed ?

Q2. If "Apply changes" can not be processed(Q1), is there any workaround ? (remain autocommit = off)

[case]
In target MySQL, autocommit = off by sever setting.
So, update did not applied.

Although tried setting Internal Parameter : autoCommitInTransactionalMode = true in target endpoint, this issue was not resolved.

Best Regards.

Re: About "Apply changes", when autocommit is off (MySQL)

Dana_Baldwin — Tue, 26 Aug 2025 15:31:51 GMT

Hi @iti-attunity-sup

I do not see a requirement in our documentation for auto commit to be enabled on a MySQL based target. Please open a support case and attach a diagnostics package for the task so we can check the log files and elevate to our internal support team if needed.

Thanks,

Dana

Re: About "Apply changes", when autocommit is off (MySQL)

DesmondWOO — Mon, 01 Sep 2025 01:32:04 GMT

Hi @iti-attunity-sup ,

As we discussed in the support case, there actually isn’t a problem with Qlik Replicate/CDC. It looks like there was a misunderstanding about how to check the CDC data.

Regards,
Desmond