Archived discussions are read-only. Learn more about SAP Q&A

What do I do when HANA instance on AWS doesn't start correctly?

My AWS HANA was working just fine all last week and starting yesterday, the instance won't start.I've been stopping and starting the instance about twice a day. Rebooting the VM didn't seem to help.  Here are the symptoms as seen from the Linux shell after running the su - hdbadm command.

  • hdbsql - Running hdbsql -n imdbhdb -i 00 -u SYSTEM -p manager   - seems to work, but when I run a SQL statement, I get the error:

hdbsql=> select * from tpc.nation

* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused)

  • startsap - Running this command results in the following error -

imdbhdb:/usr/sap/HDB/HDB00/exe/python_support> startsap

    End program!

    Starting with NGAP 2.0 the startsap/stopsap scripts will be removed

and is no more available.

    For detailed information see Incompatible Change:

    https://wiki.wdf.sap.corp/wiki/display/LeanByD/IC_0152

  • SAP HANA Studio - I get the following error in the error log -

eclipse.buildId=unknown

java.version=1.7.0_09

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86_64

Error

Tue Nov 06 18:42:01 PST 2012

Instance not reachable: SAPControl request failed

  com.sap.ndb.studio.sapcontrol.SAPControlException: SAPControl request failed

at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:118)

at com.sap.ndb.studio.sapcontrol.SAPControl.getInstanceProperties(SAPControl.java:495)

at com.sap.ndb.studio.sapcontrol.SAPControl.collectProperties(SAPControl.java:522)

at com.sap.ndb.studio.sapcontrol.SAPControl.open(SAPControl.java:333)

at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:121)

at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:101)

at com.sap.ndb.studio.sapcontrol.SAPControlManager.getSAPControl(SAPControlManager.java:83)

at com.sap.ndb.studio.admin.model.system.impl.InstancesImpl.populate(InstancesImpl.java:401)

at com.sap.ndb.studio.admin.logfiles.jobs.CredentialsHelper.tryPopulateWithPasswordDialog(CredentialsHelper.java:133)

at com.sap.ndb.studio.admin.logfiles.jobs.SapstartsrvPrepareJob.populateEngineSapstartsrv(SapstartsrvPrepareJob.java:120)

at com.sap.ndb.studio.admin.logfiles.jobs.SapstartsrvPrepareJob.access$0(SapstartsrvPrepareJob.java:73)

at com.sap.ndb.studio.admin.logfiles.jobs.SapstartsrvPrepareJob$PopulateEngineCallable.call(SapstartsrvPrepareJob.java:35)

at com.sap.ndb.studio.admin.logfiles.jobs.SapstartsrvPrepareJob$PopulateEngineCallable.call(SapstartsrvPrepareJob.java:1)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed

at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.call(Unknown Source)

at com.sap.ndb.studio.sapcontrol.operations.SAPControlOperation.execute(SAPControlOperation.java:94)

... 17 more

Caused by: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Message send failed

at com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection.post(Unknown Source)

... 19 more

Caused by: java.net.UnknownHostException: imdbhdb

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at sun.net.NetworkClient.doConnect(Unknown Source)

at sun.net.www.http.HttpClient.openServer(Unknown Source)

at sun.net.www.http.HttpClient.openServer(Unknown Source)

at sun.net.www.http.HttpClient.<init>(Unknown Source)

at sun.net.www.http.HttpClient.New(Unknown Source)

at sun.net.www.http.HttpClient.New(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)

at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)

... 20 more

Any help would be greatly appreciated.

Bill

Tags:
  • SAP Employee
replied

Hi Bill,

Try the following from the Linux shell:

su - hdbadm

./HDB stop

./HDB start

Let us know if that helps

--Juergen

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question