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?
