HDB on AWS status

[Former Member]

Hello fellow hanalysts,

i tried a couple hours ago on an instance that is now shut down, and i keep trying on active one, but i don't seem to be able to either view administration (it's getting stuck on "Operation in progress..." message) or open my odbo connection. what's strange is that all services seem to be running and IDE is fine too, but i never had this problem before.

any suggestions?

thx,

greg

[Former Member]

Hi,

Sorry didn't quite understanding your question. Are you suggesting you AWS HDB system is working fine (e.g. you can run SQL etc) but are just unable to access the Adminsitration view?

Apologies for these basic questions:

- Have you tried to stop/start reboot your instance (via management console)?

- Are you using Elastic IP? Have you reassigned it after restart?

- Have you changed your secuirty group recently?

- Can you ping your HANA box?

- Can use PuTTY to log in?

- Have your tried to stop/start HANA from Linux command line?

- Have you closed/restarted HANA studio?

Cheers

Aron

[Former Member]

Hi Aron,

no need to apologize for asking the basics as checklists do serve their purpose.

here are my answers:

- Have you tried to stop/start reboot your instance (via management console)? yes, twice

- Are you using Elastic IP? Have you reassigned it after restart? i don't change those even though i keep paying for them and i need to assign them every time i bring the instance back

- Have you changed your secuirty group recently?  no need to do that

- Can you ping your HANA box? yes, HANA was fine both on the studio/client side as well as through browser

- Can use PuTTY to log in? no, sure why i would need to do that

- Have your tried to stop/start HANA from Linux command line? not sure what the procedure is, is there a link for that?

- Have you closed/restarted HANA studio? about 10 times.

something happened overnight as it's working fine now, but in my book the system was down all day yesterday.

thank you for answering my questions.

rgds,

greg

[Former Member]

No worries.

Please check out the following link

http://scn.sap.com/docs/DOC-28294

At the bottom there is details for using Pageant and Putty for accessing your HANA box at OS level (Linux command level)

From there you can try and manually stop and start the HANA DB.

• ./HDB stop: Command to stop HANA DB
• ./HDB start: Command to start HANA DB

I had to do that frequently with earlier Revisions of HANA running on AWS, but haven't needed to do it that often these days.

Hope that helps for you.