topic Re: Date in the notiifcation in Qlik Replicate

Date in the notiifcation

suvbin — Fri, 08 Sep 2023 04:50:41 GMT

Hi Qlik ,

Is there any way to insert date and time for the latency reduced tickets? these tickets will generate when any of the task reduced the latency.

Right now we are getting the Notification (subject) like this without date.

Thanks in advance

Re: Date in the notiifcation

SachinB — Fri, 08 Sep 2023 05:23:32 GMT

Hello @sub

Thank you for reaching out to the Qlik community!

We do have only below listed supported notification variables. Please find the below link for the same.

https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Server%20Settings/notification_variables.htm

The following variables are not supported even though they are available for selection: ACTIVE_TABLES, ERROR_TABLES , COMMAND, COMMAND_CODE, FULLLOAD_ERROR_TABLES, ERROR_CODE, SQL_STATEMENT, and COMMAND_PARAMETERS.

You can look for the option you get an email in the inbox and consider that date and time.

Regards,

Sachin B.

Re: Date in the notiifcation

suvbin — Mon, 11 Sep 2023 07:08:17 GMT

any other leads on this please.

Re: Date in the notiifcation

SushilKumar — Mon, 11 Sep 2023 08:24:22 GMT

Hello Team,

As Sachin mentioned

We do have only below listed supported notification variables. Please find the below link for the same.

https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Server...

how ever you recive the notification on Realtime basis and body also have server date as well.

Regards,

Sushil Kumar

Re: Date in the notiifcation

Heinvandenheuvel — Tue, 12 Sep 2023 01:56:52 GMT

Hmm, is there not a date-time on the message envelope?

Still, it would seem to be very reasonable to have the ability to include the date/time of the event.

I recommend an enhancement request.

Hein.

Re: Date in the notiifcation

suvbin — Tue, 12 Sep 2023 05:14:05 GMT

yes there is no date and time in the subject of a ticket. But how the message is getting triggered as soon as the latency decrease ? I mean it will store some the latency column (with time and date) value in postgresql right ? so how to take that value and then overwrite in the existing message ? Any clue please .

Atleast till the enhancement been implemented, there should be some solution/workaround to customize the message right ? So could you please help with that

Re: Date in the notiifcation

suvbin — Tue, 12 Sep 2023 05:17:32 GMT

where i have to post this ?

Re: Date in the notiifcation

john_wang — Tue, 12 Sep 2023 05:26:53 GMT

Hello @suvbin ,

Totally agree with @Heinvandenheuvel :

Still, it would seem to be very reasonable to have the ability to include the date/time of the event.

I recommend an enhancement request.

In current versions there is no such variable available yet, Please raise a Feature Request in Ideation area.

Hope this helps.

Regards,

John.

Re: Date in the notiifcation

Heinvandenheuvel — Tue, 12 Sep 2023 13:10:12 GMT

>>> yes there is no date and time in the subject of a ticket.

but the is the timestamp for the message itself, which should be close to the event tiemstamp?

>>> I mean it will store some the latency column (with time and date)

I suspect that for this kind of problem you are focusing on a relatively small set of task, perhaps for a few days or weeks until the core problem is understood. One way to get a bit of a handle on latency issues is to enable PERFORMANCE logging. Using that, you can create a script to select and present the latency from the task logs with 30 seconds granularity. I'll attach a PERL script to help parse the task log and present the PERFORMANCE trace into CSV for presentation.

You can also enable Replicate History for the selected tasks. From the manual:

"E.4 Replication history
The attrep_history table provides statistics about each task, such as the number and volume of records
processed during a particular timeslot. ... TIMESLOT_LATENCY int The latency at the end of the time slot. This is only applicable to CDC time slots. Note that this value contains the value of the target latency only.

Hein.