CVP Reporting Server DB Purge Schedule When OAMP is Unavailable

Introduction

This document describes the procedure to modify the Unified Cisco Voice Portal (CVP) database (db) purge schedule when the Operations Console (OAMP) is unavailable.

Contributed by Tian Lei Xia and Pavan Davé, Cisco TAC Engineers.

Requirements

 Cisco recommends you have the knowledge of these topics

• Cisco Unified CVP

Preferred Method when OAMP is Available

Step 1. Select Device Management > CVP Reporting Server.

Step 2. Select a Reporting Server.

Step 3. At the Edit Reporting Server Configuration window, select the Database Administration menu in the toolbar, then select Data Delete.

Step 4. On the Reporting Server - Data Delete page, change the data retention time for each category of data.

Step 5. Select the hours and minutes to run the purge each day.  This defines the time for the primary (Nightly) purge and sets the mid-day purge to run 12 hours later.

Step 6. Select Save & Deploy.

Change DB Purge Without OAMP

The CVP Reporting Server creates a Windows batch file cvppurge.bat that runs a Java backend code to start the db purge process. This file is located in C:\Cisco\CVP\bin.

This batch file is scheduled to run through the Windows Scheduler on each individual CVP Reporting Server. The Reporting Server is given two Windows Scheduler tasks, CVPDBMidDayPurge and CVPDBNightlyPurge. Each task corresponds to the mid-day Purge and Nightly Purge activities respectively mentioned in the Step 5 of the normal db schedule steps.

MidDayPurge and NightlyPurge use the same cvppurge.bat file however, different parameters feed into the batch file for different purge activities.

The db purge time can be changed through Windows Scheduler Tasks on each invidual CVP Reporting Server.