Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by HenkeNord

461

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?

All responses (2)

Answers (0)

HenkeNord 461 on at

Like (0)

Report

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 101,158 Moderator on at

Like (0)

Report

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.