SAP Knowledge Base Article - Preview

2156800 - ASE Msg 584 "Explicit value specified for identity field" when using MSA with SQLDML - SRS

Symptom

  • In a Multi-Site Availability (MSA) replication environment using sql statement replication (SQLDML)
  • The following transaction:

set identity_insert ID_test on
insert ID_test (a, b) select a, b from ID_test_tmp

   causes the DSI thread to go down with the error:

ERROR #1028 DSI EXEC(103(1) xxx.xxx) - neric/dsi/dsiqmint.c(4771)
        Message from server: Message: 584, State 1, Severity 16 -- 'Explicit value specified for identity field in table 'dbo.ID_test' when 'SET IDENTITY_INSERT' is OFF.'.
THREAD FATAL ERROR #5049 DSI EXEC(103(1) xxx.xxx) - neric/dsi/dsiqmint.c(4784)
        The DSI thread for database 'xxx.xxx' is being shutdown. DSI received data server error #584 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #0 mapped from input command #0 of the failed transaction.
The DSI thread for database 'nefarian2.ident_repro2' is shutdown.


Read more...

Environment

  • SAP Replication Server (SRS) 15.7
  • SAP Replication Server SRS) Real Time Loading (RTL) 15.7
  • SAP Replication Server (SRS) Heterogeneous Edition 15.7
  • SAP Replication Server Option (RSO) for IBM DB2 15.7
  • SAP Replication Server Option (RSO) for Oracle 15.7
  • SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7

Product

SAP Replication Server 15.7 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for IBM DB2 ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; SAP Sybase Replication Server 15.7, option for Oracle ; SAP Sybase Replication Server 15.7, real-time loading edition

Keywords

DML, identity, "SET IDENTITY_INSERT", 1028, 5049, MultiSite, SQL statement replication , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Bug Filed

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.