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

Change Log entries

(0) Share

Report

Posted on by Chilesr

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?

All responses (12)

Answers (0)

Chilesr 5 on at

Like (1)

Report

RE: Change Log entries

Thanks alot this worked.....
Suggested answer

Marco Mels on at

Like (0)

Report

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 5 on at

Like (1)

Report

RE: Change Log entries

Thanks alot, i will be trying out the suggested links
Suggested answer

Karan Mehta 8 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 8 on at

Like (0)

Report

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 950 on at

Like (0)

Report

RE: Change Log entries

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

divyeshchitte 950 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 5 on at

Like (0)

Report

RE: Change Log entries

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