cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
480
Views
0
Helpful
1
Replies

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

Komal Tagdiwala
Cisco Employee
Cisco Employee

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>

 

1 Reply 1

Paul Zimmerman
Cisco Employee
Cisco Employee

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers