AXL disallowing more than 24854 rows in Call to extract list of users from CUCM

[Komal Tagdiwala]

I have an Python script that needs to fetch the list of users on a given CUCM site. It was working fine for some time but has suddenly started failing with the following error:

"Query request too large. Total rows matched: 393878 rows. Suggestive Row Fetch: less than 24854"

How do I overcome this issue if I don't have any additional limiting criteria to fetch less records since I need the list of ALL USERS on that site.

Implementation Details

The automation run against several sites to determine the user volume on each site so I have been using the following API Call:

https://{host}:8443/axl/

and the following criteria to get a list of ALL Users

        resp = service.listUser(searchCriteria={'userid': '%'},

                                returnedTags={'firstName': '', 'lastName': '', 'userid': '', 'department': '', 'primaryExtension':'','enableCti':'','status':''})

Detailed Error

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server</faultcode>
<faultstring>Query request too large. Total rows matched: 393878 rows. Suggestive Row Fetch: less than 24854 rows</faultstring>
<detail>
<axlError>
<axlcode>5011</axlcode>
<axlmessage>Query request too large. Total rows matched: 393878 rows. Suggestive Row Fetch: less than 24854 rows</axlmessage>
<request>listUser</request>
</axlError>
</detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

[Paul Zimmerman]

You might have more success with getting this answered on the Developer Collaboration Management board:
https://community.cisco.com/t5/management/bd-p/j-disc-dev-collab-mgmt