Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Enterprise Operations Console (EOC) > EOC - Knowledgebase Articles > 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: 920 Votes: 0 Revisions: 11

Overview

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)

Environment

All EOC versions

Resolution

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

Last modified

Tags

Classifications

Public