DB001

Alarm level

Major.

Description

An attempt to write a traffic record into the specific database table has failed, either during call processing or when processing a call data maintenance job. Depending on the source of the error, different types of errors result:

• If the source is Call Data Handler (CDH), the traffic record is not recorded in the database.
• If the source is CCA_Summary, the Call Classification (CCA) data report for the date the error was logged will not be correct.
• If the source is CDH_Summary, the nonCCA traffic data reports for the date the error was logged will not be correct.

There is no impact on call processing.

Repair procedure

To fix the problem:

• If the reason field of the error message is ORA00942:table or view does not exist, then recreate the system traffic tables.
• If the reason field of the error message is ORA1000: Maximum open cursor exceeded or Can't connect cursor to ORACLE, reduce the number of database references in the voice response application.

  This may be done by reducing the number of voice response applications involving database access that run on the IR system simultaneously.

• If the reason field of the error message is anything else, take these actions:
  1. Stop the voice system.
  2. Stop the database system.
  3. Start the database system.
  4. If the database system fails to start because of database file corruption, restore the database from backup files.
  5. Start the voice system.
  6. If the problem persists, recreate the system traffic tables.

� 2003 Avaya Inc. All Rights Reserved.