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

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi XBB,

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

Was this reply helpful? Yes No
XBB 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
XBB 5 on at

Like (0)

Report
Copy link

Link copied!

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

There is not records in EventCUD neither in related tables.

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi XBB,

Have you tried to restart AOS in case if it's caching issue?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 304,182 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
XBB 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
GTav 4 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mariano G. 3,598 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No