Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| vendors:cisco:uc:icm:sql:ucce-to-pcce [2021/05/20 10:57] – [Summary] gerardorourke | vendors:cisco:uc:icm:sql:ucce-to-pcce [2021/09/03 10:13] (current) – [UCCE to PCCE Migration] gerardorourke | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== UCCE to PCCE Migration | + | ====== UCCE to PCCE Migration ====== |
| - | Note - Errors below taken from the ICM Tomcat Error logs. the GUI was not displaying the errors correctly for me (due to a Java error). | + | *Make sure Apache is working on all ICM servers |
| + | *MR PG needs to have all Peripherals configured on it and the Multimedia ones marked as Multimedia. | ||
| + | * Names, Peripheral Name and Routing Client Name all the same and as per below: | ||
| + | * {{: | ||
| + | |||
| + | |||
| + | Note - Errors below taken from the ICM Tomcat Error logs. the GUI was not displaying the errors correctly for me (due to a Java error). | ||
| ==== CVP ECC Variables ==== | ==== CVP ECC Variables ==== | ||
| === Error: ECC_FOR_CVP_COUNT. Min = 9, Max = 9, Actual = 5 === | === Error: ECC_FOR_CVP_COUNT. Min = 9, Max = 9, Actual = 5 === | ||
| You need to have all 9 ECC Variables configured (no need to enabled them all!). | You need to have all 9 ECC Variables configured (no need to enabled them all!). | ||
| + | |||
| + | ===== Validation SQL Queries ===== | ||
| <code sql> | <code sql> | ||
| select count(*) from Expanded_Call_Variable where | select count(*) from Expanded_Call_Variable where | ||
| Line 132: | Line 140: | ||
| *Step 3 Delete all ESG - should be very simple once above is done | *Step 3 Delete all ESG - should be very simple once above is done | ||
| + | ==== Scripts which reference an ESG ==== | ||
| + | |||
| + | <code sql> | ||
| + | SQL | ||
| + | All Scripts (including old scripts) which reference an Enterprise Skillgroup | ||
| + | |||
| + | SELECT | ||
| + | | ||
| + | ,ESGName = ESG.EnterpriseName | ||
| + | |||
| + | |||
| + | FROM [Ref_Script_Cross_Reference] SCR | ||
| + | LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID | ||
| + | LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID | ||
| + | LEFT JOIN Enterprise_Skill_Group ESG ON ESG.EnterpriseSkillGroupID = SCR.ForeignKey | ||
| + | |||
| + | WHERE SCR.TargetType = ' | ||
| + | |||
| + | GROUP BY MS.EnterpriseName, | ||
| + | ORDER BY MS.EnterpriseName, | ||
| + | </ | ||
| + | |||
| + | Get the list of Scripts from above SQL query - put into EXCEL and remove duplicates and use this List to create the next SQL query. | ||
| + | |||
| ==== SQL to show which scripts which have a GOTO Script node for a specific list of scripts (ESG Scripts) ==== | ==== SQL to show which scripts which have a GOTO Script node for a specific list of scripts (ESG Scripts) ==== | ||
| Line 158: | Line 190: | ||
| </ | </ | ||
| - | ==== Scripts which reference an ESG ==== | ||
| - | <code sql> | ||
| - | SQL | ||
| - | All Scripts (including old scripts) which reference an Enterprise Skillgroup | ||
| - | |||
| - | SELECT | ||
| - | | ||
| - | ,ESGName = ESG.EnterpriseName | ||
| - | |||
| - | |||
| - | FROM [Ref_Script_Cross_Reference] SCR | ||
| - | LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID | ||
| - | LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID | ||
| - | LEFT JOIN Enterprise_Skill_Group ESG ON ESG.EnterpriseSkillGroupID = SCR.ForeignKey | ||
| - | |||
| - | WHERE SCR.TargetType = ' | ||
| - | |||
| - | GROUP BY MS.EnterpriseName, | ||
| - | ORDER BY MS.EnterpriseName, | ||
| - | </ | ||