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.
SAP Knowledge Base Article - Preview