Supply chain | Supply Chain Management, Commerce

Change Based Alerts not Triggering

(1) Share

Report

Posted on by The.Clem

Hello D365 Forum!

I've read over the documentation on alerts here and saw the limitation that you cannot create alerts on secondary data sources on forms.

On the Alerts Overview, however, it does say you can use alerts to monitor filtered Data.

What I have a question about is how this works on certain forms and with certain filters enabled.

My first example is regarding the Released Products form. (EcoResProductDetailsExtended)

The Quality business users want a simple alert to let them know when a new product is created so they can assign the correct Item Quality Group to these newly created items.
Creating an alert through the UI does not throw any errors and it looks like the alert should work we do not get any notifications/emails from it.

My second example is on the Bills of Materials Form

I applied a filter to the form to show only Approved BOMs and created an Alert here
Changing the Approval from No to Yes on a Bill of Materials to trigger the alert, but did not get any notification from it.

Is this due to the inability to create an alert on a secondary data source, or another issue?

All responses (7)

Answers (0)

Suggested answer

andreasraithel 4,833 Super User 2024 Season 2 on at

Like (1)

Report

Change Based Alerts not Triggering

Hy to all,

as for my experience we had similar issue with a huge EventCUD table. Because of thousands of users created rules, some times on master data table, but sometimes also on transactional table, which is quite senseless.

So the EventCUD table is a little bit magic (not really) how it is populated and cleaned, see also AX 2012 – EventCUD (constant growth) | DAXteam's Blog (wordpress.com)

We could only resolve the issue with 1) cleaning up the alerts first (because users left, bus alerts rules stays) and we had tons of old alerts and 2) cleaning the EventCUD table to remove "orphanized records".

And we recommend also to run the Notification Cleanup Batch to maintain the notification tables.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect
André Arnaud de Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

Change Based Alerts not Triggering

Hi Clem,

Interesting. I have seen dead entries before where the trigger was still enabled, but no users had an active alert anymore. In AX 2012, this was recognizable in a specific table. Now the alerts are managed with database triggers, where I don't know directly what to check for. This would need a bit of investigation.

I'm not fully sure if the executing status has an impact. In my demo environments, I don't have such records. Anyway, looking at the table browser with eventCUD information, an entry for the item seems to be created. The batch job delivers one event, but not the other? Are you able to use the debugger to check the behavior of the change based alerts job?
The.Clem 51 on at

Like (0)

Report

Change Based Alerts not Triggering

Hi Andre!

The alert I created via Table Browser was for a record update not record creation; this was for change on the "Active" field on the BomVersions table since it is not directly accessible from a form.

I created a new alert on the BOMVersions table for "Record has been Created" to see if this triggers.

It both created an entry in the EventCUD table, and I received the notification several minutes later.

When I created a new Item, the EventCUD also got an entry created followed shortly after by a second entry which may or may not be related.

Our EventCUD table has a lot of dead entries dating all the way back to 2022. My understanding of this table is that records should be deleted after they are processed from this table, but we have ~28k records that are either in status "Waiting" or "Executing";

Could these be impacting the processing of new events?

I also noticed something strange from the users - they don't have full security access to the Custom Alert Creation form, but they have additional permissions on the Manage Alerts form;

Could security permissions be impacting the processing of the alerts created?
André Arnaud de Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

Change Based Alerts not Triggering

Hi Clem,

When you created an alert via the table browser, was that also an alert for the creation of new records? Do you get alerts for new Bill of Materials?

The alert on the creation of released products is working for me. Can you check if events are logged in the eventCUD table? You can check this with the table browser by altering the URL to include: &mi=SysTableBrowser&TableName=eventCUD. If there is no record, then probably a specific filter was active on the released products form when you created the alert. That will then also restrict which new products will meet the requirements of that filter.

For the second example, your understanding is now correct, thanks to the explanation from Andreas.
The.Clem 51 on at

Like (0)

Report

Change Based Alerts not Triggering

Hi Andreas and Andre!

Unfortunately this doesn't solve my issue.

I confirmed that the Change-Based Alerts job is running

I have set an alert on the SysTableBrowser and that triggers correctly, however the following alert does not trigger on item creation:

Do you have any thoughts as to why this would not trigger on item creation? I created the trigger from the Product Information Management->Products->Released Products form. Is this where you created your alert from?

I think I understand about the second scenario better now from Andreas' example.

Applying the filters and using the "Record Created" trigger does not work in the instance I had suggested since the record is not created with that status, correct?

The record is created in a different status, then updated and the update is what triggers the filter criteria to be met. The trigger should be on the change of the field to match the record.

Thanks for getting back to me,

-Clem
André Arnaud de Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

Change Based Alerts not Triggering

Hi The.Clem,

Can you tell us if the reply from Andreas helped you? It would be great if you can provide us with an update. Also in case you still have open questions on this topic.
Suggested answer

andreasraithel 4,833 Super User 2024 Season 2 on at

Like (1)

Report

Change Based Alerts not Triggering

Hy,

please:

- ensure that the batch job for processing change based alerts is setup accordingly (recurrance, is active)

- ensure uses has activared to messages as notification

- setup the alert on the correct table (items - works for me)

I've testet the first case and work fine for me in Std. environment

Your second case is not matching the rules. If you set filter to Approved = Yes it will not trigger if the approved field value = No

Instead do not set a filter and if approval field changes from No to Yes it will trigger the alert.

If the alert does trigger because of any table relation, you can also setup the alert on a table direct using table browser.

Hope this helps.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect