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

[iti-attunity-sup]

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.

[Dana_Baldwin]

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

[DesmondWOO · Accepted solution]

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