SAP Knowledge Base Article - Preview

3615077 - Alter repdef runs into ERROR #11069 and RSSD DSI goes down - SAP SRS

Symptom

1. In PRS, there are multiple replication definitions for the same table.

2. In PDS, running multiple commands as below for the same replication definition to drop columns,  

begin tran lock table test1 in exclusive mode exec rs_send_repserver_cmd 'alter replication definition "test1_repdef" drop "col1"' commit tran

begin tran lock table test1 in exclusive mode exec rs_send_repserver_cmd 'alter replication definition "test1_repdef" drop "col2"' commit tran 

It causes RSSD DSI down as below,

E. xxxx/05/03 22:37:23. ERROR #11069 DSI EXEC(101(1) SRS1_RSSD.SRS2_RSSD) - generic/sts/stscol.c(2501)

    unique key violation.

E. xxxx/05/03 22:37:23. ERROR #11069 DSI EXEC(101(1) SRS1_RSSD.SRS2_RSSD) - generic/sts/stscol.c(2501)

    unique key violation.


Read more...

Environment

SAP Replication Server 16.0

Product

SAP Replication Server all versions

Keywords

CR830749, ERROR #11069 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error

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.