SolarWinds Information Service V3 fails to start

10/18/2018 6:21 AM

11/8/2018 3:07 PM

The Solarwinds Information Service v3will not start up correctly. The Service will show as running but does not accept any new requests.
 

The following error appears in the Orion Information Service log:
2016-01-27 11:09:54,651 [4] INFO SolarWinds.Data.Providers.Orion.Containers.LimitationSnapshotService.LimitationSnapshotService - (null) Starting limitation snapshost service e92e7dd9-bee1-4803-91fe-779c89099c89 2016-01-27 11:09:54,856 [4] ERROR SolarWinds.Data.Providers.Orion.Containers.LimitationSnapshotService.DAL.LimitationSnapshotDAL - (null) Cannot purge orphaned Limitation Snapshots. System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'SolarWindsOrionNew' is full due to 'LOG_BACKUP'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at SolarWinds.Orion.Common.SqlHelper.ExecuteReader(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandBehavior behavior) at SolarWinds.Data.Providers.Orion.Containers.LimitationSnapshotService.DAL.LimitationSnapshotDAL.DeleteOrphanedSnapshots() ClientConnectionId:6f67de8f-8de5-465f-b5f1-887526e26e5e

 

Network Performance Monitor

The Transaction Log on the SQL Server is full (© 2019 Microsoft, available at https://docs.microsoft.com, obtained on January 15, 2019)

• Stop all Orion Services on all Polling Engines.
• Use DBCC to Shrink your Transaction Log (© 2019 Microsoft, available at https://docs.microsoft.com, obtained on January 15, 2019)

References 

SQL Server - MSDN

DBCC - MSDN

Transaction Log - MSDN

SQL Files - MSDN

(© 2019 Microsoft, available at https://docs.microsoft.com, obtained on January 15, 2019)

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.