Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Unified Customer Voice Portal 10.0(1)
  5. Troubleshooting Guide

Cisco Cisco Unified Customer Voice Portal 10.0(1) Troubleshooting Guide

Download
Page of 2
Contents
Introduction
Prerequisites
Requirements
Components Used
Problem: CVP Reporting Server Database NightlyPurge Failure
Solution 
Introduction
This document describes the common issues seen with NightlyPurge process in Customer Voice
Portal (CVP) Reporting server.
Prerequisites
Requirements
Cisco recommends that you have knowledge of these topics
CVP 
●
Windows 2008  Server 
●
Components Used
The information in this document is based on the CVP reporting server 8.0 and above. 
The information in this document was created from the devices in a specific lab environment. All of
the devices used in this document started with a cleared (default) configuration. If your network is
live, make sure that you understand the potential impact of any command.
Problem: CVP Reporting Server Database NightlyPurge
Failure
In CVP reporting server, intermittently the NightlyPurge process can fail with this error,
 "Failed running the stored procedure sp_frag_mgt - 310" 
10.16.0.15: Jan 14 2014 00:00:03.167 -0500:%CVP_8_5_RPT-6-REPORTING_DB_INFO_MSG:
ackPurgeRunning() sending message: start_ack[id:4013]
10.16.0.15: Jan 14 2014 00:00:03.167 -0500:%CVP_8_5_RPT-6-REPORTING_DB_INFO_MSG: Received
acknowledgement from Reporting subsystem. Message: start_ack [id:4013]
10.16.0.15: Jan 14 2014 00:00:03.167 -0500:%CVP_8_5_RPT-1-REPORTING_DB_STARTING_PURGE: Starting
Reporting (Database: cvp_data)
database purge. Any existing reporting connections will be disconnected. [id:4017]
10.16.0.15: Jan 14 2014 00:00:03.683 -0500: %CVP_8_5_RPT-3-REPORTING_DB_ERROR_MSG: (Database:
cvp_data) runDBPurge -- Failed running the stored procedure sp_frag_mgt: -310
10.16.0.15: Jan 14 2014 00:00:03.683 -0500: %CVP_8_5_RPT-1-REPORTING_DB_PURGE_FAILED:The
Reporting (Database: cvp_data) database purge operation failed [Duration: 0.52