Cisco Cisco Unified Customer Voice Portal 10.0(1) Guía Para Resolver Problemas

Contributed by Taylan Kucuk and Ramiro Amaya, Cisco TAC
Engineers.

Sep 30, 2013

Introduction
Database Tables
     Summary and Aggregate Tables
Differences Between CVP 8.x and 9.0 Reporting Database
Reporting Server Overload
Troubleshooting
     Failure and Restoration − Reporting Server Partial
        Reporting Server Failure
        Database Connection Failure
        Unfinished Calls
        Recovery Mode
     Trace Level and Log Files
     Aggregator Debugs and Logs
     Database Space Issues

This document gives an overview of the Cisco Unified Customer Voice Portal (CVP) reporting server and
offers troubleshooting steps.

The reporting service receives reporting data from the Cisco Unified IP Interactive Voice Response
(IVR) service, the Session Initiation Protocol (SIP) service (if used), and the Cisco Unified CVP
Voice XML (VXML) server. The service then transforms and writes the data to the Informix
reporting database, which serves as historical reporting in a call center environment.

• 

The reporting service then parses those messages, converts them into batches of applicable Structured
Query Language (SQL) statements, and executes them into an SQL database via the Java Database
Connectivity (JDBC) API.

• 

CVP tables are categorized as:

Call tables

• 

VXML tables

• 

Summary / Aggregate tables

• 

Lookup and Reference tables

• 

Courtesy CallBack tables

•