topic Re: Configure notifications in Qlik Replicate

Configure notifications

FrancoHR — Tue, 13 Jun 2023 21:14:18 GMT

Is it possible to configure a notification when a task does not find the archive log sequence before it fails and marks error?

Thanks,

Re: Configure notifications

john_wang — Wed, 14 Jun 2023 01:16:57 GMT

Hello @FrancoHR ,

Thanks for opening the article.

Replicate will send notification messages (include many different errors and resources control types) to 3 locations:

Windows Event Log (on Windows platform), or Linux System Log (on Linux platform)
Predefined Email recipients
Task log files

In your mentioned scenario, define "Any error" and define DBA Email Recipients then for any error your DBA will get notification email. By the way, not only "redo log not found" error, but any error will also trigger the notification.

Hope this helps.

Regards,

John.

Re: Configure notifications

Arun_Arasu — Wed, 14 Jun 2023 04:46:24 GMT

Hello @FrancoHR ,

Thanks for reaching out to Qlik Community.

The notification gets triggered once the task gets errored out, so I don't think we have an option to trigger a notification before the task fails or marked as error.

The behavior can be noticed in the logs as well , below is an example on the order of execution

00005048: 2023-06-12T09:58:09 [SERVER ]E: RetCode: SQL_ERROR SqlState: 08001 NativeError: 258 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out. [1022502] (ar_odbc_conn.c:584)
00005048: 2023-06-12T09:58:09 [SERVER ]E: Failed to connect [1022506] (sqlserver_endpoint_imp.c:2221)
00008052: 2023-06-12T09:58:10 [UTILITIES ]I: Mail "[QLIK Any Error Notification] Global:encountered errors" sent successfully (notification_manager.c:1923)

We hope the above was helpful

Thanks & Regards

Arun