These error messages, which are recorded in the Replication Server error log, are arranged numerically in ascending order.
Data server errors
Error 1028 is displayed in the Replication Server error log. An Adaptive Server error is reported in the text of error 1028.
E. 95/08/09 11:38:01. ERROR #1028 DSI(westernDS.westDB) - dsiqmint.c(3675) Message from server: Message: ..., State: ..., Severity: ...-- ‘...’.
Error 1028 occurs when a data server returns an error to Replication Server. Error 1028 is usually followed by several other errors. The most common error situations are described in these sections:
In some cases, the DSI thread shuts down. Adaptive Server errors caused the connection to be suspended if:
The Adaptive Server error is assigned the retry_stop or stop_replication error action.
You executed the suspendconnection command with the nowait clause.
If the DSI thread shuts down, you cannot simply resume the connection. Resuming the connection without fixing the problem sends the same transaction to the Adaptive Server and causes the same error.
In general, you must identify and fix the Adaptive Server problem that is causing the error. See “Correcting Adaptive Server error”. If you cannot correct the cause of the problem, as a last resort, you can resume the connection and skip the transaction. Skipping a transaction, however, causes inconsistencies between the primary and replicate databases, which you must manually fix in the replicate database. See “Skipping the transaction”. Also see the most common situations for error 1028 for solutions to their particular problems.
