SAP Knowledge Base Article - Preview

2505925 - R3trans-d - invalid username or password

Symptom

  • After a System Copy R3 trans showing the following error message:

<host>:<sid>adm> R3trans -d
This is R3trans version 6.25 (release 745 - 16.01.17 - 20:16:07).
unicode enabled version
2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"
R3trans finished (0012).

  • ******************************************
    system user is able to connect 
    ******************************************
    <hostname>:sidadm 161> ./hdbsql -n hostname:34415 -i 44 -u SYSTEM -p password
    Welcome to the SAP HANA Database interactive terminal.
    Type: \h for help with commands
    \q to quit
    hdbsql SID=> \q
    ************************************
    Schema user is unable to connect
    ******************************************
    <hostname>:sidadm 162> ./hdbsql -n <hostname>:34413 -i 44 -u SAPSR3 -p password
    * 10: authentication failed SQLSTATE: 28000
    <hostname>:sidadm 163> hdbuserstore list
    DATA FILE : /home/sidadm/.hdb/<hostname>/SSFS_HDB.DAT
    KEY FILE : /home/sidadm/.hdb/<hostname>/SSFS_HDB.KEY
    KEY DEFAULT
    ENV : hostname:34413
    USER: Schema username
    <hostname>:sidadm 164>
     
  • trans.log shows:

4 ETW000  [     dev trc,00000]  Try to connect (DEFAULT) as SAP<SID>/<pwd>@<IP-Adresse>:31015 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 : invalid username or password:
4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 10     performing CON
4 ETW000  [    dblink  ,00000]  ***LOG BY0=>invalid username or password:
2EETW169 no connect possible: "DBMS = HDB                              ---  SERVER = '' PORT = ''"

  • 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


Read more...

Environment

SAP HANA 1.0, R3trans -d

Product

SAP HANA 1.0, platform edition

Keywords

R3trans-d, system copy , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.