Skip to Content
0

Embedded Statistics Service does not work on HANA SPS11

Dec 02, 2016 at 02:30 PM

168

avatar image

Hi experst,

Embedded Statistics Service does not work on HANA SPS11

I don't know why

BRs,

Zhang

1.png (43.0 kB)
2.png (77.9 kB)
3.png (58.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mudit Srivastava
Dec 06, 2016 at 05:38 AM
0

Hi Zhang,

We are looking into your question, and will reply back shortly.

Regards,

Mudit

Share
10 |10000 characters needed characters left characters exceeded
Dermot Dunne
Dec 07, 2016 at 03:41 PM
0

Hi,

There is a known issue that has been documented in sp 12 but I have also seen it in SP11

Can you please try solution from note 2376079 - Embedded Statistics Service inactive after upgrade to Revision 122.03

If this does not work the solution in note

2215093 - After upgrading the HANA Database the statisticsserver does not work

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hi Dermot,

I can not access the url: https://i7p.wdf.sap.corp/sap/support/notes/2376079

By the way, SAP HANA One on AliCloud, I have no user to access notes. How should I do?

0

Hello,

Can you try to simply activate it again by manually setting the value to true again? Alternatively, execute the SQL command:

alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure

As already stated by my colleagues, there is a known issue with SPS12.

In case it still does not start afterwards, can you please attach the nameserver tracefile contents (not the alert but regular trace file)? In there we should see why the exact reason why the embedded statisticsserver fails to start.

Best regards,

Michael

0
Michael Gerstmayer

Hi Michael,

I execute the SQL command, the embedded statisticsserver does not work yet. The attached file is the nameserver trace file contents. Please review it.

Thanks.

Regards.

Zhang

nameserver-trc.txt

nameserver-trc.txt (606.2 kB)
0

Hello,

the nameserver tracefile doesn't show any errors. Let's continue with the one from the indexserver where the Collector Thread runs, can you upload the latest one (showing a database restart)? In addition you may could check whether:

1) The service was completely removed after the migration:

select * from sys.m_services where service_name='statisticsserver'

2) The volume has been remoted:

select * from sys.m_volumes where service_name = 'statisticsserver'

3) All collectors & checks are running:

select * from _sys_statistics.statistics_schedule where status != 'Inactive'

Best regards,

Michael

0
Michael Gerstmayer

Hello,

The following three screenshots are SQL results:

I find also a trace file statisticsserver_alert.trc that are some errors.

statisticsserver-alert.txt

Brs,

Zhang

1.jpg (36.4 kB)
2.jpg (35.0 kB)
3.jpg (107.1 kB)
0
Dermot Dunne
Dec 11, 2016 at 12:51 PM
0

Hi

Can you try the following link

https://launchpad.support.sap.com/#/notes/2376079

Regards

Dermot

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Dermot,

Please see the before screenshot: nameserver.ini -> statisticserver -> active was true

Statistics service does not work.

Regards

Zhang

0