Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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