IBM Support

Control Center will not start after upgrade due to Database Collation Error

Troubleshooting


Problem

After upgrading to SCC v6.0.0.1, iFix06, on Windows Server 2008 R2, the startup failed. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_BIN" in the equal to operation.

Symptom

ERROR RecoverableDAO - The query was executed 60 times for 604 seconds.
However, the engine did not succeed in performing the database operation, because of the following.
Error :Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_BIN" in
the equal to operation.
24 Jan 2017 09:45:39,418 650103 [Thread-243] ERROR RecoverableDAO - Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_BIN" in the equal to operation.
Stack Trace:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and
"SQL_Latin1_General_CP850_BIN" in the equal to operation.
at com.microsoft.sqlserver.jdbc.SQLServerException.
makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult
(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.
doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.
SQLServerPreparedStatement$PrepStmtExecCmd.doExecute
(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand
(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand
(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement
(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery
(SQLServerPreparedStatement.java:285)
at com.sterlingcommerce.scc.agent.services.jdbc.dao.alert.
AlertJdbcDAO$2.executeQuery(AlertJdbcDAO.java:146)
at com.sterlingcommerce.scc.agent.services.jdbc.dao.RecoverableDAO.
executeQuery(RecoverableDAO.java:787)
at com.sterlingcommerce.scc.agent.services.jdbc.dao.alert.AlertJdbcDAO.
addUnknownMessages(AlertJdbcDAO.java:57)
at com.sterlingcommerce.scc.agent.services.node.AlertsUtil.run
(AlertsUtil.java:156)

[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0.0.1;6.0","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 December 2019

UID

swg21997839

Page Feedback