SAP Knowledge Base Article - Preview

3623597 - After upgraded to 16.0.4.6, orphaned HADR (CDB) objects are constantly left in the tempdb - SAP SRS

Symptom

  • After upgraded to 16.0.4.6, orphaned HADR (CDB) objects are constantly left in the tempdb:
    rs_datm_tran_log_evt_410_9                                              
    rs_ddp_history_evt_410_7                                                
    rs_dgb_hold_top_ptid_410_10                                             
    rs_dov_bpay_rig_arch_410_32                                             
    rs_dpc_uniqu_no_ptid_410_12                                             
    rs_uatm_tran_log_410_16                                                 
    rs_uatm_tran_log_411_2                                                   
    rs_uatm_tran_log_412_2                                                   
    rs_uatm_tran_log_413_16                                                  
    rs_uatm_tran_log_413_2                                                   
    rs_udp_acct_aily_bal_410_11   

  • And there are much more frequent occurrence of 'Parallel apply failed':

    41): /................/calm/repl/svr/code/generic/dsi/hqexec.c:3086:Parallel apply failed.
    Retry of a grouped transaction of 759 individual transactions has failed in database 'SID_Site2.SID'. It will be broken into smaller groups and retried.
    ERROR #1028 DSI EXEC(115(3) SID_Site2.SID) - neric/dsi/dsiqmint.c(5039)
            Message from server: Message: 3701, State 1, Severity 11 -- 'Cannot drop the table 'tempdb..rs_udp_history_evt_410_8', because it doesn't exist in the system catalogs.'.
            
    (38): /................/calm/repl/svr/code/generic/dsi/hqexec.c:3086:Parallel apply failed.
    Retry of a grouped transaction of 249 individual transactions has failed in database 'SID_Site2.SID'. It will be broken into smaller groups and retried.
    ERROR #1028 DSI EXEC(115(3) SID_Site2.SID) - neric/dsi/dsiqmint.c(5039)
            Message from server: Message: 2714, State 1, Severity 16 -- 'There is already an object named 'rs_uatm_tran_log_410_2' in the database.'.
        


Read more...

Environment

  • SAP Replication Server (SRS) 16.0 SP04 PL06 HF1
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL06 HF1 with High Availability Disaster Recovery (HADR)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR830890, CR#830890,830890, 2714, 3701, HADR, Parallel, retry, grouped transaction , 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.