General Data Server Error

Symptom

Error 1028 appears in the SAP Replication Server error log, but reports an SAP Adaptive Server Enterprise (SAP ASE) 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. SAP ASE errors suspend the connection if:

The SAP ASE 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 SAP ASE and causes the same error.

Solution

Identify and fix the SAP ASE 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.