Symptom
- HADR got removed by sap_teardown/removehadr successfully, however still application can't connect to database
- Verified in primary and companion ASE for HADR status all returned correctly as No HADR:
1> select hadr_mode(), hadr_state()
2> go
------------------------------ ------------------------------
No HADR Unknown - No error in primary ASE database server
- From application host test connection with command 'R3trans -d' as user '<SID>adm', in trans.log reported messages:
4 ETW000 [ dev trc,00000] dbs/syb/cache_size: 200
4 ETW000 [ dev trc,00000] Can't run against non primary server (hadr_mode is -1)
4 ETW000 [ dev trc,00000] CheckHadrPrimary failed. Connect terminated.
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 99980 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL99980]Can't run against non primary server.
2EETW169 no connect possible: "DBMS = SYBASE --- "
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- High Availability Disaster Recovery (HADR)
Product
SAP Adaptive Server Enterprise 16.0
Keywords
sybase, BS, SAP Business Suite, removehadr, teardown, failed, error, R3trans -X, down , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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