Change Tracking and Management reporter

(0) Share

Report

Posted on by Community Member Microsoft Employee

We are experiencing very slow performance every 3 days and have to turn off Management Reporter and restart. Everything is fine until day 3.

It appears to be from change tracking.

1. Is there something we should be doing with the log file after auto_cleanup start?

2. I noticed that changes are tracked for GL10000 and GL 10001. If we really only care about posted amounts for our reports, can we turn change tracking off for those tables. These tables have about 250,000 records in a change tracking table with auto cleanup set to 3 days.

3.Is tracking GL40000 necessary for Management Reporter, that has nearly 80,000 records in Change tracking in three days.

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Change Tracking and Management reporter

This thread popped up recently, when I was searching for another, and I thought adding some specifics to Natarajan's response might help you understand the necessity of change tracking.

The GL10000 and GL10001 table are where Dynamics GP stores provisional (unposted) General Ledger transactions. One of the features of Management Reporter is producing reports which include provisional data. So, disabling change tracking on these tables cannot be recommended.

The GL40000 table contains GL Setup information, and the NJRNLENT field, or Next Journal Entry would constantly be updated, which is why there are so many records related to this table.

If you are looking to improve performance on your server, here is a link to an article, written by Beat Butcher on changing the default frequency Management Reporter refreshes (set to, UGH, every minute out-of-the-box).

dyngpbeat.wordpress.com/.../the-dreadful-1-minute-refresh-cycle-of-mr2012-datamart
RebeccaM 30 on at

Like (0)

Report

RE: Change Tracking and Management reporter

Thank you so much for the reply! Much appreciated!
Community Member Microsoft Employee on at

Like (1)

Report

RE: Change Tracking and Management reporter

I updated Statistics on table SY40100. In test this did help, quite dramatically on the run time. If you just ran a year end close process, it may cause this table to have indexes that are not effective.

Updating statistics on the individual indexes did not seem to help that much, but updating statistics on the whole table fixed our problem.
RebeccaM 30 on at

Like (0)

Report

RE: Change Tracking and Management reporter

mmiller1225 - Have you received a resolution to your issue? I am having the same issue. Any information you have would be appreciated.

Thanks,

Rebecca
EDJJR on at

Like (0)

Report

RE: Change Tracking and Management reporter

Good Morning,

I would recommend opening a support case to troubleshoot the issue.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Change Tracking and Management reporter

My question was not about companies. We on only have one company. I was asking if we could turn of tracking on GL10000 and GL 10001, since we only report on posted items, and ChangeTracking is being populated at a 90% rate by items we don't even report on. We are having terrible Management Reporter performance,, so we need to do something.
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Change Tracking and Management reporter

Hi Miller,

please make sure change tracking must be on for all companies at the data base level so that data mart refresh process done adequately.

if you add any new company then you need to Reconfigure change tracking so data mart get refreshed