Symptom
- materialization of master failed
- sap_enable_replication fails on the last task (step 10):
1> sap_enable_replication PRIM, master
2> go
TASKNAME TYPE VALUE
------------------ ----------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------
Enable Replication Start Time Thu Apr 01 15:58:10 EST 2021
Enable Replication Elapsed Time 00:03:51
EnableReplication Task Name Start ASE Replication Agent Thread
EnableReplication Task State Error
EnableReplication Short Description Execute sp_start_rep_agent to start the ASE Replication Agent Thread for the specified database.
EnableReplication Long Description The ASE Replication Agent Thread has not been configured for database 'master'.
EnableReplication Failing Command Error Message Failed to start the Replication Agent within the ASE Server on host 'COMP.hostname.com' for server named '<SID>_PRIM_R2' and database 'master'
EnableReplication Corrective Action Connect to the ASE Server on host 'COMP.hostname.com' to resolve the problem and then resubmit the failing command.
EnableReplication Current Task Number 10
EnableReplication Total Number of Tasks 9
EnableReplication Task Start Thu Apr 01 15:58:10 EST 2021
EnableReplication Task End Thu Apr 01 16:02:01 EST 2021
EnableReplication Hostname PRIM.hostname.com - rma log reports:
[RMA] - [EnableReplication ] - Task Enable Replication - Description - Execute sp_start_rep_agent to start the ASE Replication Agent Thread for the specified database.
...
[RMA] - [EnableReplication ] - Task Enable Replication - Action - Starting the Replication Agent within the ASE Server on host 'COMP.hostname.com' for server named '<SID>_COMP_R2' and database 'master'
[RMA] - [EnableReplication ] - Task Enable Replication - Action - The ASE Replication Agent Thread has not been configured for database 'master'.
[RMA] - [EnableReplication ] - Task Enable Replication - Provided corrective suggestion - Connect to the ASE Server on host 'COMP.hostname.com' to resolve the problem and then resubmit the failing command.
[RMA] - [ConnectionManager ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:COMP.hostname.com:4911/master'.
[RMA] - [ReplicationServerUtil ] - Executing 'admin echo, '** HADR operation: sap_enable_replication PRIM, master,', with_log' on the Replication Server at PRIM.hostname.com:4910.
[RMA] - [ReplicationServerUtil ] - Executing 'admin echo, '** Message: failed', with_log' on the Replication Server at PRIM.hostname.com:4910.
[RMA] - [ConnectionManager ] - Terminate connection <1479479859(com.sybase.jdbc4.jdbc.SybConnection@4fc7be7)>: jdbc_sybase_Tds_PRIM.hostname.com_4910_master_PRIM.hostname.com_4910_sa_9893e6c6d6f1ffa1ce6a20ba5e9bec1b (s/r/a/w/t/o) (72304/21/0/0/0/0)
[RMA] - [ConnectionManager ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:PRIM.hostname.com:4911/master'.
[RMA] - [EnableReplication ] - Task Enable Replication - State - Error
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- SAP Replication Server (SRS) 15.7.1
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
- SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite
Product
Keywords
RepServer, RS, BHADR, sap_enable_replication, materialization , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.