3010276 - SYB - SAP application failed to start because of ASE Error SQL9666

• You are running SAP Business Suite on SAP ASE with High Availability Disaster Recovery (HADR)

• You follow the guide to remove HADR manually, you canceled the command below even though it has not been finished:
  
  sp_hadr_admin deactivate, '300', 'teardown', 'force', 'nodrain'
  go

• The SAP application could not connect to the database, you see the error in trans.log:

4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6276]
4 ETW000 [ dev trc,00000] (9666) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server is running in
4 ETW000 [ dev trc,00000] 'Primary Inactive' mode. You do not have the necessary role or privilege to logi
4 ETW000 [ dev trc,00000] n while the server is running in this mode.
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=******;port=4901;uid=SAPSR3;db=***;pwd=xxxxxxxxxx;TextSize=2147483647;CRC=0;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;QuotedIdentifier=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=30;ProtocolCapture=cap_p24646_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 9666 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL9666][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server is running in 'Primary Inactive' mode. You do not have the necessary role or privilege to login while the server is running in this mode.
2EETW169 no connect possible: "DBMS = SYBASE --- "

SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

SQL9666, 9666, teardown, deactivate, HADR , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Problem