SAP Knowledge Base Article - Preview

3697286 - One update sql is being executed twice in standby ASE caused 5185 error when dsi_keep_triggers is on in Standby ASE.

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

SAP Replication Server 15.7 ; SAP Replication Server 16.0

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.