Team,
we are upgrading CA Service Cataog to 17.1 and when i ran the installer, it failed at MDB installation.
Below is the error from mdb_install.log. Please suggest how can this be resolved.
09-07,02:44:43 INFO - CREATE procedure [dbo].[usm_sp_system_change_details_multi_param]09-07,02:44:43 INFO - CREATE procedure [dbo].[usm_sp_system_change_details_multi_param]09-07,02:44:43 INFO - @idlist varchar(8000)09-07,02:44:43 INFO - as09-07,02:44:43 INFO - begin09-07,02:44:43 INFO - select id, name, data_type, new_value as old_value, new_value, multi_value from usm_system_change_detail(NOLOCK) 09-07,02:44:43 INFO - where id in (SELECT splitdata FROM dbo.fnSplitString(@idlist,''))09-07,02:44:43 INFO - endUpdate sql failed:CREATE procedure [dbo].[usm_sp_system_change_details_multi_param]@idlist varchar(8000)asbeginselect id, name, data_type, new_value as old_value, new_value, multi_value from usm_system_change_detail(NOLOCK) where id in (SELECT splitdata FROM dbo.fnSplitString(@idlist,''))end09-07,02:44:43 DEBUG - Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.09-07,02:44:43 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.09-07,02:44:43 INFO - MDBTools_0305E - Error processing procedure 'usm_sp_system_change_details_multi_param.xml'; details follow:09-07,02:44:43 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751) at com.ca.mdbtools.DriverApp.updateDB(DriverApp.java:2697) at com.ca.mdbtools.DriverApp.apply(DriverApp.java:2256) at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:1085) at com.ca.mdbtools.Utilities.run(Utilities.java:1678) at com.ca.mdbtools.Utilities.main(Utilities.java:1042)
Thanks,
Rajasheker Chittanur