SAP HANA DB: XS Administration Tools Not Accessible

Symptom
- You can no longer access the SAP HANA XS Administration Tools.
- Even the formlogin page is not loaded.


Other Terms
SAP HANA, SAP HANA XS, SAP HANA XS Admin, xs engine, formlogin


Reason and Prerequisites
Reason:
Due to a wrong configuration of logon methods for SAP standard content, content areas that should be accessible in a non authorized scope can't be loaded.
Prerequisites:
  • Runtime configuration has been adjusted manually
  • In _SYS_XS.RUNTIME_CONFIGURATION you'll find entries different than {"authentication":null} for package_id = sap.hana.xs.formLogin
  • In _SYS_XS.RUNTIME_CONFIGURATION you'll find entries different than {"authentication":null} for package_id = sap.ui5 or any the subpackages


Solution
Revert back to the standard configuration by executing the following SQL statements:
upsert _sys_xs.runtime_configuration values ('sap.hana.xs.admin','{"authentication":[{"method":"Form"},{"method":"Basic"}]}','SYSTEM',now()) where package_id = 'sap.hana.xs.admin';
upsert _sys_xs.runtime_configuration values ('sap.hana.xs.formLogin','{"authentication":null}','SYSTEM',now()) where package_id = 'sap.hana.xs.formLogin';
upsert _sys_xs.runtime_configuration values ('sap.ui5','{"authentication":null}','SYSTEM',now()) where package_id like 'sap.ui5%';
Then restart the xs engine.

相关内容推荐