Unable to start Spotfire Server service. "Error : The transaction log for database 'SPOTFIREDBNAME' is full due to 'LOG_BACKUP' "
book
Article ID: KB0080683
calendar_today
Updated On:
Products
Versions
Spotfire Server
All Versions
Description
Symptoms:
Spotfire server fails to start and the following error is seen in the "catalina.log" (<Spotfire Server Installation Directory>\tomcat\logs\). -------------------------------------------- Caused by: java.lang.RuntimeException: Unable to load the configuration at com.spotfire.server.lifecycle.SpotfireApplicationInitializer.populateServerNameAndVersion(SpotfireApplicationInitializer.java:336) at com.spotfire.server.lifecycle.SpotfireApplicationInitializer.initRootContext(SpotfireApplicationInitializer.java:176) ....... .......
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The transaction log for database 'spotfire_server_production' is full due to 'LOG_BACKUP'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) ....... ....... ... 15 more -------------------------------------------- Cause:
This ERROR indicates that there is a space issue on the Spotfire application database mentioned in the error message. The Spotfire Database failed to perform any transaction because of space issues.
Issue/Introduction
This article provides a resolution for the error, "The transaction log for database 'SPOTFIREDBNAME' is full due to 'LOG_BACKUP' " which you may encounter while starting the Spotfire Server service.
Environment
OS: All Supported Operating Systems
Database: All Supported SQL Database versions.
Resolution
Check with the Database Administrator for alternatives/possible solutions for responding to a full transaction log in order to free up space for Database transactions.
Note: A similar "The transaction log for database 'SPOTFIREDBNAME' is full due to 'LOG_BACKUP' " error can occur in multiple places while performing any library operation if there is a space issue on an SQL based Spotfire application database.