245
I can't close my year because the system keeps telling me the log file is too big. At first I thought it was the drive size, but I expanded that and I still get the error.
My database is set to Full Recovery Mode - & and I made a full backup before trying to close.
Any suggestions?
Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread.
Hi,
You'll need to make sure you have enough disk space to transfer the contents of GL20000 to GL30000 as per Microsoft article : KB - Year-end closing procedures for General Ledger in Microsoft Dynamics GP
You can use SP_SPACEUSED 'GL20000' to find this out.
The key thing is the transferring of the data to GL30000 is likely performed in one SQL transaction, which will be fully logged, which is why the SQL log will be growing and filling (this will happen in SIMPLE recovery as well) so ensure you have this space for the SQL log file to grow as well. You could temporarily create another SQL log LDF file on another drive that has lots of space while the year end runs. Then, when the year end completes, go through the process of removing the additional LDF file you created. (there's plenty of articles out there on how to do this)
I hope this helps and you manage to run your year end :)
Thanks
Gavin
Hi John,
If you have a full backup, I would recommend you to change from Full to Simple recovery method, truncate the ldf file, try to close the year again, if successful, then change the recovery from Simple to Full again.
Good luck.
Rob
That error is not a usual error in GP yec; it is most likely an issue on your SQL log file... Have your sql or db guy check on it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (