Symptom
1.From RS error log, same update sql are executed twice in the standby ASE and DSI is down with 5185 error.
T. 2025/12/19 06:21:58. (138): Command sent to 'RDS.rdb':
T. 2025/12/19 06:21:58. (138): 'begin transaction '
T. 2025/12/19 06:21:58. (138): Command sent to 'RDS.rdb':
T. 2025/12/19 06:21:58. (138): 'update dbo.des_table set name1='case2' where id1=1 and name1='case' '
T. 2025/12/19 06:21:58. (138): Command sent to 'RDS.rdb':
T. 2025/12/19 06:21:58. (138): 'update dbo.des_table set name1='case2' where id1=1 and name1='case' '
H. 2025/12/19 06:21:58. THREAD FATAL ERROR #5189 DSI EXEC(104(1) RDS.rdb) - eneric/dsi/dsiutil.c(1006)
The DSI thread for the 'RDS.rdb' database is being shut down. DSI received Replication Server error #5185 which is mapped to STOP_REPLICATION or RETRY_STOP_REPLICATION. See the Replication Server log for more information.
W. 2025/12/19 06:21:58. WARNING #5185 DSI EXEC(104(1) RDS.rdb) - eneric/dsi/dsiexec.c(20842)
Row count mismatch for the command executed on 'RDS.rdb'. The command impacted 2 rows but it should impact 1 rows.
I. 2025/12/19 06:21:58. The error was caused by output command #2 of the failed transaction on table 'dbo.des_table'.
H. 2025/12/19 06:21:58. THREAD FATAL ERROR #5273 DSI EXEC(104(1) RDS.rdb) - neric/dsi/dsiqmint.c(5413)
To write the failed transaction into log, please execute 'sysadmin log_first_tran, RDS, rdb'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.
I. 2025/12/19 06:21:58. The DSI thread for database 'RDS.rdb' is shutdown.
2. dsi_keep_triggers is set to ON for Stanby ASE connection, 'RDS.rdb'.
Read more...
Environment
- SAP Replication Server (SRS) all versions.
- SAP Adaptive Server Enterprise (ASE) all versions.
Product
Keywords
KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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