search cancel

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. 

Environment

Enterprise Manager 12.8, 12.9
Microsoft SQL database

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

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.