SAP Knowledge Base Article - Preview

2721403 - DSI down caused by 'quoted_identifer' in SQL statement replication - SAP SRS

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“

Enable 'SQL statement replication' for Warmstandby replication, create table with 'quoted_identifier' on at primary database, then set 'quoted_identifier' to off,  run some delete statement like below, turn on dsi buffer dump trace at replication server, we can see there are quotes added to the column which will cause row count mismatch at the target server and thread will go down due to this.

On replication server:

1> trace 'on', dsi, dsi_buf_dump
2> go

On primary database:

1> delete from test where A_TEST_DATE < (dateadd(day,-2, getdate()))
2> go
(2 rows affected)

Replication server log:

T.  'begin transaction  [0a] delete dbo.test where  ("A_TEST_DATE" < ('Nov 15 2018 10:31:41:760PM' ) ) '
H. THREAD FATAL ERROR #5189 DSI EXEC(105(1) PDS.SDB) - /dsiutil.c(819)
 The DSI thread for the 'PDS.SDB' database is being shut down. DSI received Replication Server error #5186 which is mapped to STOP_REPLICATION or RETRY_STOP_REPLICATION. See the Replication Server log for more information.
T.  Last command(s) to 'PDS.SDB':
T. 'begin transaction  [0a] delete dbo.test where  ("A_TEST_DATE" < ('Nov 15 2018 10:31:41:760PM' ) ) '
W. WARNING #5186 DSI EXEC(105(1) PDS.SDB) - /dsiexec.c(14276)
 Row count mismatch for the SQL Statement Replication command executed on 'PDS.SDB'. The command impacted 3 rows but it should impact 2 rows.
I. The error was caused by output command #2 of the failed transaction on table 'dbo.test'.
I. The DSI thread for database 'PDS.SDB' is shutdown.


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0
  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

quoted_identifier, SQL statement replication, Warmstandby, CR817734, RepServer , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.