Cisco Cisco Unified Contact Center Management Portal 8.5 Troubleshooting Guide
26
Troubleshooting Guide for Cisco Unified Contact Center Management Portal Release 7.1(3)
1. On the active importer open SQL Server Query Analyzer and connect
to the Unified Contact Center Management Portal database. Run the
following query and paste the results into a text file. You will need
these results to complete step five.
following query and paste the results into a text file. You will need
these results to complete step five.
SELECT GROUP_ID FROM TB_CLU_GROUP WHERE SERVER_ID IS
NOT NULL
NOT NULL
The results should look something like:
C617D006-8A1B-44F2-BB1B-592BA9FA3958
98DC97B7-E519-41AF-893C-580D94ACEE4F
17C25CA8-E257-4929-ABD8-1AB443534102
F648492C-9AC1-4B89-98AD-9F5FBF20CC35
D562A378-8EBE-4A41-9A34-E8B0F126CBA5
2. Then run the following SQL query:
UPDATE TB_CLU_GROUP SET SERVER_ID = NULL
3. Before taking the Data Import component server down, wait for
the current import cycle to complete and replication to complete
synchronization. You need to wait until there are no folders in the
\IMPORTER\ToReplicate folder on the publisher and
\IMPORTER\Replicated on the subscriber. This indicates that
the importer has finished its current cycle and replicated the facts
on to the other side. Note that this may take a while during busy
periods.
synchronization. You need to wait until there are no folders in the
\IMPORTER\ToReplicate folder on the publisher and
\IMPORTER\Replicated on the subscriber. This indicates that
the importer has finished its current cycle and replicated the facts
on to the other side. Note that this may take a while during busy
periods.
At this stage the current database server is no longer the active
importer. The Data Import Server continues to run after this update
and completes the current import cycle but it will not begin a new
import cycle.
importer. The Data Import Server continues to run after this update
and completes the current import cycle but it will not begin a new
import cycle.