Question Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance in Technology Q&A

sapcontrol from powershell returns no return value for ABAP/JAVA instance

Former Member — Fri, 01 Feb 2019 10:01:13 GMT

Hello,

I'm using thefollowing script to get the process list of an instance.

$proxy = New-WebServiceProxy -uri http://myserver.domain.de:50113?wsdl
$proxy.GetProcessList()<br>

Is the instance a hana database the return value is correct. But is the instance an ABAP/ASCS/JAVA/ASCS instance there is no return value.

Cannot find an overload for "GetProcessList" and the argument count: "0".
At line:2 char:1
+ $proxy.GetProcessList()
+ ~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodException
    + FullyQualifiedErrorId : MethodCountCouldNotFindBest<br>

I'm able to reqest the methods and GetProcessList is available.

Are there any restriction outside of an HANA enviroment?

br Patrick

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

RolandKramer — Tue, 05 Feb 2019 14:47:05 GMT

Hi,

On ABAP system you would use the sapcontrol commands, as the wdsl URL only works for HANA

Note 2533003 - sapcontrol webmethods end with FAIL: NIECONN_REFUSED

Note 2631116 - Enqueue Server status: Running but not responding

Best Regards Roland

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Thu, 07 Feb 2019 22:19:34 GMT

Hello Roland,

The wdsl URL, in this case, is being provided by the sapstartsrv process, which is also running on ABAP and Java instances.

Thus, this is not restricted to a HANA DB system ;-).

Best regards,

Isaías

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Thu, 07 Feb 2019 22:38:54 GMT

Hello Patrick,

What is the version (release and patch level) of the SAP kernel in use at the ABAP/Java instances?

Regards,

Isaías

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Former Member — Mon, 11 Feb 2019 09:35:28 GMT

I use our Solution Manager to test the ABAP and JAVA instance. Both instances have the following release and patch level.

sapstartsrv, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:11:59
disp+work, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:19:35
gwrd, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:31
msg_server, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:30
dboraslib.so, 753, patch 319, changelist 1893869, RKS compatibility level 0, optU (Dec 21 2018, 21:30:18), linuxx86_64, 2018 12 21 21:31:18
dbmssslib.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:29
dbdb2slib.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:29
dbdb4slib.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:09:08
dbdb6slib.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:29
dbsybslib.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:29
dw_gui.so, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:12:31
enserver, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:30
enq_server, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:30
icman, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:31
sapwebdisp, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:31
jcontrol, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 20:56:27
jlaunch, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:08:57
jstart, 753, patch 300, changelist 1876288, RKS compatibility level 0, optU (Oct  9 2018, 20:55:42), linuxx86_64, 2018 10 09 21:09:06

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Mon, 11 Feb 2019 14:30:50 GMT

Hello Patrick,

Kernel 753, ok.

Try the following:

$proxy = New-WebServiceProxy -uri http://myserver.domain.de:50113?wsdl
$proxy.Credentials = new-object System.Net.NetworkCredential("SIDadm","password")

$type = $proxy.GetType().NameSpace
$proclist = New-Object ($type + ".GetProcessList")

$proxy.GetProcessList($proclist)

Regards,

Isaías

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Former Member — Mon, 11 Feb 2019 15:35:06 GMT

Hello Isaías,

that's the return value:

process                           
-------                           
{disp+work, igswd_mt, gwrd, icman}

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Mon, 11 Feb 2019 16:39:35 GMT

Hello Patrick,

That's it. It worked.

If you need a more detailed output (e.g., showing the statuses), then use:

$proclist = New-Object ($type + ".GetProcessList")
$list = $proxy.GetProcessList($proclist)
$list.process | Format-Table

Regards,

Isaías

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Former Member — Thu, 14 Feb 2019 09:25:51 GMT

Hello Isaías,

thank you very much for your competent support. I'm not a Powershell professional and I'm trying to use this issue to feed our monitoring tool.
So the bottom line is login information is needed? Why this big difference between HANA and ABAP/JAVA?

HANA

$proxy = New-WebServiceProxy -uri http://myserver.domain.de:50013?wsdl
$proxy.GetProcessList()

ABAP/JAVA

$proxy = New-WebServiceProxy -uri http://myserver.domain.de:50113?wsdl
$proxy.Credentials = new-object System.Net.NetworkCredential("SIDadm","password1234")

$type = $proxy.GetType().NameSpace
$proclist = New-Object ($type + ".GetProcessList")

$list = $proxy.GetProcessList($proclist)
$list.process

Is there a way to solve this for ABAP/JAVA as elegantly as in the HANA environment?

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Fri, 15 Feb 2019 16:03:03 GMT

Hello Patrick,

You are welcome! 🙂

You can try it without the "$proxy.Credentials..." line to see whether the method you are calling is "protected" (meaning it required authentication).

For more information about the protected methods, read this wiki page.

Regards,

Isaías

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Fri, 15 Feb 2019 16:07:09 GMT

PS: About the different coding required, this is about the SAP kernel version in use, not about being a HANA or ABAP/Java instance.

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Former Member — Fri, 31 May 2019 23:21:53 GMT

isaias.freitas

Thank you for this Info, it was very helpful. I actually like this format much better as it allows you to know which parameters are availible

For instance.

$proxy.StopSystem("SAPControlALLINSTANCES","*","0","15")

Is now (other values already defaulted)

$StopSystem = New-Object ($type + ".StopSystem")

$StopSystem.waittimeout = 15

$proxy.StopSystem($StopSystem)

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Sat, 01 Jun 2019 22:52:42 GMT

You are welcome! 🙂

Re: sapcontrol from powershell returns no return value for ABAP/JAVA instance

Isaias_SAP — Sat, 01 Jun 2019 22:54:16 GMT

Hello Patrick,

If your question has been answered, please mark it as closed 😉

Thanks!