SAP Knowledge Base Article - Preview

3044788 - HADR: The ASE Replication Agent Thread has not been configured for database 'master' - SRS

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

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0

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.