2119691 - Additional configuration steps required if updating from SAP HANA and SAP HANA Smart Data Streaming SPS 09 revision 90, 91, 92, or 93 to revision 94

Symptom

This note applies only to SAP HANA Platform and SAP HANA Smart Data Streaming SPS 09 Revisions 90 to 94.
Some of the SAP HANA smart data streaming views in the SAP HANA cockpit do not display properly.

Other Terms

cockpit, SAP HANA cockpit, smart data streaming, updating

Reason and Prerequisites

This issue occurs only if you have updated your SAP HANA and SAP HANA smart data streaming option version from SPS 09 revision 90, 91, 92, or 93 to revision 94 and did not perform additional required configuration steps.
This issue does not occur if you are installing SAP HANA and SAP HANA smart data streaming SPS 09 revision 94 as a fresh installation.

Solution

If you are planning to update your SAP HANA and SAP HANA smart data streaming option version from SPS 09 revision 90, 91, 92, or 93 to revision 94, perform these steps prior to the update:
1. Ensure that the SAP HANA instance is running.
2. Using the SAP HANA studio or hdbsql tool, connect to the SAP HANA instance as the SYSTEM user.
3. Execute:

DELETE FROM _SYS_STATISTICS.STATISTICS_SCHEDULE WHERE ID=5600;

DELETE FROM _SYS_STATISTICS.STATISTICS_OBJECTS WHERE ID=5600;

DROP PROCEDURE _SYS_STATISTICS.COLLECTOR_STREAMING_PROJECTS_STATISTICS CASCADE;

DROP VIEW _SYS_STATISTICS.STREAMING_PROJECTS_STATISTICS CASCADE;

DROP TABLE _SYS_STATISTICS.STREAMING_PROJECTS_STATISTICS_BASE CASCADE;

　

DELETE FROM _SYS_STATISTICS.STATISTICS_SCHEDULE WHERE ID=5601;

DELETE FROM _SYS_STATISTICS.STATISTICS_OBJECTS WHERE ID=5601;

DROP PROCEDURE _SYS_STATISTICS.COLLECTOR_STREAMING_PUBLISHERS_STATISTICS CASCADE;

DROP VIEW _SYS_STATISTICS.STREAMING_PUBLISHERS_STATISTICS CASCADE;

DROP TABLE _SYS_STATISTICS.STREAMING_PUBLISHERS_STATISTICS_BASE CASCADE;

　

DELETE FROM _SYS_STATISTICS.STATISTICS_SCHEDULE WHERE ID=5602;

DELETE FROM _SYS_STATISTICS.STATISTICS_OBJECTS WHERE ID=5602;

DROP PROCEDURE _SYS_STATISTICS.COLLECTOR_STREAMING_SUBSCRIBERS_STATISTICS CASCADE;

DROP VIEW _SYS_STATISTICS.STREAMING_SUBSCRIBERS_STATISTICS CASCADE;

DROP TABLE _SYS_STATISTICS.STREAMING_SUBSCRIBERS_STATISTICS_BASE CASCADE;

　

DELETE FROM _SYS_STATISTICS.STATISTICS_SCHEDULE WHERE ID=5603;

DELETE FROM _SYS_STATISTICS.STATISTICS_OBJECTS WHERE ID=5603;

DROP PROCEDURE _SYS_STATISTICS.COLLECTOR_STREAMING_STREAMS_STATISTICS CASCADE;

DROP VIEW _SYS_STATISTICS.STREAMING_PROJECT_STREAMS_STATISTICS CASCADE;

DROP TABLE _SYS_STATISTICS.STREAMING_PROJECT_STREAMS_STATISTICS_BASE CASCADE;

　

DELETE FROM _SYS_STATISTICS.STATISTICS_SCHEDULE WHERE ID=5604;

DELETE FROM _SYS_STATISTICS.STATISTICS_OBJECTS WHERE ID=5604;

DROP PROCEDURE _SYS_STATISTICS.COLLECTOR_STREAMING_PROJECT_CONNECTIONS_STATISTICS CASCADE;

DROP VIEW _SYS_STATISTICS.STREAMING_PROJECT_CONNECTIONS_STATISTICS CASCADE;

DROP TABLE _SYS_STATISTICS.STREAMING_PROJECT_CONNECTIONS_STATISTICS_BASE CASCADE;

If you have already updated your SAP HANA and SAP HANA smart data streaming version to revision 94 without performing the steps above, do the following:
1. Ensure that the SAP HANA instance is running.
2. Using the SAP HANA studio or hdbsql tool, connect to the SAP HANA instance as the SYSTEM user.
3. Execute the SQL provided in step 3 above.
4. Log onto the SAP HANA host as the <sid>adm user and issue the HDB stop command to stop the SAP HANA instance.
5. To update to SAP HANA and SAP HANA smart data streaming SPS 09 revision 94 again, run hdblcm or hdblcmgui as the root user and specify the following argument to hdblcm or hdblcmgui:

 --hdbupd_server_ignore=check_version,check_busy_files

6. Log onto the SAP HANA host as the <sid>adm user and issue the HDB start command to start the SAP HANA instance.

Header Data

Released On	20.04.2015 17:49:19
Release Status	Released for Customer
Component	HAN-SDS SAP HANA Smart Data Streaming
Priority	Correction with high priority
Category	Installation information