web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error running AP Histo...
Microsoft Dynamics GP (Archived)

Error running AP Historical ATB

(0) ShareShare
ReportReport
Posted on by Clyde Hall 405

We are using GP 2010 under SQL 2008.  When attempting to print the Historical AP ATB we are getting the following error.

[Microsoft][SQL Server Native Client 10.0][SQL Server] The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log-reuse-wait-desc column in sys.databases.

Does anyone know how to fix this ??

Thanks,

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    You will need to shrink the log files.   I would also check the server space.   To find instructions for shrinking the log file, you can Google it or search Knowledgebase under Customersource or Partnersource.   You will want to act quickly if there is a shortage of space as data corruption can occur. Is there a great deal of history?

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    The quickest way to shrink the log file for the tempdb database is it stop and start SQL. Dan is also correct that you should check you available space on your drive. You may need to move your tempdb database to a drive with more space. Make sure all of your using are out of GP before stopping and starting SQL.

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

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans