API query stuck in ready state

Hello,

I am writing a small program in python where I am testing connectivity to our datalake in the training environment. I have established connectivity to the api using updated credentials, and am able to send a query

I've verified the authorization token is valid as well as verified the query returns results in data fabric.

However when trying to retrieve the query results it returns

"Failed to retrieve query results. Status code: 404
Response: {"messageCode":"711","messageCategory":"API","messageType":"ERROR","message":"Query not found."

I took a deeper dive into the json response and found that the "state" field of the query never leaves the "running" state, making the results unavailable.

response = requests.post(url, headers=aheaders, data=sql_query)

data = response.json()
queryId = data["queryId"]
status = data["status"]

Has anyone experienced a similar issue?

Find more posts tagged with

ION API Gateway

Accepted answers

All comments

Kevin Heiman

what method are you invoking? It appears you are just resending a new query request versus using the status to check on your queryid.

sasha-bekman

This:

result_response = requests.get(result_url, params={"offset": 0, "limit": 20}, headers=aheaders)

where result url is the base URL with the queryID and some additional path where results are stored. But before this line is executed i have a loop that checks the query status and it never leaves the running state

Kevin Heiman

That is still a bit ambiguous to me.. Can you confirm you are make a POST to v2/compass/{queryID}/status ?

Use this API with the queryID to check the status of a query submitted through the Compass job API.

The link above has the difference methods and their respective parameters.

If you are, do you get a result with the same query in Compass? If this is a first time over a large data set if may take time to build. Is the table set to V2 engine?

else do you have a support incident? or a queryID reference to look up?

sasha-bekman

Hi Kevin,

I am initially making a post to:

https://mingle-ionapi.inforcloudsuite.com/OBERG_TRN/DATAFABRIC/compass/v2/jobs

via

response = requests.post(url, headers=aheaders, data=sql_query)

It prints the following:

Response: {'status': 'RUNNING', 'location': 'jobs/52qxGM7Vf5BqFpDqZjR3/status', 'queryId': '52qxGM7Vf5BqFpDqZjR3'}

I then extract the response data as seen below:

data = response.json()
queryId = data["queryId"]
path = data["location"]
status = data["status"]

Then I reconstruct the URL with the following code:

result_url = f"{base_url}/jobs/{queryId}/result/"

At which point i attempt to retrieve the query data via

result_response = requests.get(result_url, params={"offset": 0, "limit": 20}, headers=aheaders)

# Check if the request was successful
if result_response.status_code == 200:
print('Query results retrieved successfully')
print('Response:', result_response.text)

This is not the first time it has ran over a large data set, and the engine is also set to V2. I don't have a support incident as this is my first time reaching out about this issue.

Copyright © 2025 Infor. All rights reserved.