General Data Server Error

Troubleshooting procedure to general 1028 errors.

Symptom

Error 1028 appears in the Replication Server error log, but reports an Adaptive Server error:

E. 2005/06/12 15:25:44. ERROR #1028 DSI EXEC(107(2)
westernDS.westDB) - dsiqmint.c(3027) Message from
server: Message: ..., State ..., Severity... -- '...'.

Explanation

In some cases, the Data Server Interface (DSI) thread shuts down. Adaptive Server errors suspend the connection if:

The Adaptive Server error is assigned the retry_stop or stop_replication error action.
You executed the suspend connection 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.

Solution

Identify and fix the Adaptive Server problem that is causing the error. If you cannot correct the cause of the problem, you can, once you have tried all other solutions, resume the connection and skip the transaction. You can then manually apply the skipped transaction to the replicate table to resynchronize the primary and replicate tables. Skipping a transaction, however, causes inconsistencies between the primary and replicate databases, which you must manually fix in the replicate database.