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

From AutoCount Resource Center

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

Active trans1.png

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.

Active trans2.png

Active trans3.png

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

Active trans4.png

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.

Active trans5.png

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

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations