SAP Knowledge Base Article - Preview

2334080 - SQLDML replication DSI down with server message 2601 Attempt to insert duplicate key - SRS

Symptom

  • SQLDML replication reports error in SAP Replication Server (SRS) log:

    E. 2016/06/20 12:32:48. ERROR #1028 DSI EXEC(103(1) <ds_name>.<db_name>) - neric/dsi/dsiqmint.c(4959)
            Message from server: Message: 2601, State 2, Severity 16 -- 'Attempt to insert duplicate key row in object '<table_name>' with unique index '<table_index>'
  • SQLDML replication that caused the error was generated from sql inside a stored procedure in the primary database.
  • Dumping the DSI queue using sysadmin dump_queue shows the offending insert statement in bold:

    Begin Transaction Origin User=sa Tran Name=_user_transaction
    ENTRY ver=1100 len=232 orig=102 lorig=0 oqid=000000000000804c00004f7c000100004f76001f0000a62b00cec2280000000000000001 lqid=1:11:0 st=4 tr= '0000000000007f' d '001f' ase16trade_link '000000' f '00000000' comlen=101 begin transaction
    ENTRY ver=1100 len=340 orig=102 lorig=0 oqid=000000000000804c00004f7c000100004f76001f0000a62b00cec2280000000000000002 lqid=1:11:1 st=1075841024 tr= '0000000000007f' d '001f' ase16trade_link '000000' f '00000000' comlen=209 exec rs_sqldml @rs_operator='I', @rs_object='t2', @rs_owner='dbo', @rs_status=58, @rs_set=NULL , @rs_where=NULL , @rs_select='''20160223'' , T2.id , T2.f1 FROM dbo.t2 T2', @rs_from=NULL , @rs_insert_column='(rq, id, f1)', @rs_rowcount=100
    ENTRY ver=1100 len=292 orig=102 lorig=0 oqid=000000000000804c00004f7c000100004f76001f0000a62b00cec2280000000000000003 lqid=1:11:2 st=-1071640576 tr= '0000000000007f' d '001f' ase16trade_link '000000' f '00000000' comlen=158 insert into dbo.t2 (rq, id, f1) values ('20160223', 100, 'aaa')
    ENTRY ver=1100 len=196 orig=102 lorig=0 oqid=000000000000804c00004f7c000100004f76001f0000a62b00cec2280000000000000004 lqid=1:11:3 st=1 tr= '0000000000007f' d '001f' ase16trade_link '000000' f '00000000' comlen=63 commit transaction

 


Read more...

Environment

  • SAP Replication Server (SRS) 15.7.1 and later
  • All Supported Platforms

Product

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

Keywords

Rep Server, RepServer, repagent , 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) , 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.