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
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.