Invalid entity collection or function name 'odata'

Document ID : KB000100591
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
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
Resolution:
1. Go to http://DA:8581/system/console/bundles in a browser 
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