Skip to main content

Error: 'The transaction log for database is full due to active transaction'

Written by Charnjit Singh Dharival

When using the plan to look at the demand planner, the following error generated:-

An unexpected error occurred. Please report this problem to your system administrator with the following information: System.Data.Sqlclient.SqlException: the transaction log for database 'DATABASENAME' is full due to ACTIVE_TRANSACTION

Or, when I run the data import the following error generates:-

Orchestrate Data Flow import has failed. The detailed information is as follows:

the transaction log for database 'DATABASENAME' is full due to ACTIVE_TRANSACTION

Import command:
EXEC [wf].[pr_Merge_orc_orders]


The transaction logs from the database need shrinking. Please raise a new case online and reference the title of this article.

Did this answer your question?