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.
SAP Knowledge Base Article - Preview