Configure notifications

[FrancoHR]

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

Thanks,

[john_wang]

Hello @FrancoHR ,

Thanks for opening the article.

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

1. Windows Event Log (on Windows platform), or Linux System Log (on Linux platform)
2. Predefined Email recipients
3. 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.

[Arun_Arasu]

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