Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member232435
Discoverer
1,524


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

Labels in this area