Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

'Error on Open Administration Editor' HANA Studio Reports

|| 0

'Error on Open Administration Editor' HANA Studio Reports
Stechies

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


Advertisement
Advertisement
Advertisement