Limited sending error emails

[mujiburrahman_2704]

I have one use case, I want to limit sending emails if a task error occurs.

I want if there is a task that experiences any errors, I will only send 5 emails. although the error log is more than that

I tried to activate the configuration if there was an error then the task was stopped, but after I tried to make my task an error, the configuration was not realized, the task was still running even though the spam error had been entered

Configuration stop task when table errorstop task when data error

for email notifications, I activate it in qlik enterprise manager

I have a focus on this configuration, because an error occurred with an error log of more than 500,000 data due to the first load, causing load problems on the email server.

[OritA]

Hi, 

In general there are different types of error for which you can configure different behaviour in Replicate. As you can see in the 'Error Handling' configuration screen in the task settings, you can distinguish between environmental errors, data errors and table errors. For every error type you can define the requested behaviour in the task and in addition you can also control the task behaviour when data conflicts are encountered.  You can find more details about error handling in the following documentation section: 
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/C...

For every error type, in case of retries you can limit the number of rerties and as a result limit the number of times you get the error. If you have tried a specific scenario that does not work for you, please open an salesforce case and attach the relevant diagnostic package to the case for further troubleshooting. 

Thanks & Regards,

Orit

[mujiburrahman_2704]

The error I tried was an error when reading data because there were special characters in the table column names, is that included in the table structure error?

This error is an example that I made myself

and the error occurred because 500,000 data failed to enter the destination, not repeating a single data.

But is there any other way besides stopping task, in order not spamming email?

Thanks and regard

Muji

[OritA]

Hi Muji, 

In general the error Data error handling is not relevant for Full Load replication. It is applicable to Apply Changes (CDC) replication only. So it explains what you see. In general any notification status change is triggered independently so there is not way to 'accumulate' it. Defining a notification rule for any data error is usually not recommended. May be in your case you should define notification rule for 'Full load completed'  (not sure) . For additional details about the notification types that can be created please refer to the Replicate user guide or QEM users guide. 

Regards,

Orit 

[SushilKumar]

Hello @mujiburrahman_2704 

To add more to Tse comment DATA Error frequency is more. because it mainly maintained by Error handling policy. It is always recommended whenever as data error occurred, we suppose to find out the issue and process with analysis and resolution to avoid the data discrepancy among participating databases.

 there is certain mechanism put in place to identify the data issue.

Regards,

Sushil Kumar