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
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.