Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > When should Job Engine and/or Collector .sdf files be replaced?

When should Job Engine and/or Collector .sdf files be replaced?

Table of contents

Replacing Job Engine and/or Collector .sdf files is a commonly used step to address a number of potential issues with Orion installations, but it is not always required or recommended. SolarWinds Development has provided the following information to clarify when .sdf files should be replaced.

Job Engine

Job Engine v1 and Job Engine v2 are both currently provided with all Orion installations. You can find the .sdf files in the following locations:

  • %AllUsersProfile%\Application Data\Solarwinds\JobEngine\Data (Job Engine v1)
  • %AllUsersProfile%\Application Data\Solarwinds\JobEngine.v2\Data (Job Engine v2)

To determine if an .sdf file replacement is necessary, review the following log files:
Note: Version numbers may change as newer versions are released.

  • %AllUsersProfile%\Application Data\Solarwinds\JobEngine\Logs\SolarWinds.JobSchedulingService_v1_5.txt
  • %AllUsersProfile%\Application Data\Solarwinds\JobEngine.v2\Logs\SolarWinds.JobEngineService_v2_1.txt

The relevant error message will display as follows:

SolarWinds.JobEngine.ServiceProcess.StartCanceledException: Start is canceled --->
SolarWinds.JobEngine.Data.DatabaseCorruptedException: The job scheduler database file is corrupted
    at SolarWinds.JobEngine.Data.SqlCeHelper.Verify()
    at SolarWinds.JobEngine.Scheduling.SchedulerServiceApp.Start()
    --- End of inner exception stack trace ---
    at SolarWinds.JobEngine.Scheduling.SchedulerServiceApp.Start()
    at SolarWinds.JobEngine.ServiceProcess.SolarWindsService.ServiceStart()

If you see this error in either or both log files, the corresponding .sdf file is corrupt, and it must be replaced.

Notes:

  • If only one version is reporting this error, it is not necessary to replace the .sdf files for both versions.
  • After replacing the .sdf file(s), you should also restart the Orion Module Engine to ensure that jobs are rescheduled properly.
  • If you are replacing the Job Engine v2 .sdf file on an additional poller, you must be sure to replace the .sdf file on the main poller.
  • Some data is shared between these .sdf files. If you replace an .sdf file on the main poller, you are not required to replace the same .sdf file on any additional pollers.
If you run into a case where you see this error in the Job Engine, please collect diagnostics and let SolarWinds know. We need the information so we can determine why the .sdf file is being corrupted.

Collector

The Collector has two .sdf files, found in %AllUsersProfile%\Application Data\Solarwinds\Collector\Data\.

To determine if an .sdf file replacement is necessary, review the following log files:

  • %AllUsersProfile%\Application Data\Solarwinds\Collector\Logs\DataProcessorService.log
  • %AllUsersProfile%\Application Data\Solarwinds\Collector\Logs\ManagementAgentService.log
  • %AllUsersProfile%\Application Data\Solarwinds\Collector\Logs\PollingControllerService.log

If the Collector .sdf files have been corrupted, the following error will display:

FATAL SolarWinds.Collector.Services.CollectorService - Error starting service.System.Runtime.Serialization.SerializationException: The constructor to deserialize an object of type 'System.Data.SqlServerCe.SqlCeException' was not found. --->
System.Runtime.Serialization.SerializationException: The constructor to deserialize an object of type 'System.Data.SqlServerCe.SqlCeException' was not found.

 

If the Collector .sdf files has grown to much, the following error will display:

 

ERROR SolarWinds.Collector.PollingController.CollectorScheduler - Error adding remote job. Error getting valid response for message 'AddJob' from endpoint 'e6d3a523-7523-46aa-a0c2-77b405eef2bf'. Response status: ErrorProcessingRequest, Error: {"$type":"System.Data.SqlServerCe.SqlCeException, System.Data.SqlServerCe","ClassName":"System.Data.SqlServerCe.SqlCeException","Message":"There is not enough disk space left for the database.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":"   at System.Data.SqlServerCe.SqlCeResultSet.InternalInsert(Boolean fMoveTo, Object sender, SqlCeUpdatableRecord record)\r\n   at System.Data.SqlServerCe.SqlCeResultSet.Insert(SqlCeUpdatableRecord record)\r\n   at SolarWinds.JobEngine.Scheduling.ScheduledJobDAL.AddScheduledJob(ScheduledJobInfo jobInfo)\r\n   at SolarWinds.JobEngine.Scheduling.ScheduledJobStore.AddJob(Guid jobId, ScheduledJob scheduledJob)\r\n   at SolarWinds.JobEngine.Scheduling.JobScheduler.AddJob(ScheduledJob job)\r\n   at SolarWinds.JobEngine.AgentSupport.MessageHandler.AddJob(Message message)\r\n   at SolarWinds.JobEngine.AgentSupport.MessageHandler.MessageReceived(Object sender, Message message)","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nInternalInsert\nSystem.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91\nSystem.Data.SqlServerCe.SqlCeResultSet\nInt32 InternalInsert(Boolean, System.Object, System.Data.SqlServerCe.SqlCeUpdatableRecord)","HResult":-2146233087,"Source":"SQL Server Compact ADO.NET Data Provider","WatsonBuckets":null}

 

If you see this error, the .sdf file is corrupt, and it must be replaced.

Notes:

  • Unlike the Job Engine, Collector .sdf files are shared across services, so Development suggests replacing both .sdf files.
  • After replacing the .sdf file(s), you should also restart the Orion Module Engine to ensure that jobs are rescheduled properly.
If you run into a case where you see this in the Collector, please collect diagnostics and let SolarWinds know. As with the Job Engine, we need the information so we can determine why the .sdf file is being corrupted.

This article applies to all versions of all currently supported Orion products
Last modified

Tags

Classifications

Public