SAP Knowledge Base Article - Preview

3344279 - ASE Error SQL4002 Login failed-after upgrade ASE Unable to logon to the SAP application - SAP ASE for Business Suite

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

SAP Adaptive Server Enterprise all versions ; SAP NetWeaver Application Server for Java all versions

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.