Event name

PCDH_00006

Event text

SQL exception occurred {0}

Associate alarm details

Name: QCDH_00006

SNMP Trap ID: 17902

Event level

Error event.

Major alarm is generated by default. You can change the severity of this alarm by logging in to Experience Portal Manager and using the Alarm Codes page.

Trigger component

Avaya Experience Portal logging issues

Problem description

{0} - Provides information about the exception.

The CDH scheduler encountered a problem when inserting CDR or SDR records to the Avaya Experience Portal database on the EPM.

Proposed Solution

Procedure

  1. During the scheduled download time, use the EPM Log Viewer to monitor the Reporting category log entries to determine if the problem is reoccurring.
  2. If the message contains a database specific error code, consult the documentation provided by your database vendor.
  3. To restore the reporting database:
    1. Shutdown Tomcat.
    2. Restart the database server.
    3. Restart Tomcat.
    4. If the problem persists, restore the reporting database from a backup.
  4. Export the Reporting category log entries by using the EPM Log Viewer.
  5. Contact Avaya Technical Support.