SAP Knowledge Base Article - Preview

2328558 - create replication definition Msg 15201:There is already one identity column in the primary table column list - SRS

Symptom

  • There is a replication definition on a table for warm standby to a use primary key. The table has an IDENTITY column which is not included on the column list or primary key list of  the replication definition with "send standby all columns".
  • The first replication definition has been working fine.
  • Another replication definition on the table is needed for replicating a subset of its table columns to the third database. Attempting to create the second replication definition which includes the IDENTITY column causes Msg 15201:
    Msg 15201, Level 12, State 0:
    Server 'RS203':
    There is already one identity column in the primary table column list.


Read more...

Environment

SAP Replication Server All Versions

Product

SAP Replication Server all versions

Keywords

repdef, 2nd repdef, replication definition, identity column, primary key , 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.