Resolve error during Embedded Statistics Service Migration SAP HANA SPS10
Source system with error during Embedded Statistics Service Migration :
OS – RHEL 6.5
DB – SAP HANA version 1.00.102.03.1449674847
Problem:
You got incorrect status after start Embedded Statistics Service Migration(according note 2092033) by executing this command:
alter system alter configuration (‘nameserver.ini’,’SYSTEM’) set (‘statisticsserver’,’active’)=’true’ with reconfigure
When you check status of migration by executing SQL
select value from _SYS_STATISTICS.STATISTICS_PROPERTIES where key = ‘internal.installation.state’
you got this error:
“Done (error) since <timestamp>”
Resolution:
During migration some SQL procedures from _SYS_STATISTICS schema cannot be compiled. Reason is old SQL in procedures _SYS_STATISTICS.ALERT_CHECK_INACTIVE_STREAMING_APPLICATION_STATE and
_SYS_STATISTICS.ALERT_CHECK_INACTIVE_STREAMING_ADAPTER_STATE
By default, SQL engine doesnt work with such syntax in HANA SPS10, so you need to enable processing of old SQL – see note 2241598 – Changed UPDATE FROM syntax can cause ‘invalid table name’ error
So, according note
2241598 – Changed UPDATE FROM syntax can cause ‘invalid table name’ error
you need perform some modifications of parameters in these files:
indexserver.ini
[sql]
enable_old_update_from_behavior = true # default : false
xsengine.ini
[sql]
enable_old_update_from_behavior = true # default : false
Then recompile procedures – execute these statements in SQL console:
ALTER PROCEDURE _SYS_STATISTICS.ALERT_CHECK_INACTIVE_STREAMING_APPLICATION_STATE RECOMPILE WITH PLAN;
ALTER PROCEDURE _SYS_STATISTICS.ALERT_CHECK_INACTIVE_STREAMING_ADAPTER_STATE RECOMPILE WITH PLAN;
ALTER PROCEDURE _SYS_STATISTICS.SYS_STATISTICS.STATISTICS_SCHEDULABLEWRAPPER RECOMPILE WITH PLAN;
Then again execute migration of statistics server (note 2092033) by executing:
alter system alter configuration (‘nameserver.ini’,’SYSTEM’) set (‘statisticsserver’,’active’)=’true’ with reconfigure
Check any errors at indexserver diagnosis file