Notification not sending from an event trigger

[Kris Jensen]

I'm at a loss.  I have created a Business Rule - Event trigger - Notification to occur when the Change moves from the Implement state to Review state.  No matter what I do, the actual email is never sent, not even created.  The business rule runs correctly, the event triggers correctly, the notification record is entered but nothing happens.  I know  the values are available, but I just can't figure out why it's not sending the email.

HELP!!!!!!

In the business rule I've tried the "current record" and the "Sys Approval Group record."

Here is the event record -

Here is the notification record -

Email template -

Log shows notification record is being entered, but no email is actually sent

[RaghavSh]

Try below:

In the subject it should be ${parent.number}

You have put the $ inside brackets.

[Kris Jensen]

I'm getting this error now -

FAILED TRYING TO EXECUTE ON CONNECTION glide.16 (connpid=1005027): INSERT INTO sys_watermark (`number`,`sys_id`,`sys_updated_by`,`sys_created_on`,`sys_mod_count`,`source_id`,`sys_updated_on`,`source_table`,`email`,`sys_created_by`) VALUES('MSG0190231','3469ff261b5f55502f4b0ed8cc4bcbaa','system','2022-11-24 17:52:42',0,'bb6b572a1b9b55502f4b0ed8cc4bcbf5','2022-11-24 17:52:42','change_request','fc69ff261b5f55502f4b0ed8cc4bcbaa','system') /* ibmismdev015, gs:glide.scheduler.worker.3, tx:f869ff261b5f55502f4b0ed8cc4bcba7 */
Unique Key violation detected by database ((conn=1005027) Duplicate entry 'MSG0190231' for key 'number')
: java.sql.SQLIntegrityConstraintViolationException: (conn=1005027) Duplicate entry 'MSG0190231' for key 'number': org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:229)

[Musab Rasheed]

Hello,

Apart from what Raghav has pointed out can you please remove all parameters except first one and try again ? In Notification you are including Assignment group hence don't pass them as parameters again.

[Slava Savitsky]

This error means that the number the system is trying to assign to the watermark to be used for your email is already used by another watermark. Check record numbering settings for the Email Watermark [sys_watermark] table. Also verify that the script in the Default Value field of the Dictionary Entry for the Number field in the Email Watermark table has not been customized.