Can't view reports in Voice Portal system

[chinq]

All reports can't generate normally. The log viewer shows the messages as below:
"QCDH_00008: Scheduled event completed with errors. View log category 'Call Data Handler' for more information."
Thanks for your support.

[zjiteshthakk]

PCDH_00008

Event name PCDH_00008
Event text The scheduled event completed with errors. View log category Call Data Handler for more information.
Associate alarm name QCDH_00008
Event level Information event.
Minor alarm is generated by default. You can change the severity for this alarm by logging on to Voice Portal Management System and using the Alarm Codes page.
Trigger component Voice Portal logging issues

Problem description

The CDH scheduler has completed the scheduled download request. However, it encountered problems when downloading or saving CDR or SDR records from at least one of the MPPs.


Proposed Solution

1. Review all the CDH events that occurred during the scheduled download time.
2. Identify all the error events. A CDH error indicates a communication problem between the MPP and the VPMS during the scheduled download time. The error might also indicate database exceptions when adding CDR or SDR records.

-----------------------------------------------------------------------------------------------------------------------

Another Possible cause could be that the vpapplog table could be missing.
If that indeed is the case, then you may try the following procedure:

Login to VP: (No need to stop any services) This will not affect any running services in Voice Portal. su - postgres
cd /var/lib/pgsql/SQLscripts
psql -a -f VPAppLog.sql VoicePortal --------------this script willrebuild the vpapplog table

1. su - postgres.
2. cd /var/lib/pgsql/SQLscripts.
3. psql -a -f VPAppLog.sql VoicePortal --------------this script willrebuild the vpapplog table.