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 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
  • SAP Replication Server (SRS) 16.0

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

RepServer, CR799811, CR#99811, 799811 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.