topic Re: How to decrypt query statement from QLIK Replicate Log file? in Qlik Replicate

How to decrypt query statement from QLIK Replicate Log file?

tanhanyan — Fri, 01 Mar 2024 03:06:44 GMT

When QLIK task encountered error, the SQL query statement is encrypted. Is very troublesome where need to login to remote server to decrypt the Query statement.

How should we made this in local machine to decrypt the query statement without install any software? Can we do map folder to server and run the encryption repctl dumplog in local laptop without install software?

Thanks.

Re: How to decrypt query statement from QLIK Replicate Log file?

john_wang — Fri, 01 Mar 2024 03:26:15 GMT

Hello @tanhanyan ,

Thanks for reaching out to Qlik Community!

Please check the article How to Decrypt Qlik Replicate Verbose Task Log Files.

Hope this helps.
John.

Re: How to decrypt query statement from QLIK Replicate Log file?

john_wang — Fri, 01 Mar 2024 03:31:41 GMT

Hello @tanhanyan ,

BTW, the decryption can be done in any Replicate Server, you may copy the task log file and the corresponding "log.key" file to another server (it's better the Replicate Major Version number as same), does not matter the platform (eg Windows, or Linux).

And I'm checking for you if there is a FR about turn it off. Will keep you posted.

Regards,

John.

Re: How to decrypt query statement from QLIK Replicate Log file?

tanhanyan — Fri, 01 Mar 2024 03:40:45 GMT

We only having 1 replicate server, so is it A MUST to install QlikReplicate to local laptop? Copy the log.key to run the command repctl dumplog in own PC?

Re: How to decrypt query statement from QLIK Replicate Log file?

john_wang — Fri, 01 Mar 2024 04:14:49 GMT

Hello @tanhanyan ,

Yes, we need install Qlik Replicate on a local laptop and run the decryption on it. Please be noted that the decrypted task log may contain sensitive data, be careful the data leakage.

BTW, we got the Feature Request Allow option to disable log encryption in Qlik replicate - Give customer the choice. We will look into the FR and get back to you with the most update information.

Regards,

John.

Re: How to decrypt query statement from QLIK Replicate Log file?

tanhanyan — Fri, 01 Mar 2024 06:19:03 GMT

Ok Noted. Thanks, hoping the option made to customer as soon possible. Thanks.

Re: How to decrypt query statement from QLIK Replicate Log file?

john_wang — Fri, 01 Mar 2024 07:39:06 GMT

Hello @tanhanyan ,

I've confirmed that the FR was delivered. There is a chance to disable the Log Encryption in Qlik Replicate, from version (includes) 2023.5 GA release. If you are running Qlik Replicate 2023.5 and 2023.11 (or up) then we may add an parameter to disable it.

I'm editing an aticle to show you how to turn the Log Encryption Off. Will share the link to you later.

Regards,

John.

Re: How to decrypt query statement from QLIK Replicate Log file?

john_wang — Wed, 06 Mar 2024 10:18:12 GMT

Hello @tanhanyan ,

Please check the article:

How to disable Task Log Data Encryption in Qlik Replicate

Feel free to let me know if you need any additional assistance.

Have a nice day,

John.