Im using Orion API to get query output but for Orion.Nodes iyts working fine but Orion.Credential its showing error


Im using Orion API to get query output but for Orion.Nodes iyts working fine but
Orion.Credential its showing error

{"query":"SELECT IPAddress,non.Caption,non.DNS,non.NodeDescription FROM Orion.Nodes as non where non.NodeID=1 ORDER BY non.NodeID WITH ROWS 1 TO 5"} ==> working fine
______________________________________________________________________________
{"query":"SELECT ID, Name, Description, CredentialType FROM Orion.Credential"}

=>
{"Message":"No concrete entities are derived from entity Orion.Credential","ExceptionType":"SolarWinds.Data.Query.ParserException","FullException":"SolarWinds.Data.Query.ParserException: No concrete entities are derived from entity Orion.Credential\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Visit(SourceExpression source)\r\n at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(FromClause from)\r\n at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(SelectStatement statement)\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Visit(SelectStatement statement)\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Process(SelectStatement select, PreProcessorState state)\r\n at SolarWinds.Data.Query.Processor.PreProcessor.Process(SelectStatement selectStatement, PreProcessorState& preProcessorState)\r\n at SolarWinds.Data.Query.Engine.QueryProcessor.CompileQueryExecutionPlan(String query, IQueryExecutionContext context)\r\n at SolarWinds.Information* Connection #0 to host SolarWinds-Orion left intact
Service.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)\r\n at SolarWinds.InformationService.Core.InformationService.GetQueryExecutionPlan(String query, IIdentity currentIdentity, Boolean federationEnabled, IQueryExecutionContext queryExecutionContext)\r\n at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer, IMessageFormatterStrategy messageFormatterStrategy)"}

Parents
  • When you go to: 

    https://<your_server>:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+ID%2c+Name%2c+Description%2c+CredentialType+FROM+Orion.Credential

    What do you get? 
    You may have to accept the certificate (which is self signed) and provide credentials but the you should get the correct results. 

  • Hi

    Thanks for ur reply.

    a link which you have provided is working correctly on Browser, its showing result. But i i used the same query in the curl command as below its showing me the above error (Message":"No concrete entities are derived from entity Orion.Credential"........)

    curl -v --tlsv1.2 --cacert 'server.pem' -u {user:password} -H "Accept: application/json" -H "Content-Type: application/json" -X GET https://SolarWinds-Orion:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+ID%2c+Name%2c+Description%2c+CredentialType+FROM+Orion.Credential

    But if i changed query as below its working correctly:-


    curl -v --tlsv1.2 --cacert 'server.pem' -u {username:password}-H "Accept: application/json" -H "Content-Type: application/json" -X GET SolarWinds-Orion:17778/.../Query

  • looks like the post shorten the working url, but are you good now? 

  • No, Im not getting data if I used that query in curl.

  • OK, I managed to get your err.

    My account was fine, a non-existent account did nothing. A test account with admin rights also worked, until I took that away, and then I saw your error. I think your account doesn't have access to the credentials table maybe? Try another account and maybe it changes. 

Reply
  • OK, I managed to get your err.

    My account was fine, a non-existent account did nothing. A test account with admin rights also worked, until I took that away, and then I saw your error. I think your account doesn't have access to the credentials table maybe? Try another account and maybe it changes. 

Children
No Data