2184307 - Issues with cockpit if you do not run SQL statement before upgrading SAP HANA and SAP HANA smart data streaming from SPS 09 to SPS 10

Symptom

This issue applies only to SPS 10 Revision 100.
If you upgrade your SAP HANA and SAP HANA smart data streaming versions from SPS 09 to SPS 10 without executing a specific SQL statement, no statistics display within the different pages in the SAP HANA smart data streaming cockpit tile in SAP HANA cockpit.
This is only applicable in upgrade scenarios. If you run a fresh installation of SAP HANA and SAP HANA smart data streaming SPS 10, this issue does not occur.

Other Terms

cockpit, smart data streaming, SAP HANA, upgrading

Reason and Prerequisites

The SAP HANA statistic server encounters issues after the upgrade.

Solution

Before upgrading from SPS 09 to SPS 10:

• Execute the following SQL statement: delete from _SYS_STATISTICS.statistics_objects where id=5300

Or, if you have already upgraded to SPS 10:

1. Run the following SQL statement: delete from _SYS_STATISTICS.statistics_objects where id=5300
2. Restart the SAP HANA instance.
3. Execute the following SQL statement to check the statistics server status: select * from "_SYS_STATISTICS"."STATISTICS_PROPERTIES"
   
4. If the result is Done (okay), then the statistics server has started correctly and you can start viewing statistics for smart data streaming within SAP HANA cockpit. If the result is Done (error), reconfigure the statistics server from SAP HANA studio:
   
1. Open HANA studio.
   
2. Select the SAP HANA Administration Console perspective.
3. From the Systems view, right-click the System Name, and select Configuration and Monitoring > Open Administration. The system administration page opens.
4. On the administration page, select the Configuration tab, then expand nameserver.ini> statisticsserver.
5. Double-click the active row and re-set the value to true.
6. The status should now be Done (okay) and you can start viewing statistics for smart data streaming within SAP HANA cockpit.

Header Data

Released On	27.08.2015 19:15:02
Release Status	Released for Customer
Component	HAN-SDS SAP HANA Smart Data Streaming
Priority	Correction with high priority
Category	Upgrade information