02-16-2018 04:26 AM - edited 03-14-2019 05:57 PM
Hello,
I am running an upgrade from UCCE 9.0(3) to 11.6.
For migration HDS and Logger databases from version 9 to 11 with EDMT (via version 10.5) I tried to use advice from https://supportforums.cisco.com/t5/contact-center/ucce-v9-to-v11-upgrade/td-p/3014587
I installed a temporary server with MS Windows 2008 R2 and MS SQL 2008 R2 and restored a backup for HDS and Logger databases from our current version 9.0. When I try to start migration with EDMT_1051 (using common upgrade migration type), I get an error: "Database connection to 10.XX.XX.113:1433 FAILED".
---
Status:
▪ Checking the connection to the database mmk_sideB on 10.XX.XX.113:1433 ...
▪ Verifying the SQL Server collation ...
▪ SQL Server collation is not set properly for Cisco Unified ICM/CCE/CCH Found: Cyrillic_General_CI_AS
▪ Verifying the SQL Server version ...
▪ SQL Server version (SQL Server 2008 R2 10.50.4000.0) OK
▪ Verifying SQL Server Authentication Mode...
▪ SQL Server Authentication Mode is (Mixed) Mode OK
▪ Verifying Cisco Unified ICM/CCE/CCH Schema version ...
▪ Cisco Unified ICM/CCE/CCH Schema version (9,0) OK
▪ No Duplicate User Group Names Detected.
---
In MS SQL Profiler at the same time, I have following messages:
---
- network protocol: TCP/IP
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647
EXECUTE sp_server_info 18
EXECUTE xp_msver 'ProductVersion'
EXEC master.sys.xp_loginconfig 'login mode'
-- network protocol: TCP/IP
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647
SELECT Major FROM Version
select UPPER(UserGroupName) As 'UserGroupName' from User_Group group by UPPER(UserGroupName) having count(*) > 1
select UPPER(UserName) As 'UserName', UPPER(UserGroupName) As 'UserGroupName' from User_Group_Member group by UPPER(UserName), UPPER(UserGroupName) having count(*) > 1
---
What seems to be the problem?
Solved! Go to Solution.
02-27-2018 02:25 AM - edited 02-27-2018 02:30 AM
The problem was with a collation.
MS SQL Server collation was set to "Cyrillic_General_CI_AS" and it should be set to Cyrillic_General_BIN.
After reinstalling MS SQL Server with a proper collation, EDMT finished migration without any further errors.
02-27-2018 02:25 AM - edited 02-27-2018 02:30 AM
The problem was with a collation.
MS SQL Server collation was set to "Cyrillic_General_CI_AS" and it should be set to Cyrillic_General_BIN.
After reinstalling MS SQL Server with a proper collation, EDMT finished migration without any further errors.
02-28-2018 09:46 PM
I like your style.
You asked a question and later posted a followup and then accepted your post as the correct answer and got some points.
BINARY sort order indeed. Carry on.
Regards,
Geoff
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide