HANA_ADMIN.tgz import fails during SPS07 installation.

[muzavor]

During the installation/upgrade of HANA 1.0 SPS07, the installation process fails at the import of HANA_ADMIN.tgz.

HANA_ADMIN.tgz import fails due to the non-existence of statistics table in HANA DB. As the table are missing the import can not be carried out successfully.

In order to resolve this issue please perform the below :-

After the  failure of HANA_ADMIN.tgz connect to the HANA DB using HANA STUDIO.

HANA DB will be up and running as the HANA DB SERVER was installed.

Only the Delivery Units were not import due to which the error was reported.

By default the STATISTICS server is no longer part of the HANA SPS07 due to which the statistics tables required for import of the HANA_ADMIN Delivery unit are not available and the import fails.

The statistics server has to be manually activated.

This can be done by going to Configuration Tab --> nameserver.ini --> statisticsserver  and changing parameter "active: from " false" to "true"

Once this is Statistics server is activated , we can successfully import the delivery units.

The above to help us in resolving the issue related to failure in importing the Delivery Units during installation or upgrade of HANA to SPS07.

Thanks,

Regards

Shaik Arshad