Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

YE Close fails because Log File is too large

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

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: YE Close fails because Log File is too large

    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.

    alaskasworld

  • Gavin Profile Picture
    Gavin 2,339 on at
    RE: YE Close fails because Log File is too large

    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

  • Robert Yao Profile Picture
    Robert Yao 492 on at
    RE: YE Close fails because Log File is too large

    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

  • Leng Papio Profile Picture
    Leng Papio 855 on at
    RE: YE Close fails because Log File is too large

    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.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans