Invalid entity collection or function name 'odata'

Products

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

Issue/Introduction

When trying to launch query builder the following message is seen "Invalid entity collection or function name 'odata'"  and the querybuilder goes on to the initializing stage and never comes up.  Here is the full message:

{"message":"HTTP request failed","request":{"requestUri":"http://<DA>: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 host>:8581/odata/api/$metadata","statusCode":500,"statusText":"Server Error","headers":[],"body":"<?xml version='1.0' encoding='UTF-8'?><error xmlns=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\"><code/><message xml:lang=\"en\">Invalid entity collection or function name 'odata'.</message></error>"}}

Environment

CAPM 3.x

CAPM 20.x

Resolution

1. Go to 

      http://DA:8581/system/console/bundles in a browser 

      (replace DA with your DA)

2. If presented with a login use karaf / karaf: 

3. Search for and restart (refresh package icon) the following 4 services in this UI: 

• 184 odata-services.authenticationcom.ca.im.odata-services.authentication
• 185 odata-services.implodata-services.impl
• 187 odata-services.odataquerycom.ca.im.odata-services.odataquery
• 186 odata-services.querybuildercom.ca.im.odata-services.querybuilder 

 

You should now be able to log into and use query builder