2156800 - ASE Msg 584 "Explicit value specified for identity field" when using MSA with SQLDML - SRS | SAP Knowledge Base Article

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) nefarian2.ident_repro2) - 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) nefarian2.ident_repro2) - neric/dsi/dsiqmint.c(4784)
        The DSI thread for database 'nefarian2.ident_repro2' 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 , 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-ME , Replication Server Messaging Edition (RSME) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Bug Filed

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.