Unable to open OpenAPI QueryBuilder
search cancel

Unable to open OpenAPI QueryBuilder

book

Article ID: 381081

calendar_today

Updated On:

Products

Network Observability CA Performance Management

Issue/Introduction

Error opening the odataquery URL:

http://da_hostname:8581/odataquery/

{"message":"HTTP request failed","request":{"requestUri":"http://<da_hostname>:8581/odata/api/$metadata","recognizeDates":false,"callbackParameterName":"$callback","formatQueryString":"$format=json","enableJsonpCallback":false,"inferJsonLightFeedAsObject":false,"method":"GET","headers":{"Accept":"application/xml","MaxDataServiceVersion":"3.0"}},"response":{"requestUri":"http://<da_hostname>:8581/odata/api/$metadata","statusCode":404,"statusText":"Not Found","headers":[],"body":"<html><body>No service was found.</body></html>"}}

Environment

Performance Management: 23.3.13

Cause

In the /CA/IMDataAggregator/apache-karaf/data/log/karaf.log file there is the following error:

ERROR | ExtenderThread-1 | 2024-09-12T16:55:27,543 | WaiterApplicationContextExecutor | WaiterApplicationContextExecutor  442 | emini.blueprint.extender |       | Unable to create application context for [odata-services.impl], unsatisfied dependencies: none
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'limiters' defined in URL [bundleentry://131.fwk1429351083/META-INF/spring/odata-bundle.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxTopLimit'; nested exception is java.lang.NumberFormatException: For input string: "80000:"

Caused by: org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxTopLimit'; nested exception is java.lang.NumberFormatException: For input string: "80000:"

Caused by: java.lang.NumberFormatException: For input string: "80000:"

 

 

Resolution

There is a typo in the  /CA/IMDataAggregator/apache-karaf/etc/com.ca.im.odata.beans.ODataLimiters.cfg file.

defaultTopLimit=50000
defaultExpandTopLimit=100
maxTopLimit=80000:    (remove the " : " character  -  should be like this: maxTopLimit=80000)
maxSubQueryLimit=2000000
defaultRateTimeIntervalSecs=3600
defaultHourlyTimeIntervalHours=168
defaultDailyTimeIntervalDays=30
defaultWeeklyTimeIntervalWeeks=52
defaultQueryTimeoutSecs=30
maxQueryTimeoutSecs=120

And then restart the Fault-Tolerant Data Aggregator.