Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Change Tracking and Management reporter

Posted on by 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

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    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 Profile Picture
    RebeccaM 30 on at
    RE: Change Tracking and Management reporter

    Thank you so much for the reply!  Much appreciated!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    RebeccaM 30 on at
    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 Profile Picture
    EDJJR on at
    RE: Change Tracking and Management reporter

    Good Morning,

    I would recommend opening a support case to troubleshoot the issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans