SAP Knowledge Base Article - Preview

3524245 - Duplicate key problem on insert when ‘set autocorrection on’ with direct load

Symptom

Problem occurs only if all together:
- auto-correction is on for replication definition 
- function string (insert) is configured
- subscription with direct_load

In such case doubled insert statements is reported as 2601 "Attempt to insert duplicate key row ..."

SRS errorlog:
E. 2024/09/06 11:09:20. ERROR #1028 MatApply( ) - eneric/dsi/dsiexec.c(689)
        Message from server: Message: 2601, State 1, Severity 16 -- 'Attempt to insert duplicate key row in object 'testtable' with unique index 'IDX0'
I. 2024/09/06 11:09:20. Message from server: Message: 3621, State 0, Severity 10 -- 'Command has been aborted.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)

Product

SAP Replication Server 16.0

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.