Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Change Log Setup and C...
Microsoft Dynamics NAV (Archived)

Change Log Setup and Change Log Entry

(0) ShareShare
ReportReport
Posted on by mbr 5,124

Our company wants to perform audit trails on all mods/inserts/deletion of tables in Nav as we seem to be having problems with users making changes and causing problems for our Nav day to day business undertakings.  So I enabled pretty much 90% of the tables to ensure we cover everything.  Is this okay?  I know we have to watch the growth of the sql server DB as this could cause the DB to grow exponentially.  But since harddrive space is cheap, we are okay with it.  We would just need to add more harddrive space and perhaps RAM if need be.  Does anyone foresee any problems with turning on Change Log Entry and enabling audits on 90% of the tables?  I gather since Nav has this feature, we could use it to full capacity.  Are there any other precautions anyone wish to impart?

Please advise.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Change Log Setup and Change Log Entry

    Thanks for all the suggestions.

    I did backup the records to excel. But i'm facing this issue where the Change Log Entry table was locked by another user.

    I tried restarting the instance as well. Still no luck.

    What are your suggestions, Delete the records through SQL ?

    i have around 6000000+ records

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: Change Log Setup and Change Log Entry

    Hi,

    Enabling Change log entries for many tables will definitely decrease the performance and also increase the size of database. sometimes it land up with the table lock entry issue which we had faced with one of our customer in past.

    you can create one another SQL database with the same table as change log and then with the SQL script you can transfer all your change log record in it and delete the same from your production database. you can also automate by SQL as tharanga suggested.

    I recommend to active the change log for only those tables and fields which are necessary to have a log instead to include all the fields of table.

    Regards,

    Saurabh Shah

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Change Log Setup and Change Log Entry

    It will definitely increase the size of the DB and performance of the NAV will decrease for a certain amount.

    As a solution for that you can export old change log entries to a another DB or to a excel file and delete those entries. By doing that you will be able to decrease the size of NAV DB and increase the performance.

    You can schedule SQL Server Agent to handle this. Once a month move all the change log entries to a separate DB table and delete the entries from NAV change log table.

    If you want to save them in excel file then you can easily use NAV jobs to handle this.

    (Create a XML port and export the data)

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Change Log Setup and Change Log Entry

    Change Log Entry table will grow too fast and same with database.

    Performance may decrease.

    Export and save the data from change log entry table to excel or some other.

    and delete the data from change log entry table

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans