Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Change Log entries

(0) ShareShare
ReportReport
Posted on by 5

The system in the changelog shows no activities done on two particular days and yet it was a normal working day. No postings in the GL are showing despite Users having logged into the system and working as normal. Can someone assist me with why no entries are showing even when end-users were working and posting transactions that are not showing in the system?

  • Chilesr Profile Picture
    Chilesr 5 on at
    RE: Change Log entries

    Thanks alot this worked.....

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Change Log entries

    Hello,

    Let the community know if this was the required outcome and also verify the answer if it is.

    Thanks.

  • Chilesr Profile Picture
    Chilesr 5 on at
    RE: Change Log entries

    Thanks alot, i will be trying out the suggested links

  • Suggested answer
    Karan Mehta Profile Picture
    Karan Mehta 8 on at
    RE: Change Log entries

    Hello, @chilesr,

    That's a lot of space.

    It seems that each and every activity is monitored in change log entries. There are options to remove few of the options which monitors each and every clicks of user but for the option of shrinking DB,

    There are options available (Please do the same on Demo Instance first)

    https://support.microsoft.com/en-in/help/307487/how-to-shrink-the-tempdb-database-in-sql-server

    https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?redirectedfrom=MSDN&view=sql-server-ver15

    I'm sure either of the above mentioned links will be able to assist you in shrinking your TempDB.

    Regards

    Karan

    _ Please click on Verify the answer if the same is helping you out_

  • Chilesr Profile Picture
    Chilesr 5 on at
    RE: Change Log entries

    I used this to delete some change log enteries..Departments/Administration/IT Administration/Data Deletion/Delete Entries" there you can see "Delete Change Log Entries" However the performance is still slow because the change log db is still large...So in my MS SQL Server 2014/MSSQL/  under DATA folder i have the following database sizes and i want to find ways of shrinking them;

    1. CompanyName_Data - 59GB

    2. CompanyName_Log - 10.9 GB

    3. Tempdb - 104GB

    4. templog - 2GB

    If i can have ways to shrink the "tempdb of 104GB"

    Thanks

  • Karan Mehta Profile Picture
    Karan Mehta 8 on at
    RE: Change Log entries

    Hello @chilesr,

    As i understand, Even having the normal work days and entries are being done (Posted/Parked), The change log entries aren't showing any change or activities done during those times -

    Generally this is because one or more of the settings which might have been changed or removed from change log entry i.e. Since each and every activity can be logged there in, It might have been possible that someone by mistake must have deactivated the Change log entries.

    Also, Please keep in mind that since every click is stored, It also consumes the storage, So if the storage capacity has reached it's limits, it might not be logging the entries in. This would also seen if it's impacting the system's performance.  

    You can check the settings here : docs.microsoft.com/.../across-log-changes

    Regards

    Karan

    - Request you to please verify the answer if it helps you. -

    - If there is other alternative solution, I'd request you to please note the same down, It might help other people-

  • Suggested answer
    divyeshchitte Profile Picture
    divyeshchitte 950 on at
    RE: Change Log entries

    You can check G/L Registers to view the Log for ledger transactions.

    pastedimage1594208669052v1.png

  • Suggested answer
    divyeshchitte Profile Picture
    divyeshchitte 950 on at
    RE: Change Log entries

    Yes Change log entries affect the database size, this totally depend upon where you have enabled it.

    We should avoid Change log Entries on Ledger tables as we can already see the same in Ledger tables.

  • Chilesr Profile Picture
    Chilesr 5 on at
    RE: Change Log entries

    Can the change log entries affect the performance of the system.? My database has grown to 58GB, with Change log entries as far back as 2016.

  • Chilesr Profile Picture
    Chilesr 5 on at
    RE: Change Log entries

    Yes the Change Log is Activated and apprently it shows no one logged in on two particular dates...

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans