How do you raise the row limit in OpenAPI

Products

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

Issue/Introduction

How to raise the returned row limit in OpenAPI.

Environment

All supported DX NetOps Performance Management releases

Cause

By default the number of results returned by Odata OpenApi is 50 and the max results is 20,000.

To increase these limits you must edit a file on the DA host.

Resolution

1. Log on to the Data Aggregator host.
   
   
2. Locate and edit the following file:
   
   
   • /opt/IMDataAggregator/apache-karaf-<vers>/etc/com.ca.im.odata.beans.ODataLimiters.cfg
     
     
3. Modify the file to set the limits and defaults.

The following example shows the default values for this file. The bold attributes control the limits and defaults:

defaultTopLimit=50
defaultExpandTopLimit=100
maxTopLimit=20000
maxSubQueryLimit=2000000
defaultRateTimeIntervalSecs=3600
defaultHourlyTimeIntervalHours=168
defaultDailyTimeIntervalDays=30
defaultWeeklyTimeIntervalWeeks=52
defaultQueryTimeoutSecs=30
maxQueryTimeoutSecs=120

To alter the row limit, alter maxTopLimit:  Defines the limit for the value in the maximum number of rows in the output.

Additional Information

NOTE: Please keep in mind that this default of 20,000 is there to protect the environment.  Raising it beyond 20,000 has risk and that risk gets larger the further beyond 20,000 you raise it.

Additional documentation can be found here:

• https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/20-2/apis/openapi/configure-openapi-defaults-and-limits.html