The transaction log for database 'Enterprise_Mgr' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

book

Article ID: 4714

calendar_today

Updated On:

Products

CA Virtual Privilege Manager CA Privileged Identity Management Endpoint (PIM) CA Privileged Access Manager (PAM)

Issue/Introduction

I am receiving this error after logging into the Enterprise Manager: The transaction log for database 'Enterprise_Mgr' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases. The database 'Enterprise_Mgr' is on Microsoft SQL Server. 

Cause

This error is generated by Microsoft SQL Server when the database logs/files have become full and no data can be updated within the database. 

The document below from MSDN explains what is happening here.

https://docs.microsoft.com/en-us/sql/relational-databases/logs/the-transaction-log-sql-server?redirectedfrom=MSDN&view=sql-server-ver15

Environment

Enterprise Manager 12.8, 12.9
Microsoft SQL database

Resolution

Please provide the error to the MSSQL DBA so they can clean up the transaction logs for the database. After they have been cleaned, restart the JBoss service.