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(myDS.mydb) - /nrm/nrm.c(2616)
The replication status of column 'mytable'.'mycolumn' 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 'mytable'.'mycolumn' 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview