Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Something (probably MRP) generates 20 000 rows per day in EventCUD

Posted on by 459

We have a problem with constantly growing database in AX 2012 R3 CU9. 

When locking in the SQL Manager I see that table EventCUD is by fare the biggest tabel in the system. When looking mpre into details, I see that something generaates 20 000 rows per day during a coupple of hours in the night. The event comes from table id 8612, JmgJobTable.

Is it possible to turn something off to prevent to rows from being generated?

Categories:
  • HenkeNord Profile Picture
    HenkeNord 459 on at
    RE: Something (probably MRP) generates 20 000 rows per day in EventCUD

    Ah, I thought it camed from database log. I had three alerts active which now are disabled. I'll see if that fix the problem.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Something (probably MRP) generates 20 000 rows per day in EventCUD

    This table is populated based on alert rules that users have set up. Seems that you should review what kind of alerts your users have subscribed to. You can prevent these rows from being created by changing the alert setup and not asking for alerts when JmgJobTable data changes.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans