LTM message types

SQL Server

Commonly identified by error numbers 9100 through 9199. The LTM can also obtain SQL Server errors outside this range.

Error numbers 9100 through 9199 are usually related to scanning the log and are not recorded in the SQL Server log because they are not considered severe to the SQL Server. They are only sent to the client. Look at the LTM error log for errors or conditions that occur during the log scan. The LTM logs the errors and performs some action based on the error. For a list of warning errors in this range, see Table B-2. It describes the kinds of errors you can expect to find in the LTM error log. For specific errors and how to resolve them, see the Replication Server Troubleshooting Guide for Replication Server 11.0.x.

Replication Server

These include Replication Server normalization errors (numbers 32000 through 32999), rebuild or restart errors (numbers 14034 through 14036, and 14069), Open Server errors, and ct_lib and cs_lib errors from libraries the LTM uses.

If the LTM is in recovery mode and the error number is 14048, the LTM rebuilds the messages from the SQL Server log.

The LTM treats normalization errors as recoverable errors. The LTM logs the error and continues processing. For Open Server and library errors, responses to errors are based on the severity of the error and are handled in a manner similar to the way Replication Server handles library errors. Replication Server shuts down the LTM if the error is fatal.

Normalization errors result from transient inconsistencies in the setup of replicated objects. For example, if a table has been marked replicated with the sp_setreptable system procedure, but no replication definitions have yet been created for the table, the LTM will retrieve log records for an object that is not yet known to the Replication Server.

LTM

General LTM errors include running out of memory and other software errors.

If the LTM encounters other errors sending the distribute commands (SQL-like statements), it turns off the batch_ltl_cmds configuration option and sends the distribute commands one at a time. If the skip_ltl_cmd_err configuration option is “on,” the LTM skips the command. Otherwise, the LTM shuts down. See “ltm” in Chapter 7, “Programs,” of the Replication Server Reference Manual for details on the configuration settings.