sapstartsrv not started (HANA installation)

[rajarshi_muhuri]

Can you please tell me what is the steps to a full working HANA system , when I have installed the following in the order

1. sap_host_agent ( rpm install)

2. hdb_server (hdbsetup)

3. hdb_client (hdbinst -a studio)

4. lm_struc (hdbinst -a lm )

I have not done the SUM installation yet , as it for updating and is not really required right away for full functioning of HANA system . As such hdbdaemon, hdbnameserver, hdbpreprocessor, hdbindexserver, hdbstatisticserver are all green and running.

Please note that I did not find /sapmnt .. that I seems that it should have beenautomatically created during the hdb_server setup.

so is the manual creation and mounting needed now ?

I have created the HANA database and its running SID HAN , instance# 00

What is the next step , adding host (hbdaddhost) ?

and how do i it .. rather what are the command line parameters i need to input .

The installation guide is not very clear on it .

[rajarshi_muhuri · Accepted solution]

I pasted the images from HANA studio

1. http://imageshack.us/photo/my-images/534/captureyz.jpg/

2. http://imageshack.us/photo/my-images/405/capture2qd.jpg/

[Vitaliy-R · Accepted solution]

For "yellow status" issue please have a look at my post: http://twitter.com/#!/VitalBI/status/133933569922965504

But you do not need to worry too much about it. If you check on OS level using "./HDB info" command you'll see it's running.

[tomas-krojzl · Accepted solution]

For "yellow status" issue please have a look at my post: http://twitter.com/#!/VitalBI/status/133933569922965504
> 
> But you do not need to worry too much about it. If you check on OS level using "./HDB info" command you'll see it's running.

Hello,

I can see that Vitaliy already has solution - try that one first.

Tomas

[rajarshi_muhuri · Accepted solution]

Here is my sapstartsrv.log

---------------------------------------------------
trc file: "sapstartsrv.log", trc level: 0, release: "720"
---------------------------------------------------
pid        7741

[Thr 139854170220352] Thu Nov 10 11:21:45 2011
No halib defined => HA support disabled
CCMS agent initialization: WARNING: cannot recognize an instance type, continuing in the non-ABAP mode.
CCMS agent initialization: return code 0.
CCMS agent start: return code 0.
Initializing SAPControl Webservice
Starting AutoRestart thread
SapSSLInit failed => https support disabled
Starting WebService thread
Webservice thread started, listening on port 50013
Trusted http connect via Unix domain socket '/tmp/.sapstream50013' enabled.
AutoRestart thread started

[rajarshi_muhuri · Accepted solution]

@ Vitaly

I believe that I was able to do your points 1 and 2 , but not sure how to change HTTP to native

1. hostname -f

saplinux.xxdomain.com

2. lsof -i -n -P | grep 50013

sapstarts 7741 hanadm 6u IPv4 80277 0t0 TCP *:50013 (LISTEN)

3. HTTP to NATIVE ???

Edited by: Rajarshi Muhuri on Nov 10, 2011 7:07 PM

[tomas-krojzl · Accepted solution]

Hello,

I think that by "HTTP to NATIVE" is meant following:

HANA Studio menu > Window > Preferences > General > Network Connections > ...

Tomas

[tomas-krojzl · Accepted solution]

Hello,

I just found this SAP note Note 1639568 - SAP HANA Studio zeigt Systemstatus gelb

Unfortunately it is in German - below is free translation using tools on internet:

Note 1639568 - SAP HANA Studio displays system status yellow
Symptom
SAP HANA Studio displays the status with yellow although all HANA services are running
Other terms
SAPStartSrv, HANA database, HANA Studio
Reason and Prerequisites
The SAP HANA Studio is unable to reach the SAPStartSrv even though this is running.
Solution
In HANA Studio under Window-> Preferences-> Network Connections-> Active provider change the value of "native" to "direct".

Tomas

[rajarshi_muhuri · Accepted solution]

Tomas, thanks .. I really thought that I had nailed it this time ecspecially with the SAP Note . But it still shows Yellow.

