Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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: 863 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