SAP Knowledge Base Article - Preview

3223841 - Removing database from HADR system failed due to error in dropping repdef - SRS

Symptom

  • Execute sap_update_replication remove_db,<db> failed. sap_status task show the following output:
    1>sap_status task
    2> go
    TASKNAME             TYPE                                              VALUE
    ----------------        -----------------------------                -------------------------------------------------------
    Status                    Start Time                                      Sat Jul 09 00:08:18 SGT 2022       
    Status                    Elapsed Time                                  00:01:10
    UpdateReplication   Task Name                                      Update Replication
    UpdateReplication   Task State                                       Error
    UpdateReplication   Short Description                             Update configuration for a currently replicating site.
    UpdateReplication   Long Description                              Dropping the replication definitions for database 'db'.
    UpdateReplication   Failing Command Error Message  Failed to drop the replication definition'<CID>_*****COMP_<db>_repdef' for connection '<CID>_*****COMP.<db>'.
    UpdateReplication   Current Task Number                       7    
    UpdateReplication   Total Number of Tasks                      9                          
    UpdateReplication   Task Start                                       Sat Jul 09 00:08:18 SGT 2022                     
    UpdateReplication   Task End                                         Sat Jul 09 00:09:28 SGT 2022                                    
    UpdateReplication   Hostname                                       hostname                           
    DropRepDef           Task Name                                      Drop Database Replication Definition       
    DropRepDef           Task State                                       Error                                        
    DropRepDef           Short Description                             Drop a Database Replication Definition.         
    DropRepDef           Long Description                              Dropping the Database Replication Definition '<CID>_<COMP>_<db>_repdef' for connection '<CID>_<COMP>.<db>' .           
    DropRepDef           Failing Command                             drop database replication definition '<CID>_<COMP>_<db>_repdef' for connection '<CID>_<COMP>.<db>'
    DropRepDef           Failing Command Return Code          15475             
    DropRepDef           Failing Command Error Message       Error encountered while dropping the Database Replication Definition '<CID>_<COMP>_<db>_repdef' for connection '<CID>_<COMP>.<db>' .    
    DropRepDef           Failing Exception                            Message: 'Cannot drop database replication definition '<CID>_<COMP>_<db>_repdef' for connection '<CID>_<COMP>.<db>' , because it is used by subscriptions.' Cause: ''.
    DropRepDef           Hostname                                     hostname
                                                                                                                                                                                  
  • Drop subscription command was issued by RMA multiple times in active SRS as seen in SRS log
      
    PRIMARY Replication Server: Dropping subscription <<CID>_<COMP>_<db>_sub> for database replication definition <<CID>_<COMP>_<db>_repdef> with replicate at <<CID>_<PRIM>.<db>>
    PRIMARY Replication Server: Dropping subscription <<CID>_<COMP>_<db>_sub> for database replication definition <<CID>_<COMP>_<db>_repdef> with replicate at <<CID>_<PRIM>.<db>>
    PRIMARY Replication Server: Dropping subscription <<CID>_<COMP>_<db>_sub> for database replication definition <<CID>_<COMP>_<db>_repdef> with replicate at <<CID>_<PRIM>.<db>>
    PRIMARY Replication Server: Dropping subscription <<CID>_<COMP>_<db>_sub> for database replication definition <<CID>_<COMP>_<db>_repdef> with replicate at <<CID>_<PRIM>.<db>>
    PRIMARY Replication Server: Dropping subscription <<CID>_<COMP>_<db>_sub> for database replication definition <<CID>_<COMP>_<db>_repdef> with replicate at <<CID>_<PRIM>.<db>>


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) Always-On Option 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

repserver, SRS, SAP Replication Server, ASE , 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.