EventCUD are growing by unexisting alert on inventTrans

(0) Share

Report

Posted on by XBB

On insert a record on inventTrans a eventCUD records is created.

We have not created any alerts for inventTrans, I tried to remove alert by alert to try to find which alert is causing the error.

Finally I remove all alerts and still EventCUD tried to create a record. When I create a inventTrans insert event is called and call to method CreateEventCUD on application class.

Now without alerts still call createEventCUD but eventCud is not create thanks to the method hasCompanyRules.

¿Any Idea about what are happening?

Regards

All responses (9)

Answers (1)

Mariano G. 3,562 on at

Like (0)

Report

EventCUD are growing by unexisting alert on inventTrans

I had the same issue a few years ago. The problem is that when you create an alert, a trigger is created at the table level in the Dynamics database. When you delete your alert, the trigger should be deleted, but sometimes, I don't know why, it isn't. Then, the EventCUD record is created even though there is no alert, because it is created by the trigger. The solution is to create an alert on the same table and then delete it. That should remove all the triggers related to the table
GTav 4 on at

Like (0)

Report

EventCUD are growing by unexisting alert on inventTrans

@XBB, have you solved? I have the same problem.
XBB 5 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

Alerts was deleted on form and the records on eventCud were delete using sql setence on EventCUD table Browser.

After it I checked if all was deleted on directy on sql.
Verified answer

André Arnaud de Cal... 294,095 Super User 2025 Season 1 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

HI XBB,

Can you tell how you deleted all alerts and records in the EventCUD table? When it will be executed from the user interface, there is some business logic executed to also sync with SQL triggers. If you deleted the records from the database directly instead of removing rules from the user interface, the SQL trigger might be still active causing new records in the EventInbox table.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

Hi XBB,

Have you tried to restart AOS in case if it's caching issue?
XBB 5 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

I deleted all alerts, I checked even in SQL that there is not records.

There is not records in EventCUD neither in related tables.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

Hi XBB,

Could you, please, check in the personalization form for Alerts form on the query (last) tab if there are ranges for EventRule data source?

Do you have access to AOT? Could you, please, check table EventCUD directly in table browser?
XBB 5 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

There is no alerts created.

but even without alerts an event execute class to insert records on eventCUD, at this moment how I erased all alerts in test environtment EventCUD is not created because not exists records on EventCompanyRule

This is like an alert on inventTrans was created and removed but is still working.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: EventCUD are growing by unexisting alert on inventTrans

Hi XBB,

Do you mean that EventRule table is completely empty, but event cud records are still created? Or where did you check alerts?