Stopping Scriptserver

[fabian_krger]

Hello,

recently I enabled the scriptserver to try some PAL functions.

I followed the steps on

http://search.sap.com/notes?id=0001650957

Now I want to stop it again t free some RAM.

The Note says:

"Stopping the script server

To stop the script server change the parameter 'instances' to 0. After the next SAP HANA database restart the script server is stopped."

It worked out so far (scriptserver stopped), but now my System-State is always red because of the stopped scriptserver...

Additionally I get some alerts:

What do I need to do to stop these alerts and remove the red system state?

EDIT: Additional Problem is, I can't do a data backup any more...

Regards,

Fabian

[kai-christoph_mueller · Accepted solution]

Hi Fabian

I could replay your issue and will try to find a solution for this. Due to a public holiday in Germany, this could take a little longer...

Best regards

\kc

[fabian_krger · Accepted solution]

Hey Kai-Christoph,

any updates for this problem?

As far as I can see there is a update to Rev. 56 available on cloudshare.

I also did not receive any update information via email (as stated in the announcement?).

But I guess this problem needs to be solved before upgrading?

Kind Regards,

Fabian

[kai-christoph_mueller · Accepted solution]

Hi Fabian

sorry for getting back to you late. I was not in office the last days...

Well, last week an answer was provided. These are the steps, you need to carry out:

Carry out the following steps to stop SAP HANA script server and remove SAP HANA scriptserver from the topology:

Stop all the applications that use the database. This is required because a new data backup has to be created after you remove SAP HANA scriptserver. A log replay over the time of the service removal is not supported.

Determine all the hosts on which SAP HANA scriptserver services are active:

select host from m_services where service_name = 'scriptserver'

Determine the volume ID of the SAP HANA scriptserver services:

select VOLUME_ID from m_volumes where service_name = 'scriptserver'

Stop the SAP HANA scriptserver services. To do this, carry out the following command for every <host name> with an SAP HANA scriptserver service:

ALTER SYSTEM ALTER CONFIGURATION ('daemon.ini', 'host', '<host name>') UNSET ('scriptserver','instances') WITH RECONFIGURE

Remove the SAP HANA scriptserver service entry from the topology. To do this, carry out the following command for every <host name> with an SAP HANA scriptserver service:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') UNSET ('/host/<host name>', 'scriptserver')  WITH RECONFIGURE

Remove the volumes from the topology. To do this, carry out the following command for every <volume_id> of an SAP HANA scriptserver service:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') UNSET ('/volumes', '<volume_id>')  WITH RECONFIGURE

Caution: It can be a risk to make changes to the topology. Therefore, carefully check the host and the volume ID.

Now you should create a new data backup.

Hope this helps?

Best regards

\kc

[fabian_krger · Accepted solution]

You are right. Now the state is green again and I was able to perform a backup.

Best Regards,

Fabian