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 , SAP HANA Database , 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.