search

chriselswede / hanacleaner

A house keeping script for SAP HANA
76 stars 44 forks source link

USER ERROR: The user represented by the key SYSTEMKEY cannot connect to the system #42

Closed masterrazi closed 1 year ago

masterrazi commented 1 year ago

USER ERROR: The user represented by the key SYSTEMKEY cannot connect to the system. Make sure this user is properly saved in hdbuserstore. Will now continue with the other keys (if there are any)

mbertram commented 1 year ago

Ensure that the user key SYSTEMKEY exists in hdbuserstore. You can list the available keys using:

hdbuserstore List

If the key exists, try connecting using:

hdbsql -U SYSTEMKEY

If the key doesn't exist or the connection fails, you'll need to add/update the key or troubleshoot further. It might be worth checking SAP Note 2430286, as it could provide some guidance or a solution to this issue.

masterrazi commented 1 year ago

Thank you it worked. HANA version 2.00.060.00.1637829839 Solution:

  1. 2695950 - HANACleaner Fails To Connect HANA Database Using hdbuserstore Key
  2. After restore to SBX . Tenant DB Users are unable to login with same password as Source System for HANA version 2.00.060.00.1637829839 and need manual reset. (seems like a bug in the product)