ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

OpenAPI Odata results from upgraded system has less items than old system

book

Article ID: 200316

calendar_today

Updated On:

Products

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

Issue/Introduction

Upgraded Performance Management

When using the same Odata OpenAPI query URL against both old and new system, for the same group, metrics and time frame, the results set is different.

The old system results set has expected set of items.

The new system results set has less than expected set of items, 50 or less.

Cause

The config settings in the Odata OpenAPI controls config file weren't matched between old and new system.

Environment

All supported Performance Management releases

Resolution

Edit the the DA file /opt/IMDataAggregator/apache-karaf-2.4.3/etc/com.ca.im.odata.beans.ODataLimiters.cfg.

Set the values to match between old and new system.

In this instance, with limited items in new vs. old, we found the defaultTopLimit and defaultExpandTopLimit values set to defaults. Default values are:

defaultTopLimit=50
defaultExpandTopLimit=100

Raising those to the following for this scenario resolved the problem.

defaultTopLimit=500
defaultExpandTopLimit=300

Additional Information

To set those values for your environment follow Knowledge Base article How do you raise the row limit in OpenAPI.