Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply