Online Tutorials & Training Materials | STechies.com
Register Login

'Error on Open Administration Editor' HANA Studio Reports

11 Oct 2012 3:47 pm || 0

HANA Studio: You are not able to open the Administration Editor. HANA Studio reports "Error on open Administration Editor" with reason "Could not read version information: SAP DBTech JDBC: [391]: invalidated view: M_HOST_INFORMATION: line 1 col 36 (at pos 35)"

HANA Modeler: When selecting the affected system, Modeler reports "Selected system is not supported by modeler version, choose a compatible system"

Any HANA SQL Client (e.g. HANA Studio, hdbsql): When looking at a monitoring view or explicitly selecting from a monitoring view, you get an error like the following:

https://www.stechies.com/home/new.php

Could not execute 'SELECT * FROM M_HOST_INFORMATION'

SAP DBTech JDBC: [391] (at 28): invalidated view: M_HOST_INFORMATION

This problem is caused by a bug in the HANA database when role PUBLIC is revoked from a user via "REVOKE PUBLIC FROM ".

In order to workaround this issue, do the following:

* Execute the following SQL statement as user SYSTEM:

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM')

SET ('metadata', 'force_auto_migration') = 'on'

* Restart the database.

* Execute the following SQL statement as user SYSTEM:

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET ('metadata', 'force_auto_migration') = 'off'

This bug is fixed in SAP HANA Database revision 24 and exists in all revisions prior to that.

Read more about The Key Perspectives of SAP HANA Studio