SAP Knowledge Base Article - Preview

2667891 - R3trans gives authentication error after system copy and restart

Symptom

  • HANA database is up and running
  • Schema user password is also correct and able to connect using it
  • But application is not able to connect even after hdbuserstore set properly
  • After system copy you updated the hdbuserstore successfully as per SAP Note: 2250144 - FAQ: SAP HANA Secure User Store, but you are still facing this error message

Running the R3trans command shows output similar to this:

appsvr13:sidadm 52> R3trans -x
This is R3trans version 6.26 (release 753 - 07.07.17 - 10:54:42).
unicode enabled version
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"
R3trans finished (0012).
appsvr13:sidadm 53> cat trans.log
4 ETW000 R3trans version 6.26 (release 753 - 07.07.17 - 10:54:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 09.07.2018 - 18:50:22
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Mon Jul 9 18:50:22 2018
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/sid/SYS/exe/run/dbhdbslib.so' ...
4 ETW000 [ dev trc,00000] Library '/usr/sap/sid/SYS/exe/run/dbhdbslib.so' loaded
4 ETW000 [ dev trc,00000] Version of '/usr/sap/sid/SYS/exe/run/dbhdbslib.so' is "753.02", patchlevel (0.11)
4 ETW000 [ dev trc,00000] switch DBSL TRACE LEVEL from 3 to 1
4 ETW000 [ dev trc,00000] DBHDBSLIB : version 753.02, patch 0.011 (Make PL 0.16)
4 ETW000 [ dev trc,00000] HDB shared library (dbhdbslib) patchlevels (last 10)
4 ETW000 [ dev trc,00000] (0.011) Row count calculation changed (note 2501455)
4 ETW000 [ dev trc,00000] (0.011) ReadFda with SQLDBC_SUCCESS_WITH_INFO (note 2502106)
4 ETW000 [ dev trc,00000] (0.009) HANA tenant connection (note 2493371)
4 ETW000 [ dev trc,00000] (0.007) Column names mist be quoted in the ITAB description (note 2478632)
4 ETW000 [ dev trc,00000] (0.005) Row not found is traced as an error (note 2478632)
4 ETW000 [ dev trc,00000] (0.004) Call CB function after CANCEL of hana procedure (note 2478632)
4 ETW000 [ dev trc,00000]
4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime (pid=103346)...
4 ETW000 [ dev trc,00000] SQLDBC Module : /usr/sap/sid/hdbclient/libSQLDBCHDB.so
4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 2.02.023.1499440855
4 ETW000 [ dev trc,00000] SQLDBC client runtime is 2.02.023.1499440855
4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ...
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 --- SERVER = '' PORT = ''"


Read more...

Environment

SAP HANA Platform Edition 1.0, 2.0

Application Servers on Linux

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP S/4HANA 1709

Keywords

hdbuserstore ; error ; issue ; authrntication failed ; connect failed ; r3trans ; SQLCODE : 10 , KBA , HAN-DB-SEC , SAP HANA Security & User Management , 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.