Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Orion module engine crashing with System.Data.SqlServerCe.SqlCeErrorCollection error

Orion module engine crashing with System.Data.SqlServerCe.SqlCeErrorCollection error

Updated October 29, 2018

Overview

This article describes the issue when you see the Module engine or Businesslayer crashing every few minutes. You can check this by going to C:\ProgramData\Solarwinds\Logs\Orion and look at the previous Businesslayerhost.log for the error below:

 

2015-12-16 10:24:21,691 [104] ERROR SolarWinds.BusinessLayerHost.BusinessLayerHostService - Unhandled exception caught by business layer host. System.Runtime.Serialization.SerializationException: Type 'System.Data.SqlServerCe.SqlCeErrorCollection' in Assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' is not marked as serializable.

 

The key word here is SqlServerCe.

Environment

All modules using Orion 2018.2 platform. and below

Cause 

The error is caused by corruption in the SQL Server Compact Edition databases used by the services.

Resolution

  1. Stop the Orion Services.
  2. Go to C:\ProgramData\Solarwinds\Installers.
  3. Run the installers for the JobEngine, JobEngine.v2, and CollectorInstaller to uninstall the services.
  4. Run the installers for SSCERuntime_x64-ENU and SSCERuntime_x86-ENU and choose repair on each.
  5. Once the repairs are done, run the installers to JobEngine, JobEngine.v2, and CollectorInstaller and reinstall the services.
  6. Restart the Orion Services and give it at least five minutes to come up completely. The Module engine should no longer be crashing.

 

If the steps above are ineffective, proceed as follows:

  1. Stop the Orion Services.
  2. Go to C:\ProgramData\Solarwinds\Installers.
  3. Run the installers for the JobEngine, JobEngine.v2, and CollectorInstaller and uninstall the services.
  4. Uninstall Microsoft SQL Server Compact 3.5 SP2 ENU, and x64 ENU from Programs and Features
  5. Download and install Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop from: Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop (© 2018 Microsoft Corporation, available at http://www.microsoft.com/, obtained on October 2018).
  6. Go to C:\ProgramData\Solarwinds\Installers.
  7. Run the installers for the JobEngine, JobEngine.v2, and CollectorInstaller and install the services.  
  8. Restart the Orion Services and give it at least five minutes to come up completely. The Module engine should no longer be crashing.

 

Note: In some environments, it may be necessary to run the installers for the JobEngine, JobEngine.v2, and CollectorInstaller from a command prompt that was run as administrator.  To change the directory use the following command:
cd C:\ProgramData\Solarwinds\Installers

 

 

Last modified

Tags

Classifications

Public