Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 1 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
19:23, 22 Jun 2016

Tags

Classifications

Public