Oracle Server Manager User's Guide

Contents Index Home Previous Next

The Errors Folder

When you click the Errors folder tab, the Errors folder opens and the Error object list and menu appear. The Error object list contains information about the transactions that encountered errors while executing at the local database. For more information about replication errors, see Oracle7 Server Distributed Systems, Volume II. The following figure illustrates the Error object list.

Figure 8 - 19. Error Object List

Error Object List

The columns of the Error object list are described below:

Trans ID Transaction identifier.
Error Number Oracle error code.
Error Message Message text.
Time Occurred Time error occurred.
Call Number Unique identifier of the call.
Source Database Database originating the transaction.
Destination Database Database link used to address the destination database.
Attention: Before resolving an error, you may need to disable replication. For more information, see Oracle7 Server Distributed Systems, Volume II.

Manually Re-executing Failed Transactions

When the error condition that stopped execution of a transaction has been resolved, execution of the transaction can be attempted again. To re-execute a transaction, select the transaction in the Error object list and choose Re-execute Transaction from the Error menu. The Re-execute Error alert box appears as shown in the following figure.

Figure 8 - 20. Re-execute Error Alert Box

The Re-execute Error alert box indicates the associated transaction and the database from which the transaction originated.

Dropping an Failed Transaction

To drop an error, select the associated transaction from the Error object list and choose Drop from the Error menu. The Drop Error alert box appears as shown in the following figure.

Figure 8 - 21. Drop Error Alert Box

The Drop Error alert box indicates the associated transaction and the database from which the transaction originated. Dropping the error drops the transaction and the calls and arguments associated with the transaction from the local database.

Show Detailed Information about Unresolved Errors

To display the calls and arguments of the failed transaction, select the transaction from the Error object list and choose Show Calls from the Error Menu. The Deferred Calls dialog box appears as shown in the following figure.

Figure 8 - 22. Deferred Calls Dialog Box

The columns of the Deferred Calls multi-column scrolling list are described below:

Schema Owner of the called procedure.
Package Package containing the called procedure.
Procedure Called procedure.
Arguments Number of procedure arguments.
To show the arguments of a call, select a deferred call from the Deferred Calls multi-column scrolling list. The arguments for the selected call appear in the Call Arguments list.

The columns of the Call Arguments multi-column scrolling list are described below:

Name Name of the argument.
Type Argument type. All arguments are valid Oracle7 datatypes.
Value Argument Value.

Purging the Error Queue

To drop the entire contents of the error queue, choose Purge from the Error menu. The Purge Errors alert box appears as shown in the following figure.

Figure 8 - 23. Purge Errors Alert Box

After the errors are dropped, all of the calls associated with the errors are dropped.

Warning: Once you purge the error queue, you cannot recover the errors.


Contents Index Home Previous Next