Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
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,337 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans