Wednesday, 10 August 2016

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

How to Trouble Shoot Statistic server migration Failed

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

How to Trouble Shoot Statistic server migration Failed

INDEXSERVER

How to Trouble Shoot Statistic server migration Failed
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

How to Trouble Shoot Statistic server migration Failed

Nameserver.trc

How to Trouble Shoot Statistic server migration Failed

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

Source: scn.sap.com