Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

How to Trouble Shoot A FailedStatisticserver migration

Purpose

This page is to explain troubleshooting steps for various issues which you may encounter with the statistics server on SAP HANA

Overview

There are two versions of the statistics server. One exists as a standalone process, visible in the HANA studio. The other, possible after revision 74 of SAP HANA, is the embedded statistics server.

Standalone Statistics Server

This is the original statistics service which is still delivered as active with HANA SPS7, SPS8 and SPS9. You must manually migrate to the new embedded statistics service.

The embedded statistics service is only available from revision 74 onwards.

Embedded Statistics Service

This version consumes less memory than the older, standalone statistics server process. It is available from revision 74 onwards. See the documents and notes below for guidance on migrating from the standalone statistics service to the embedded statistics service.

 

 

 Related Content

See the following blog explaining the migration process:

Statistics Server migration blog

How to Trouble Shoot A FailedStatisticserver migration Failed

 

 

See section titled "The Statistics Service" of the SAP HANA Administration Guide

 Related Videos

SAP HANA Academy - SAP HANA Administration: Monitoring - Embedded Statistics Server [SPS 09]

Related SAP Notes/KBAs

SAP Guided answer: Troubleshooting Embedded Statistics Server Migration

SAP Note 1929538 - HANA Statistics Server - Out of Memory

SAP Note 2019148 - Statistics server cannot be started due to LOG FULL event reported

SAP Note 1917938 - Migration of the statistics server for Revision 74 or higher

SAP Note 2092033 - Embedded Statistics Service Migration Guide

SAP Note 2154442 - Delete spare volume files of the statisticsserver after its migration

SAP Note 2006652 - SAP HANA Statistics Server - Switch to Embedded Statistics Service fails

SAP Note 2036630 - Statisticsserver migration fails with 'error installing' / 'SQL error 129'

SAP Note 2139017 - Embedded Statistics Server migration failed while creating STARTUPMIGRATIONSTEPIMPLEMENTOR procedure

SAP Note 2130884 - Statisticserver is continuously crashing due to an Orphaned Timestamp

SAP Note 1950221- SAP HANA DB Reinitializing the statisticserver

SAP Note 1859700 - System Over view shows Statistics Server has been disabled

SAP Note 2111691 - Statistics server crash dump after upgrade to Revision 84 of HANA

SAP Note 2113564 - Error reading data from table STATISTICSSERVER.STAT_VIEW_COLUMN_TABLES_PART_SIZE

SAP Note 2154844 - HANA Alerts keep getting disabled after switching to the embedded statisticserver

SAP Note 2170779- SAP HANA DB: Big statistics server table leads to performance impact on the system

SAP Note 2215093 -  After upgrading to Rev 97 the statisticsServer does not work

 


 

 

  • No labels