filtered rest call returns empty list but shouldn't

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Using this API call to get a listing of QOS elements on a device:

http://<DA>:8581/rest/qosclassmap/filtered posting this

<FilterSelect xmlns:xsi='http://DA/2001/XMLSchema-instance' xsi:noNamespaceSchemaLocation='filter.xsd'>
 <Filter>
 <DeviceComponent.DeviceItemID type='EQUAL'>221148</DeviceComponent.DeviceItemID>
      </Filter>
 <Select isa="exclude" use="exclude">
  <DeviceComponent use="exclude">
   <IndexList use="include" />
   <DeviceItemID use="include" />
  </DeviceComponent>
  <Pollable use="exclude">
   <IsPolled use="include" />
  </Pollable>
  <Item use="exclude">
   <Name use="include"/>
    <Description use="include" />
  </Item>  
</Select>
</FilterSelect>

returns

<QoSClassMapList />


but this is a PE device with many QOS elements discovered and reporting data from them

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

There is a limit of 200,000 endpoints, and this query is for over 4 million

WARN  | 59259963-1009752 | 2020-05-29 13:40:16,288 | WebApplicationExceptionMapper | pl.WebApplicationExceptionMapper   73 | xf.cxf-rt-frontend-jaxrs |       | javax.ws.rs.WebApplicationException: java.lang.IllegalArgumentException:  The estimated count of 4162840 for endpoint qosclassmap exceeds the maximumn allowed by the mananger of 200000. To avoid risking the integrity of the server, we are unable  to return the request XML.

Caused by: java.lang.IllegalArgumentException:  The estimated count of 4162840 for endpoint qosclassmap exceeds the maximumn allowed by the mananger of 200000. To avoid risking the integrity of the server, we are unable  to return the request XML

Resolution

Run a less extensive query