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

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.

Environment

All supported Performance Management releases

Cause

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

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.