Troubleshooting: Year End Closing Error - The transaction log for database AED XXX is full due to ‘ACTIVE TRANSACTION’

Question: When run year end closing, an error prompted - Unknown Sql Exception (Number= 9002, Message= The transaction log for database ‘AED_XXX” is full due to ‘ACTIVE_TRANSACTION’)

Version: 1.8 / 1.9 / 2.0

Possible Reason (1):

The file autogrowth is not enabled or the maximum file size is too small.

Solution (1):

1) Search and connect to SQL Management Studio.

2) Right click on the database name and select Properties.

3) Go to Files, and click on … button for LOG file type, check to Enable Autogrowth, set the maximum file size, then click on OK.

Possible Reason (2):

The disk that used to store AutoCount data is full, usually located at C:\AutoCount Data.

Solution (2):

Try to clear up the disk space and run Year End Closing again.

Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.

By: Benjamin 230103, Lay Swan 230112, P230126

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations