Cisco Cisco Unified Contact Center Enterprise 8.0(1) Troubleshooting Guide
Contents
Introduction
Prerequisites
Requirements
Components Used
Problem
Solution
Introduction
This document describes the steps to fix the issue of large tables not purging data for the Logger
in UCCE.
in UCCE.
Prerequisites
Requirements
Cisco recommends that you have knowledge of these topics:
UCCE
●
Structured Query Language (SQL)
●
icmdba tool
●
Components Used
This document is not restricted to specific software and hardware versions.
Problem
Logger B purges data when more than 80% capacity has been reached. The registry indicates that
only 14 days should be stored, but it stores more than that.
only 14 days should be stored, but it stores more than that.
The issue is caused by the large tables (Agent Event Detail, Call Type SG Interval, RCD, RCV and
TCD) that have a higher number of days retained although the registry is configured for 14 days.
TCD) that have a higher number of days retained although the registry is configured for 14 days.
You can see this from icmdba checking Space Used Summary....
This happens if the stored procedure used to purge the large tables has a conflict in it, in this case
it directs the procedure to use the database on the wrong Logger (LoggerA instead of LoggerB).
it directs the procedure to use the database on the wrong Logger (LoggerA instead of LoggerB).
Solution
Step 1. Change the Retain period for the affected tables on the registry, to ensure only the oldest
10 - 20 days are purged (to avoid purging too much data on one go), i.e.
HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems,Inc.\ICM\Customer_Instance\
10 - 20 days are purged (to avoid purging too much data on one go), i.e.
HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems,Inc.\ICM\Customer_Instance\