SAP Knowledge Base Article - Preview

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

Symptom

  • 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 --- "


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.