SAP HANA – white page after logon to Lifecycle Management

Today will be about a case, that has frustrated me for a long time. I have in mind a situation when You put Your username and password on the Lifecycle Management page and next You receive a white page. You can’t do anything else. The situation occurred on HANA 200.65

To diagnose this situation I increased the trace level in Tenant and SystemDB. I also started the Chrome Browser in incognito mode and activated the development tools console (Function 12 key).

The Chrome console log showed that page (object) /sap/ui5/1new/resources/sap-ui-core.js does not exist within the HANA XS classic repository or is inactive:

GET https://hostname:43XX/sap/ui5/1new/resources/sap-ui-core.js net::ERR_ABORTED 404 (Not Found)

The object itself is part of the HANA Automated Content of delivery unit SAPUI5_1NEW. Automated content is installed together with SAP HANA and imported into the SAP HANA repository during installation. This is an integral part of the SAP HANA database and is used by every SAP HANA database customer. Important information: the DU SAPUI5_1NEW was introduced with SPS06.

Automated content is located on the SAP HANA system in the following folder:
/usr/sap/<SID>/SYS/global/hdb/auto_content.

I checked the installed delivery units on my system by executing:

select * from _SYS_REPO.DELIVERY_UNITS where delivery_unit = 'SAPUI5_1NEW'

and it shows that ‘SAPUI5_1NEW’ is loaded in the proper revision. Next, I checked whether there are inactive objects in my system by executing:

select * from _SYS_REPO.inactive_object where delivery_unit = 'SAPUI5_1NEW' order by delivery_unit;

In a healthy system, there are NO inactive objects owned by SAP – meaning query:

select count (*) from _SYS_REPO.inactive_object where delivery_unit IN (select delivery_unit from _SYS_REPO.DELIVERY_UNITS where RESPONSIBLE = 'SAP');

returns 0 as a result. In my system, there were 37000 objects owned by SAP inactive.

Solution

On Tenant DB: The affected object lacks in the active objects table of the HANA repository since the query returns no result:

select package_id, object_name, object_suffix, delivery_unit, object_status
from _sys_repo.active_object
 where package_id = 'sap.ui5.1new.resources' and object_name = 'sap-ui-core' and object_suffix = 'js';

--> no result

You have to reimport the missing delivery units by reimporting the HANA auto content.

1. Stop all tenant databases.

2. As <sid>adm user, log on to the server and deploy all auto content DUs on the system database by executing the following command:

/usr/sap/SID/SYS/global/hdb/install/bin/hdbupdrep --content_directory=/usr/sap/SID/SYS/global/hdb/auto_content  --ignore=check_version

3. Start all tenant databases. The content on the tenant databases will be synchronized with the content on the system database on tenant start.

4. Now on SystemDB and tenant DB the query must return the result:

select package_id, object_name, object_suffix, delivery_unit, object_status
from _sys_repo.active_object
where package_id = 'sap.ui5.1new.resources' and object_name = 'sap-ui-core' and object_suffix = 'js'
and OBJECT_STATUS = '0';

5. And there must no longer be objects within the SAP namespace on status 1:

select package_id, object_name, object_suffix, delivery_unit, object_status
from _sys_repo.active_object
where OBJECT_STATUS = '1';

6. When I did everything both SQL (point 4 and point 5) didn’t return anything. I imported once again Delivery Unit from HANA Studio:
File -> Import -> Delivery Unit -> HANA SID… -> Select File from Server: SAPUI5_1New.tgz….
After importing and activating everything – SQL from step 4 returns a result.
Now everything looked OK and the page opened correctly.

The procedure is described by SAP in note 2182103.