SAP Knowledge Base Article - Preview

2505925 - R3trans -d fails with invalid username or password after hdbuserstore is updated

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 = ''"

  • The hdbuserstore has been updated succesfuly and you are able to login using the hdbuserstore DEFAULT key.


Read more...

Environment

SAP HANA, platform edition

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 for Me (Login required).

Search for additional results

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