Symptom
- Replication becomes non-repsonsive. DSI is stalled.
- There are no messages that there is an issue with the Replication Agent in the ASE primary. The last message was a deadlock information:
00:0073:00000:00712:20XX/02/12 02:45:15.11 server Deadlock Id 10 detected
Deadlock Id 10: Process (Familyid 0, Spid 712) was chosen as the victim.
Victim process host = `user3205', user = `db_maint' program name = `RepServer' host processes = `19727'.
End of deadlock information. -
At the same time the RepServer received the same information:
W. 20XX/02/12 02:45:15. WARNING #5091 DSI EXEC(143(1) myserver.mydb) - neric/dsi/dsiqmint.c(5377)
A transaction for database 'myserver.mydb' failed. It will be retried 5 times. The data server error received (#1205) is mapped to RETRY_LOG or RETRY_STOP. - Deadlocks happen quite often in this environment and the above messages are normal- but in this unique case the replication stopped at precisely at 02:45.
- Why?
Read more...
Environment
SAP Replication Server 16.0 SP03
Product
SAP Replication Server 15.7
Keywords
KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview