SAP Knowledge Base Article - Preview

3617941 - Replication thread down with error -1000293, State 0, Severity 14 "Cannot insert or update Column id: set option 'identity_insert' to the specific table name..."

Symptom

Replication thread down with error:

E. 2025/05/23 09:27:43. ERROR #1028 DSI EXEC(122(1) DS.DB) - neric/dsi/dsiqmint.c(5172)
        Message from server: Message: -1000293, State 0, Severity 14 -- 'SQL Anywhere Error -1000293: Cannot insert or update Column id: set option 'identity_insert' to the specific table name containing the identity column to be modified.
-- (optlib/opt_xxx.cxx 4729) '.
H. 2025/05/23 09:27:43. THREAD FATAL ERROR #5049 DSI EXEC(122(1) <DataServer>.<DatabaseServer>) - neric/dsi/dsiqmint.c(5185)
        The DSI thread for database 'DS.DB' is being shutdown. DSI received data server error #-1000293 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 #2 of the failed transaction.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP IQ 16.1

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.