I am now wondering if I have truely missed something during installation . I find that on rightclicking the system in HANA Studio, the Start, Stop, Restart is grayed out.

My Question is "How do you check for a successful install + check that HANA is UP and Running"

I start the HAN 00 system by this command

$ su - hanadm

$ /usr/sap/HAN/HDB00/HDB start

I see that sapstartsrv is running

saplinux:~ # ps -ef | grep sapstartsrv
sapadm    3791     1  0 16:44 ?        00:00:00 /usr/sap/hostctrl/exe/sapstartsrv pf=/usr/sap/hostctrl/exe/host_profile -D
hanadm    3879     1  0 16:44 ?        00:00:00 /usr/sap/HAN/HDB00/exe/sapstartsrv pf=/usr/sap/HAN/SYS/profile/HAN_HDB00_saplinux -D -u hanadm
root      5049  5034  0 17:04 pts/0    00:00:00 grep sapstartsrv

and

saplinux:~ # /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList

10.11.2011 17:06:45
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2011 11 10 16:46:11, 0:20:34, 4315
hdbnameserver, HDB Nameserver, GREEN, Running, 2011 11 10 16:46:15, 0:20:30, 4333
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2011 11 10 16:46:34, 0:20:11, 4414
hdbindexserver, HDB Indexserver, GREEN, Running, 2011 11 10 16:46:36, 0:20:09, 4431
hdbstatisticsserver, HDB Statisticsserver, GREEN, Running, 2011 11 10 16:46:37, 0:20:08, 4438

[Vitaliy-R · Accepted solution]

Point #1 was about using fully-qualified domain in the connection string in Studio: we saw yellow light on one machine's Studio and green one in the studio on another one...

[former_member203134 · Accepted solution]

The settings described in this note not resolved the issue. Suprisingly, my collegue, who installed the HANA Studio version 18 only, see is green (irrespective http/ direct/ native mode). Same Studio version on my laptop shows it yellow!

[former_member203134 · Accepted solution]

Indeed the same issue, we are also facing!

[rajarshi_muhuri · Accepted solution]

@Vitaly

I see what you mean .. I added the FQDN of the HANA server in the hosts file in the Windows Machine running HANA Studio.. and now its GREEN.

Thanks very very much !! and Enjoy your Madrid stay

@ Tomas Thanks again

[rajarshi_muhuri · Accepted solution]

@Manish I had installed the version 18 but was still seeing it .

But anyway now its fixed after adding the FQDN entry on the windows machine running studio

[former_member203134 · Accepted solution]

Hi, updating the hosts file with FQDN helped! now I see the sapstartsrv green! Many thanks.

[Vitaliy-R · Accepted solution]

I know the thread is closed, but if I may - for my own education - to ask what does the following command do:

...
> 2. lsof -i -n -P | grep 50013
> sapstarts 7741 hanadm    6u  IPv4  80277      0t0  TCP *:50013 (LISTEN)
...

