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 for Me (Login required).

Search for additional results

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