Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by HenkeNord

465

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?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

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.

Was this reply helpful? Yes No