I never used it before (in fact I am not OS guy, or Basis for that matter

Thanks,

-Vitaliy

[tomas-krojzl · Accepted solution]

Hello,

I know the thread is closed, but if I may - for my own education - to ask what does the following command do:
2. lsof -i -n -P | grep 50013
sapstarts 7741 hanadm    6u  IPv4  80277      0t0  TCP *:50013 (LISTEN)

lsof - list open files
An open file may be a regular file, a directory, a block special file, a character special file, an executing text reference, a library, a stream or a  network file ( Internet socket, NFS file or UNIX domain socket.)
-i <i> This option selects the listing of files any of whose Internet address matches the address specified in i.
       If no address is specified, this option selects the listing of all Internet and x.25 (HP-UX) network files.
-n     This option inhibits the conversion of network numbers to host names for network files.
-P     This option inhibits the conversion of port numbers to port names for network files.

In other word it checking which application is allocating specific port.

Tomas

[rajarshi_muhuri · Accepted solution]

Just to summarise

lsof -i -n -P

gives a list of all open ports , but since the list is many

| grep 50013 just seeks to see if the port 50013 is open or not

[mstitsel · Accepted solution]

I installed Hana SP3 (patch 25) and had the same problem.

sapstartsrv service not started.

I had to do:

Check if the port is open:

lsof -i -n -P | grep 53013

(in this example we have port number 30)

Check if the full qualified domain name is used:

hostname -f

(should return the full hostname)

Check if the full qualified domain name is in the Windows hostfile of the Laptop/PC that is

running the Hana studio:

Windows > preferences > General > Network connections >

Active Provider should be direct (instead of default Native)

And what was not yet mentioned:

Create the following directory as user <sid>adm:

/usr/sap/PHP/global/sapcontrol

Restart Hana

[Former Member · Accepted solution]

this resolved our issue. thanks!

[srinivaas]

This message was moderated.

[Former Member]

Hi Colleagues,

When im performing HANA cluster installation we are getting error like:

we are facing an issue when we are trying to add host in secondary as like below:

mo-599bcd458:/mnt/shared/W15/global/hdb/install/bin # ./hdbaddhost


SAP HANA Lifecycle Management - Database Addhost 1.00.095.00.1429086950
***********************************************************************



Enter Local Host Name [mo-599bcd458]:
Enter System Administrator (w15adm) Password:
Add host failed
Cannot verify password: sapstartsrv of host 'mo-88059af8e' is not running
Cannot establish http connection to 'mo-88059af8e:50213' (Net::HTTP: connect: Connection timed out)

At the same time, sapstart srv is running fine in prmary:

mo-88059af8e:~ # lsof -i -n -P | grep 50213
sapstarts 9831 w15adm 11u IPv4 113607 0t0 TCP *:50213 (LISTEN)

Kindly let us know how can we establish the connectivity of sapstartsrv between primary and secondary.

Regards,

Raghu

[Former Member]

Raghunath I have the same problem, but with SAP HANA 1.00.97.01

What did you do to solve?

Thanks

[Former Member]

Hi Rajarshi,

any clue how I can see if the host agent is running in my HANA server?

and if not how can in install it?

my Lifecycle manager is not getting connected from the HANA studio because of this.

a quick reply would be really appreciated.

Thanks,

Nitin Jain

[Former Member]

Hello Nitin Jain,

I would recommend you to post this as a new question for quick response.

Thanks

Sangamesh

[Former Member]

This discussion gives a great deal of inforamtion. But, it is never mentioned how exactly a FQDN has to be in the hosts file.

Is it something like:

EIP  ec2-xx-xx-xx.xxxxxx.compute.amazonaws.com

or like :

EIP  ec2-xx-xx-xx  ec2-xx-xx-xx.xxxxxx.compute.amazonaws.com

Currently I have added the below FQDN to my hosts file in this form but do not work...

EIP  ec2-xx-xx-xx  ec2-xx-xx-xx.xxxxxx.compute.amazonaws.com

Thanks

[Former Member]

Hi,

I could add a new system in the HANA Studio without any error. Name of tables appear, but the problem is when I run the query it does not show any retrieved data. here is the snapshot of the error which is: "Error on refreshing system". I tried all of the solution here, but still it does not work. Does anyone have any Idea?

Thank you

[Former Member]

Hi,

In case of nothing above worked, you can update windows hosts file with IPs.

Boris

[tomas-krojzl]

Hello,

to have working system all you need (the minimum) is to install only SAP HANA database - other parts are not critical for SAP HANA to run without issues... (of course there is reason to have them installed)

Regarding the "missing" /sapmnt directory - it seems that in case of SAP HANA it does not need to be explicitly names as /sapmnt - see image on page 14 in Server installation guide:

https://service.sap.com/~sapidb/011000358700000604572011

Can you find on your server /hdbmnt filesystem/directory?

If you are looking for log files please switch to <sid>adm user and go to trace directory:

su - hanadm
cd $SAP_RETRIEVAL_PATH/trace
cat sapstartsrv.log

Please paste here the log file.

Note: If you want to try to resolve this really fast without trying to identify reason - it might be possible solution to stop SAP HANA and then to kill sapstartsrv process (just be sure that you really stopped all child processes). After next start of SAP HANA new startsapsrv process will be created.

Tomas