Avaya Logo

Previous Topic

Next Topic

Book Contents

Book Index

DB002

Alarm level

Critical.

Description

An attempt to write a database record to an application table has failed during call processing. The record will be lost. Functions of the voice response application may be severely impaired.

Repair procedure

The steps that follow are suggestions. For assistance, contact your database administrator or database vendor.

To restore the application table:

  1. Take action based on the reason field of the error message, as shown in the table that follows.

    2. Reason Field

    Actions

    ORA1031 Insufficient privileges

    Give the user sti the necessary permissions:

    • Log in to SQL*PLUS as the original table owner.
    • Enter grant all on table_name to sti

    Note:
    The original owner must already have the proper permissions for the table.

    ORA00942:table or view does not exist

     

    Can't find select descriptor for table <table name>

    Check the voice response application and make sure that it refers to the correct table name. Make sure the table is read before an attempt is made to modify it. If the application refers to a wrong table, change the application. If the application is correct, restore the application table from the backup. If no backup is available, recreate the application table.

    ORA1000: Maximum open cursor exceeded

     

    Can't connect cursor to ORACLE

    Increase the cursor limit.

    You may also ask the application developer to reduce the number of references to the database, which is done by reducing the number of applications involving database access that run simultaneously on the system.

    Any other reason field

    Take these actions:

    • Stop the voice system.
    • Stop the database system.
    • Start the database system.
    • If the database system fails to start because of database file corruption, restore the database from backup files.
    • Start the voice system.

  2. If the database system started successfully but the problem persists, do the following:
    1. Stop the voice system.
    2. Drop the database.
    3. Restore the application table from a backup file.

Note:
If the table resides on a remote machine, restore the table to the remote machine.

� 2002 Avaya Inc. All Rights Reserved.