Troubleshooting procedure to general 1028 errors.
E. 2005/06/12 15:25:44. ERROR #1028 DSI EXEC(107(2) westernDS.westDB) - dsiqmint.c(3027) Message from server: Message: ..., State ..., Severity... -- '...'.
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.
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.