Unable to retrieve information about the query

  • Goal: Query to successfully run in preview mode and when published. It runs with no issues when in build mode.

  • Steps:

  • Details: change_budget failed (0.269s):Unable to retrieve information about the query "change_budget"

  • Screenshots:
    Not working in preview mode.

working in build mode

Steps:

  1. Create a new retool database resource query.
  2. Write an insert query. string and/or integer.
  3. Add the query to an event trigger on a button.
  4. Go into preview mode
  5. Press the button.

Hi @Levi_Miller, welcome to the forum! :wave:

Could you include a screenshot from preview mode that shows the url when this query runs?

i got this query as resource for a table and set to automatic.

If I unpublish the latest release it works. I can successfully run the queries in preview mode.

Could you share the contents of this query? It looks like we may be referencing getSubmittedForms within getSubmittedForms (Dependency cycle).

There might a change on the latest release that is causing this issue.

Hi,

It's happening again. It works fine in the editor but when I preview it doesn't work.

It's happening on every new query that I add.

Screenshot 2024-11-12 at 16.17.00


The queries you are sharing are not the same as the ones above.

For the previous ones,

You are using url.searchParams.projectId, it would help seeing the param on the url.

For the new ones you shared, could you share the contents of query85 and get_tags_update_project?

Without this context, diagnosing what's causing your issue is like taking a shot in the dark.

Hi Paolo, sorry for the confusion here. Just to confirm, it's not resource specific, it's all new resources that I add. The issue goes away when I publish or unpublish the application, this makes it difficult to work with you on this as I can't wait to get it fixed, I need to publish.

Does contents mean the information that the database returns?

I meant what the queries are doing, the SQL if it's a SQL query or the code if it's a JS query, the same way you shared this one:
image

But on that one we need to see the URL params. If we haven't added the projectid query param on preview, we would in fact expect it to fail.

Is this only happening with queries or with Components as well?