SAP Knowledge Base Article - Preview

2214331 - ERROR #32049 "The replication status of column...in the primary database is 'do_not_replicate'. Use 'sp_setrepcol' to change it..." - SRS

Symptom

  • A RepAgent thread fails to start with the following error in the SAP Replication Server (SRS) and primary Adaptive Server Enterprise (ASE) server logs:
      
    SRS log:

    ERROR #32049 REP AGENT(NCPWMLP5.frdb) - /nrm/nrm.c(2616)
    The replication status of column 'nontimestamp_compare_CFR'.'compare_line_value' in the primary database is 'do_not_replicate'.  Use 'sp_setrepcol' to change it, and consider using rs_subcmp to repair missing or out-of-date data at the replicate database.
      
     
    ASE log:

    RepAgent(16): Received the following error message from the Replication Server: Msg 32049. The replication status of column 'nontimestamp_compare_CFR'.'compare_line_value' in the primary database is 'do_not_replicate'.  Use 'sp_setrepcol' to change it, and consider using rs_subcmp to repair missing or out-of-date data at the replicate database.
     
  • This error was first received post syncing data for a replicated source table by flipping “sp_setreplicate ... false/true”.
  • We then executed "sp_setrepcol ... 'always_replicate'" post application started inserting data into the primary table.
  • The affected table has a text column and the replication definition for this table is set for 'always_replicate' now, but RepAgent keeps failing with the same error.

Read more...

Environment

  • SAP Replication Server (SRS) -  all 15.x versions
  • SAP Adaptive Server Enterprise (ASE) - all 15.x versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7 ; Sybase Replication Server 15.5 ; Sybase Replication Server 15.6

Keywords

"Replication Agent" , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

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