Question Re: Problem with Script server on my HANA Database in Technology Q&A

Problem with Script server on my HANA Database

Former Member — Tue, 26 Jun 2018 16:35:11 GMT

Hello all,

I'm experiencing issues regarding Script Server on my HANA database, I was able to change the daemon.ini (scriptserver -> instances) from 0 to 1 by running the SQL command:

   ALTER SYSTEM ALTER CONFIGURATION ('daemon.ini', 'host', 'hxehost') SET ('scriptserver','instances') = '1' WITH RECONFIGURE

It didn't work, it output the following error:

SAP DBTech JDBC: [2]: general error: change not allowed; USE ALTER DATABASE <dbname> ADD '<servicetype>' instead

So I tried using the following command, several times, but I still didn't see the service in the System landscape. I probably ran this command a few times.

ALTER DATABASE HXE ADD 'scriptserver';

After trying to restart, I saw that there were many script server processes as you can see below:

But when I try to install ESS, the HTML installer says that the status of the script server is invalid.

How should I proceed? I need to install ADP, that's why I need script server and I'm trying to install ESS.

Thanks in advance,

William

Re: Problem with Script server on my HANA Database

former_member240094 — Tue, 26 Jun 2018 19:16:56 GMT

Can you confirm if ALTER DATABASE HXE ADD'scriptserver'; was run just one time? It appears it was run many times. And multiple scriptserver services were added. See SAP note https://launchpad.support.sap.com/#/notes/2099489

You might need to deactivate additional scriptserver services. And add from scratch again.

Thanks,

Arun

Re: Problem with Script server on my HANA Database

Former Member — Tue, 26 Jun 2018 19:58:33 GMT

I'm sure it was run more than one time. How should I deactivate it?

Thanks Arun!