2420324 - Error 195 identity_update is not a recognized SET option - SAP SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2420324 - Error 195 identity_update is not a recognized SET option - SAP SRS

Symptom

  • Replicate from MS SQL Server to MS SQL Server using SAP replication server.
  • When updating a table with an identity column, the DSI connection goes down with the following error:

E.  ERROR #1028 DSI EXEC(110(1) <data_server.database>) - neric\dsi\dsiqmint.c(5112)
Message from server:

Message: 30291, State 0, Severity 19 -- '[[ Message Iteration=1 | Data Source Name=<data_server.database> | SQLState=42000 | Native Error=195 |Message=[Microsoft][SQL Server Native Client 10.0][SQL Server] 'identity_update' is not a recognized SET option. [Message Iteration=2.

H.  THREAD FATAL ERROR #5049 DSI EXEC(110(1) <data_server.database>) - neric\dsi\dsiqmint.c(5125)
The DSI thread for database '<data_server.database>' is being shutdown. DSI received data server error #30291 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #2 of the failed transaction.


Read more...

Environment

  • SAP Replication Server Reterogeneous Edition (RSHE)

Product

SAP Replication Server 15.7 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; Sybase Replication Server 15.7, heterogeneous edition

Keywords

dist_cmd_direct_replicate, Message 195, identity_update, Native Error 195, CR 804005, 804005 , KBA , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.