Symptom
- You have upgraded the ASE on your system and the update finished successfully. After that you have tried to connect the application,which failed and the system is inaccessible.
- The application log is failed with the following error:
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 7165]
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 7165]
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
4 ETW000 [ dev trc,00000] ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 7165]
4 ETW000 [ dev trc,00000] (4002) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
4 ETW000 [ dev trc,00000] Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=xxxx;port=4901;uid=SAPSR3DB;db=SID;pwd=xxxxxxxxx;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=3;ProtocolCapture=cap_p27442_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 4002 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>[ASE Error SQL4002]Login failed.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite.
Product
Keywords
rsecssfx,SQLConnectWithRetry,SAPSR3DB,SQL4002,Login failed , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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