CA Service Management

web service "getGroupMemberListValues" always return empty list in CA SDM 17.1

request xml:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<soapenv:Header/>
<soapenv:Body>
<ser:getGroupMemberListValues>
<sid>1536403501</sid>
<whereClause>group.last_name != 'abc'</whereClause>
<numToFetch>1</numToFetch>
<attributes>
<string>group.last_name</string>
<string>member.userid</string>
</attributes>
</ser:getGroupMemberListValues>
</soapenv:Body>
</soapenv:Envelope>

response xml:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<getGroupMemberListValuesResponse xmlns="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
<getGroupMemberListValuesReturn xmlns="">&lt;?xml version="1.0" encoding="UTF-8"?>&lt;UDSObjectList/></getGroupMemberListValuesReturn>
</getGroupMemberListValuesResponse>
</soapenv:Body>
</soapenv:Envelope>

I am sure the groups are already created with members added.

I can capture the sql with sql profile as below.

exec sp_executesql N'SELECT grpmem.id FROM grpmem, ca_contact WHERE grpmem.group_id = ca_contact.contact_uuid AND ca_contact.last_name != @P1',N'@P1 nvarchar(4000)',N'abc'

I can executed the sql manually and get the results.

Why the response list is empty?

Hi Chison,

Could you confirm the patch level that you are on 17.1 version? Could you please paste the list of patches implemented and we can compare the same.

Below is the list of patches I am currently installed and was able to see the same behavior inhouse.

[Tue Jun 12 20:52:38 2018] - PTF Wizard created this history file.
[Tue Jun 12 20:53:46 2018] - PTF Wizard installed GOA-167_CUM_C (USRD)
[Tue Jun 12 20:55:41 2018] - PTF Wizard installed T6EE263 (USRD)
[Tue Jun 12 20:56:23 2018] - PTF Wizard installed GOA-167_EN_US (USRD)

If you have the same patch level, then please raise a case and we will be able to glad to help with a solution.

There is a fix for this. Related to defect : DE40203

Hi Chison,

The correct fix identified for 17.1 which is T52Y809. You can request this fix via a support case.

@Pier, thanks for pointing to the Defect.

Pleasure.

If you cannot install a testfix for personnal reasons, you can change your code to use doSelect instead. The returns are practically identical so there is only minor changes to do in your code.

This is what i did since i was not in a position where i could have wait for the fix. All my change order PAM flows were relying on this.

Thanks pier-olivier.

I tested the doSelect with soapui.

Then I modified the OOTB PAM operator to invoke doSelect. It works great. We will apply this workaround in our implementation. 

Thanks for your advice.

No problem