Unable to view catalog content - fetching children does not complete

[espenl]

I'm stuck with a HANA system where I'm not able to see the content of the catalog folder in the navigator in hana studio. Neither am I able to see system status, apart from the hover over the system connection where it says "all services running".

I can explore the security section but nothing else.

ANy hints or pointers?

(AWS hosted instance, less than a week old, started and stopped a few times to keep costs down. Logged on with user SYSTEM).

Changed the password for both the db user SYSTEM and for the hdbadm user.

Regards,

Espen Leknes

[kevin_small · Accepted solution]

This is a known issue and happily there is a workaround.

Read the post by Wolfgang Auer here http://scn.sap.com/message/14304262#14304262

He lists a series of SQL statements to execute at the end of his post. Before you execute them, read also Wolfgang's post here: http://scn.sap.com/message/14315505#14315505 where he specifies a point where you have to wait bit before executing the final SQL statement.

I've experienced the "catalog hanging" error many times, and I used to have to restore from backup like you did.  But it often comes back, so it is worth knowing the workaround.

[Former Member]

Which Revision of HANA you are in? has there been a recent upgrade to HANA studio.

Does the HANA studio revision matches that of HANA database?

[espenl]

Hana instance rev 60, client and studio just downloaded and installed.

I gave up in the end and created a new image. Not a very good solution, but got impatient.