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