Cisco Cisco IP Contact Center Release 4.6.1 Troubleshooting Guide
Troubleshooting Guide for Cisco Unified Contact Center Management Portal Release 8.0(1)
13
3. Delete all data from TB_IMP_FCT_PARTITION with the
RESOURCE_INSTANCE_ID of the failed database. This should
cascade delete data from all the other state tables.
cascade delete data from all the other state tables.
4. All the data in the following tables must be duplicated using the
failed database RESOURCE_INSTANCE_ID. This essentially
matches the state tables with the actual data in the database fact
tables.
matches the state tables with the actual data in the database fact
tables.
•
TB_IMP_FCT_PARTITION
•
TB_IMP_FCT_PARTITION_TIDEMARK
•
TB_IMP_FCT_PARTITION_TIDEMARK_SLICE
5. Reset Replication.xml on the active importer.
6. Restart the Data Import component server service along with
Unified CCMP Replication Publisher / Subscriber services on both
servers.
servers.
The Data Import component server will start importing and
replicating data to the other side as normal.
replicating data to the other side as normal.
Recovery after No Disk Space Available
If there is no disk space for the importer, it will continue trying and failing
to import data until disk space is made available. However the importer
should always reset Unified CCMP database to a consistent state.
Sometimes the importer cannot back out changes it has made to the
database until disk space is made available. For example, disk space is
often required by the SQL Server transaction log before changes are
committed.
to import data until disk space is made available. However the importer
should always reset Unified CCMP database to a consistent state.
Sometimes the importer cannot back out changes it has made to the
database until disk space is made available. For example, disk space is
often required by the SQL Server transaction log before changes are
committed.
There are several places where running out of disk space can cause an
import to fail. For example when the importer reloads a dimension cache,
it saves it to a session file on disk. The same occurs when the importer is
processing downloads from the Admin Workstation. It is therefore difficult
to specify exactly where the importer will fail when there is no disk space
left.
import to fail. For example when the importer reloads a dimension cache,
it saves it to a session file on disk. The same occurs when the importer is
processing downloads from the Admin Workstation. It is therefore difficult
to specify exactly where the importer will fail when there is no disk space
left.
In all cases the importer should generate an exception (visible in the
importer trace) and stop the current import. Once disk space is made
available, the importer should reset the database to a consistent state and
start importing again.
importer trace) and stop the current import. Once disk space is made
available, the importer should reset the database to a consistent state and
start importing again.