Unable to open OpenAPI QueryBuilder
Article ID: 381081
Updated On: 03-27-2025
Products
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.
Feedback
