User's Manual

Chapter 12. Administering SQL Remote for Adaptive Server
Enterprise
Error reporting and handling
This section describes how errors are reported and handled by the Message
Agent.
Default error handling
The default action taken by the Message Agent when an error occurs is to
record the fact in its log output. The Message Agent sends log output to a
window or a log file recording its operation. By default, log output is sent to
the window only; the -o command-line option sends output to a log file as
well.
The Message Agent may print more information in the output log than in the
window. The Message Agent log includes the following:
♦ Listing of messages applied.
♦ Listing of failed SQL statements.
♦ Listing of other errors.
UPDATE conflicts are not
errors
UPDATE conflicts are not errors, and so are not reported in the Message
Agent output.
Implementing error handling procedures
SQL Remote allows you to carry out some other process in addition to
logging a message if an error occurs. The REPLICATION_ERROR database
option allows you to specify a stored procedure to be executed by the
Message Agent when an error occurs. By default no procedure is executed .
The procedure must have a single argument of type CHAR or VARCHAR.
The procedure is called with any error messages and with the SQL statement
that causes the error.
While the option allows you to track and monitor errors in replication, you
must still design them out of your setup: this option is not intended to
resolve such errors.
For example, the procedure could insert the errors into a table with the
current time and remote user ID, and this information can then replicate back
to the consolidated database. An application at the consolidated database can
create a report or send e-mail to an administrator when errors show up.
☞ For information on setting the REPLICATION_ERROR option, see
“SQL Remote options” on page 315.
271