SAP Knowledge Base Article - Preview

3066438 - Connect to database failed, rc=1, rcSQL=10 authentication failed

Symptom

Modifications have been made to the hdbuserstore on application server.
After the adjustment, the SAP application cannot start.
The user-password can be confirmed to be the correct input, the user can logon normally to HANA Studio.

1. Development workprocess trace contains these errors:

C <day> <month>  <D> <HH>:<MM>:<SS>
C  *** ERROR => Connect to database failed, rc=1, rcSQL=10
 [dbhdbsql.cpp 466]
C  SQLCODE    : 10
C  SQLERRTEXT : authentication failed
B  ***LOG BY2=> sql error 10     performing CON [dbsh         1299]
B  ***LOG BY0=> authentication failed [dbsh         1299]
B  ***LOG BY2=> sql error 10     performing CON [dblink       685]
B  ***LOG BY0=> authentication failed [dblink       685]
M  ***LOG R19=> ThDbConnect, db_connect () [thxxtool.c   6020]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2762]

2. trans.log shows the following issues:

4 ETW000 R3trans version <version> (release <release>).

4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : DD.MM.YYY - HH:MM:SS

4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000  trace at level 1 opened for a given file pointer
4 ETW000  [     dev trc,00000]  <timestamp>
4 ETW000  [     dev trc,00000]  Loading DB library '<path>' ...
4 ETW000  [     dev trc,00000]  Library '<path>' loaded
4 ETW000  [     dev trc,00000]  Version of '<path>' is "<version>", patchlevel (<patchlevel>)
4 ETW000  [     dev trc,00000]  ...
4 ETW000  [     dev trc,00000]  Load library <path>/dbhdbsqldbcversion.so
4 ETW000  [     dev trc,00000]  SQLDBC Version : <version>
4 ETW000  [     dev trc,00000]  SQLDBC Module  : <path>/libSQLDBCHDB.so
4 ETW000  [     dev trc,00000]  Load library <path>/dbhdbsqldbc203.so
4 ETW000  [     dev trc,00000]  Loading SQLDBC client runtime (pid=<pid>)...
4 ETW000  [     dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB <version>
4 ETW000  [     dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...
4 ETW000  [     dev trc,00000]  connect property <property>
...
4 ETW000  [     dev trc,00000]  connect property <property>
4 ETW000  [dbhdbsql.cpp,00000]  *** ERROR => Connect to database failed, rc=1, rcSQL=10
4 ETW000  [     dev trc,00000]  SQLCODE    : 10
4 ETW000  [     dev trc,00000]  SQLERRTEXT : authentication failed
4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 10     performing CON
4 ETW000  [    dblink  ,00000]  ***LOG BY0=>authentication failed
2EETW169 no connect possible: "DBMS = HDB


Read more...

Environment

  • SAP Hana Platform Edition 1.0
  • SAP Hana Platform Edition 2.0

Keywords

hana 1.0, hana 2.0, hdbuserstore, hdbuserstore key, Connect to database failed, rc=1, rcSQL=10, authentication failed , KBA , BC-DB-HDB-POR , Dictionary & Consistency checks for SAP HANA , 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.