Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

EventCUD are growing by unexisting alert on inventTrans

Posted on by 5

Hi

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

  • XBB Profile Picture
    XBB 5 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    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 Profile Picture
    Sergei Minozhenko 23,089 on at
    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 Profile Picture
    XBB 5 on at
    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 Profile Picture
    Sergei Minozhenko 23,089 on at
    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 Profile Picture
    XBB 5 on at
    RE: EventCUD are growing by unexisting alert on inventTrans

    There is no alerts created.

    pastedimage1611245717968v1.png

    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

    pastedimage1611245809956v2.png

    This is like an alert on inventTrans was created and removed but is still working.

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans