Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Enterprise Operations Console (EOC) > Database collation must be case insensitive for EOC

Database collation must be case insensitive for EOC

Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 6 Votes: 0 Revisions: 11


This KB is to notify users of EOC that the MS SQL Server collation must be set to case insensitive for the EOC database. Case sensitive is not supported. If your collation is set to case sensitive you may see an error similar to the following when bringing up the EOC website.

ERROR SolarWinds.EOC.PollingService.JobSchedulerEventsService - Error handing OnJobFinished.
System.Data.SqlClient.SqlException: Must declare the scalar variable "@orionid".
Must declare the scalar variable "@orionid".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SolarWinds.Data.SQL.SqlHelper.ExecuteNonQuery(SqlCommand command, SqlConnection connection, SqlTransaction transaction)
at SolarWinds.Data.SQL.SqlHelper.ExecuteNonQuery(SqlCommand command)
at SolarWinds.EOC.BusinessLayer.DAL.ModulePollLogDAL.UpdatePolled(Guid jobID, Int32 orionID, String module, DateTime polled, ModulePollLogStatus status, String entityDetail, String statistics, String resultsDescription)
at SolarWinds.EOC.PollingService.JobHandlers.OrionPollJobResultHandler.Preprocess(PreprocessedFinishedJobInfo preprocessedFinishedJobInfo)
at SolarWinds.EOC.PollingService.JobsProcessor.PreprocessJobInfo(FinishedJobInfo finishedJobInfo)
at SolarWinds.EOC.PollingService.ResultsProcessor.EnqueJobResults(FinishedJobInfo[] finishedJobsInfo)
at SolarWinds.EOC.PollingService.JobSchedulerEventsService.OnJobFinished(FinishedJobInfo[] jobFinishedInfo)


All EOC versions


Ask your database administrator to set the database to "case insensitive" for the EOC database.

Last modified
19:23, 22 Jun 2016