How to Trouble Shoot Statistic server migration Failed

Run the following SQL to determine the time it failed at

select

        value

from

_SYS_STATISTICS.STATISTICS_PROPERTIES

where key = 'internal.installation.state';

This will return the time that the switch failed at

Check the indexserver and nameserver trace file for an error at this particular time

The following are the most common reasons why the migration will fail

Example 1

NAMESERVER

INDEXSERVER

There are several known errors related to the switching to the migrated statistic server

In the above example if you do a note search for

“exception 9002001: SQL error 129”

It will return the required note which in this case is

2036630 - statisticsserver migration fails with 'error installing'/ 'SQL error 129'

EXAMPLE 2

Indexserver.trc

Nameserver.trc

In the above example if you do a note search for

“ exception 9002002: Duplicate catalog object”

It will return the required note which in this case is

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

Example 3

if the parameter nameserver.ini [statisticsserver] active = true was revert back to "false" automatically and the migration failed

Then the note you need to refer to is

2139017 - Embedded Statistics Server migration failed while creating STARTUPMIGRATIONSTEPIMPLEMENTOR procedure

Related SAP Notes

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 2154844 - HANA Alerts keep getting disabled after switching to the embedded statisticserver

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