Problems adding HANA IDES system to SolMan

[danny_hearn2]

Hello Everyone,

I've been following https://wiki.scn.sap.com/wiki/display/TechOps/Managed+System+Setup+of+HANA+in+SAP+Solution+Manager+7...  for help in connecting our IDES HANA installation to Solution Manager.  I'm mainly doing it for the experience in connecting HANA to Solution Manager.

I've been running into issues where the commands I'm issuing are working but the connection still cannot be made.  HANA and NW are installed on the same system.  The document specifies using <sid>adm to create the connection, but doesn’t specify if it’s should be hdbadm or sb1adm.  My guess was that it expects it to be hdbadm. 

For understanding, these are the relevant configuration information:

DB SID:                                        HDB

SAP SID:                                      SB1

HANA System no from Studio:     02

sidadm (hana):                              hdbadm

sidadm (SAP):                               sb1adm

Monitoring user created in Studio  MONITOR

I've run the command to SET the HDBUSERSTORE:

hdbuserstore SET SB1SAPDBCTRL servername:30215 MONITOR xxxxpassxx

hdbadm@servername:/usr/sap/hostctrl/exe/hdbuserstore list SB1SAPDBCTRL

KEY SB1SAPDBCTRL  

ENV : servername:30215  

USER: MONITOR

I have tried a few different combinations to try to get this to work. If I try to run sapdbctrl to get a status, I get:

hdbadm@servername:/usr/sap/hostctrl/exe> ./sapdbctrl status SB1 -t hdb

ERROR: Database not found: No SAP instance (newDB) SB1 found.

I also ran the set command above for HDBSAPDBCTRL

hdbadm@servername:/usr/sap/hostctrl/exe> ./sapdbctrl status HDB -t hdb

ERROR: Database software not installed

If I do everything as root including the , I get the following:

[root@servername ~]# /usr/sap/SB1/hdbclient/hdbuserstore list HDBSAPDBCTRL

KEY HDBSAPDBCTRL

ENV : servername:30215

USER: MONITOR

I had to logon using HANA studio and reset the password for user MONITOR. That password was used to create the HDBUSERSTORE.

[root@servername ~]# /usr/sap/hostctrl/exe/sapdbctrl status HDB -t hdb

Instance Name: HDB02, Hostname: servername, Vendor: HDB, Type: hdb, Release: 1.00.110.00.1447753075

Database Name: HDB, Status: Error

Component Name: hdbdaemon (HDB Daemon), Status: Running (Running)

Component Name: hdbcompileserver (HDB Compileserver), Status: Running (Running)

    Component Name: hdbindexserver (HDB Indexserver), Status: Running (Running)

Component Name: hdbnameserver (HDB Nameserver), Status: Running (Running)

Component Name: hdbpreprocessor (HDB Preprocessor), Status: Running (Running)

Component Name: hdbwebdispatcher (HDB Web Dispatcher), Status: Running (Running)

Component Name: hdbxsengine (HDB XSEngine), Status: Running (Running)

Component Name: hdbconnectivity (HDB Connectivity), Status: Error (SQLconnect not possible (invalid username or password))

Component Name: hdbalertmanager (HDB Alertmanager), Status: Unknown (no information available)

file dev_sapdbctrl contains the following entries:

[PID 21959]

Fri Mar 11 09:59:54 2016

[PID 21959] getHanaCompoments: hdbConnect failed (SQLDriverConnect: Failed to select m_database:S1000:1:414:[SAP AG][LIBODBCHDB SO][HDBODBC] General error;414 user is forced to change password: alter password required for user MONITOR

)

[PID 21959] [PID 21959] )

[PID 50410]

Fri Mar 11 13:46:24 2016

[PID 50410] *** ERROR => SqlodbcConnect: connect HANA datbase HDB. [dbhdbinstance.cpp 820]

[PID 50410] getHanaCompoments: hdbConnect failed (SQLDriverConnect: Connect with userkey failed! :HY000:1:10:[SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed

)

[PID 50410] [PID 50410] )

I know I’m close.  There is some aspect of this that I’m not quite getting.

Any ideas?

Thanks.

[Former Member · Accepted solution]

Hi Danny,

I encountered the same issue and was able to resolve it. Here are my steps:

1. Create a new user in HANA via studio. I named it HDJ_MON with password Helloworld2

2. Add the MONITORING and PUBLIC ROLES then SAVE

3. Add another HANA DB Connection then use HDJ_MON as user and Helloworld2 as password

4. You will be prompted to change your password. I entered Helloworld3

5. Log on as <sid>adm to OS level . In this case, I used hdbadm as hdb is the sid of my database.

6. Find the location of your installed hdbuserstore (mine is located at /usr/sap/HDB/HDB02 and from there, execute:

hdbuserstore SET HDBSAPDBCTRL yourdbhost:30215 HDJ_MON Helloworld3

hdbuserstore LIST

7. From the same window, switch to root user then set the LD_LIBRARY_PATH:

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hostctrl/exe

export LD_LIBRARY_PATH

env | grep LD_LIBRARY_PATH

8. Logon as hdbadm again then set the LD_LIBRARY_PATH as well:

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hostctrl/exe

export LD_LIBRARY_PATH

env | grep LD_LIBRARY_PATH

9. You may proceed with testing other connect commands

/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseProperties -dbname HDB -dbtype hdb

/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname HDB -dbtype hdb

I was stuck with this issue for some time. The main tip I can give is to NOT execute the ALTER USER HDJ_MON DISABLE PASSWORD LIFETIME command indicated in the guide that you mentioned. You may execute that command later on as you please but for this discussion, the authentication issue you encountered maybe caused by that command alone.

I hope you resolve your issue.

[danny_hearn2 · Accepted solution]

Hello Daniel,

I appreciate the detailed procedure you supplied.  As soon as my work load allows it, I'm going to give this a try.  In the meantime, I marked it as helpful.

Thanks.

[danny_hearn2 · Accepted solution]

Hello Daniel,

After implementing your suggestions, that has worked for me.

Thanks.

Danny Hearn