topic Re: How to view SQL statement executed by Replicate for a single UPDATE statement? in Qlik Replicate

How to view SQL statement executed by Replicate for a single UPDATE statement?

MoeE — Tue, 09 Jan 2024 00:36:19 GMT

Hi,

I have a task which is in transactional apply mode. I'd like to view the actual SQL statement executed by Replicate if possible. I have already tried increasing TARGET_APPLY and SOURCE_CAPTURE to verbose levels, executing an UPDATE of one record on the source and then checking the logs but it didn't include the SQL statement.

Is there a way to view the SQL statements executed by Replicate for an UPDATE? Thanks.

Regards,

Mohammed

Re: How to view SQL statement executed by Replicate for a single UPDATE statement?

DesmondWOO — Tue, 09 Jan 2024 01:08:18 GMT

Hi @MoeE ,

Could you please specify your source and target endpoints?

Regards,
Desmond

Re: How to view SQL statement executed by Replicate for a single UPDATE statement?

john_wang — Tue, 09 Jan 2024 03:24:23 GMT

Hello Mohammed @MoeE ,

Good morning and thanks for the post.

Besides Desmond's comment, in general Qlik Replicate task will print the applying SQL statement with TARGET_APPLY = Verbose and under Transactional Apply mode. If you cannot get them from task log files, Please share the source and target side DBs type, we'd like to have a deeper investigation for you.

Another option is checking the recent running SQL's within the target DB.

Hope this helps.

John.

Re: How to view SQL statement executed by Replicate for a single UPDATE statement?

MoeE — Tue, 09 Jan 2024 03:26:50 GMT

Hi John, Hi @DesmondWOO ,

Source is Oracle and target is Event hubs. I have managed to find the SQL statements within the log files and they are encrypted. We will follow the steps to decrypt them. Thanks for the help.

Regards,

Mohammed

Re: How to view SQL statement executed by Replicate for a single UPDATE statement?

john_wang — Tue, 09 Jan 2024 03:45:21 GMT

Hello @MoeE ,

Thanks for the feedback.

Event hubs is not a SQL-based endpoint, it's a Data Streaming Platform. Qlik Replicate produces messages to it by using APIs rather than SQL statement, we cannot find such an applying SQL for it.

Regards,

John.

Re: How to view SQL statement executed by Replicate for a single UPDATE statement?

SushilKumar — Tue, 09 Jan 2024 05:17:56 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar