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

[former_member184680]

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

[isaias_freitas]

Hello Patrick,

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

Regards,

Isaías

[isaias_freitas]

Hello Patrick,

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

Thanks!

[former_member959108]

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)

[isaias_freitas]

You are welcome! 🙂

[former_member184680]

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?

[isaias_freitas]

Hello Patrick,

You are welcome! 🙂

Login might be needed, depending on the method being called.

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

[isaias_freitas]

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

[isaias_freitas]

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

[former_member184680]

Hello Isaías,

that's the return value:

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

[isaias_freitas]

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

[former_member184680]

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

[RolandKramer]

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

[isaias_freitas]

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