SQLServerException: The transaction log for database ... is full due to 'ACTIVE_TRANSACTION'.

Gido

Problem

Exporting Data from Datameer to a MS SQL Server is failing.

Error Message

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The transaction log for database 'DatameerConnect' is full due to 'ACTIVE_TRANSACTION'.

Cause

The most common reason to receive this message is due to limited disk space on the SQL host server.

Solution

Investigate the space allotted to the service. The article Troubleshoot a Full Transaction Log (SQL Server Error 9002) details how to combat this.