This is Srikanth I am getting error in AX-2009 while deleting the any company

Finance and Operations/AX Technical Forum
1

I am writting the error below:

Cannot delete a record in Ledger transactions (LedgerTrans). Voucher: , .
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Native Client][SQL Server]The transaction log for database ‘MIDC-AXUAT’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL statement: DELETE FROM LEDGERTRANS WHERE (DATAAREAID=?)

once i get this error i tried to delete this table data from sqlserver database by running this following query, then after again i am getting same error for other tables.

DELETE FROM LEDGERTRANS WHERE (DATAAREAID=‘company name’)

can any one help me to resolve this error,

2

Hi,

Your SQL transaction is full which needs to be truncated. This usually happens when log files are not backed up.

Steps to truncate log file are here - http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/

NOTE - please make sure you have database backed up.

3

Hi harish,

thanks for help.

can u please tell me one more thing, after getting that error i Supposed to delete the data from database(SQLSERVER) by running the delete query.

but i just want to what is actual process once we get this below error:

Cannot delete a record in Ledger transactions (LedgerTrans). Voucher: , .
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Native Client][SQL Server]The transaction log for database ‘MIDC-AXUAT’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL statement: DELETE FROM LEDGERTRANS WHERE (DATAAREAID=?)

and also can u please brief me why we getting this problem.

regards

Srikanth