Data Server Error Handling

Replication Server allows user-definable error processing for data server errors. Assign appropriate error class to a specified connection and customize the assigned error class. The error actions should match the errors returned by the data server.

• RCL Commands and System Procedures for Error Processing
  There are several RCL commands and Adaptive Server system procedures that manage errors and error classes.
• Default Error Classes
  Replication Server provides rs_sqlserver_error_class as the default Adaptive Server error class, rs_repserver_error_class as the default Replication Server error class, and default error classes for non-ASE databases. You cannot modify these default error classes.
• Native Error Codes for Non-ASE Databases
  When Replication Server establishes a connection to a non-ASE replicate server, Replication Server verifies whether the option to return native error codes from the non-ASE replicate server is enabled for the connection.
• Create an Error Class
  Use create error class to create your own error classes.
• Alter Error Classes
  alter error class copies error actions from a template error class to the error class you want to alter and overwrites error actions which have the same error code.
• Initialize a New Error Class
  After you have create a new error class, you can initialize it with error actions from an error class such as the system-provided rs_sqlserver_error_class.
• Drop an Error Class
  The drop error class command drops an error class and all actions associated with it.
• Change the Primary Replication Server for an Error Class
  Use the move primary command to change the primary site for an error class.
• Display Error Class Information
  Use the rs_helpclass stored procedure to display the names of existing error classes and function-string classes in their primary Replication Servers and in the replication system.
• Assign Actions to Data Server Errors
  Use the assign action command to specify the action to take for errors that a data server can return to Replication Server.
• Display Assigned Actions for Error Numbers
  Use the rs_helperror stored procedure to display the action assigned for an error number.
• Row Count Validation
  Replication Server enables row count validation by default and automatically displays error messages and performs default error actions in reaction to different row count validation errors such as row count mismatch. You can configure the Replication Server error class to enable different error actions.