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.