Cisco Cisco Unified Contact Center Management Portal 8.5 Troubleshooting Guide
26
Troubleshooting Guide for Cisco Unified Contact Center Management Portal Release 7.2(3)
On the failed server the following changes must be made:
1. The tide marks in TB_IMP_TIDEMARK will be incorrect once
the database has been restored on the failed side. So delete all rows
from the table which contains the failed server’s
RESOURCE_INSTANCE_ID. On the failed server call
ap_clu01_get_exony_db_resource_instance from SQL Server
Query Analyzer to get its RESOURCE_INSTANCE_ID.
from the table which contains the failed server’s
RESOURCE_INSTANCE_ID. On the failed server call
ap_clu01_get_exony_db_resource_instance from SQL Server
Query Analyzer to get its RESOURCE_INSTANCE_ID.
2. After deleting all the rows for the failed database server - duplicate
each remaining row in the TB_IMP_TIDEMARK table. Each
duplicated row must have its RESOURCE_INSTANCE_ID changed
to the failed server identifier. By doing this it ensures that both servers
have identical tide marks and so match the data in the fact tables and
dimensions.
duplicated row must have its RESOURCE_INSTANCE_ID changed
to the failed server identifier. By doing this it ensures that both servers
have identical tide marks and so match the data in the fact tables and
dimensions.
The following SQL can be used to update TB_IMP_TIDEMARK:
CREATE TABLE #TEMP (RESOURCE_INSTANCE_ID
UNIQUEIDENTIFIER, CATALOG VARCHAR (50))
UNIQUEIDENTIFIER, CATALOG VARCHAR (50))
INSERT #TEMP
EXECUTE ap_clu01_get_exony_db_resource_instance
EXECUTE ap_clu01_get_exony_db_resource_instance
DECLARE @v_RESOURCE_INSTANCE_ID UNIQUEIDENTIFIER
SELECT @v_RESOURCE_INSTANCE_ID =
RESOURCE_INSTANCE_ID FROM #TEMP
DELETE FROM TB_IMP_TIDEMARK
WHERE RESOURCE_INSTANCE_ID =
@v_RESOURCE_INSTANCE_ID
WHERE RESOURCE_INSTANCE_ID =
@v_RESOURCE_INSTANCE_ID