Symantec Identity Governance - The transaction log for database 'DB' is full due to 'LOG_BACKUP'.

Products

• CA Identity Suite
• CA Identity Governance

Issue/Introduction

After starting an import in Identity Governance in the 14.x Environment. The following error was thrown when progress reached 80%:

Error: PreparedStatementCallback; uncategorized SQLException for SQL [ DELETE AuditEntities WHERE AuditCardID=?]; SQL state [S0002]; error code [9002]; The transaction log for database 'IG_Eurekify_db' is full due to 'LOG_BACKUP'.; nested exception is com...

Environment

Release : 14.X

Component : IdentitySuite(Identity Suite)

Component : IdentityGovernance(Identity Governance)

Resolution

Try one of the four suggestions below to fix this issue:

1. Under SQL Server Management Studio set the Maximum File Size under options for Altiris database to Unrestricted File Growth.
   
   
2. Increase the Restricted File Growth (MB) size to a larger value creating space for transaction logs to grow.
   
   
3. Shrink the log files from the task. Right-click Search_Service_DB, go to Tasks -> Shrink -> Shrink Files.  Select a File type of Log, then Shrink.
   
   
4. Move the Existing Transaction log files to a different location to work around this.
   
   
   

NOTE: Please make sure you have a fresh and full backup of the Database before following the above suggestion. Kindly follow the steps only with the assistance of your DBA team.

Additional Information

This issue is an SQL database configuration related issue.

https://learn.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-ver16

The 9002 error occurs when the transaction log becomes large or runs out of space in SQL Server.

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/availability-groups/error-9002-transaction-log-large