Dust Community Icon

Troubleshooting SQL Query Issues with Dust Database Errors

·
·

Hello! Since a few days I got an error each time my assistant use the query table. I seems that it cannot find the right database name to select the data from. Nor it using the wrong database name or throw an error Error running TablesQuery app Is there anything on Dust side that might justify this issue (that I did not have at all last week) on any tips on making sure the SQL request is the right one?

  • Avatar of Alban
    Alban
    ·
    ·

    Hi, could we get a screenshot of what you see in "Tools inspections"?

  • Avatar of Romain Dechamps
    Romain Dechamps
    ·
    ·

    Hello Alban, here it is

  • Avatar of Romain Dechamps
    Romain Dechamps
    ·
    ·

    Alban could it be that I am using 2 different query tools (one to match the question with a specific CES scope and one to query the data based on the results from the previous step) ? I cannot tell since I dont't have the Tool's custom name in the Tool inspection.

  • Avatar of Romain Dechamps
    Romain Dechamps
    ·
    ·

    Which means it would try to call a database using the wrong tool, thus creating a fake name instead?

  • Avatar of Alban
    Alban
    ·
    ·

    Hmm, give it a shot with only one tool enabled to rule out this hypothesis?

  • Avatar of Romain Dechamps
    Romain Dechamps
    ·
    ·

    Alban Sound like this is working I don't have wrong labelled SQL request! It would be useful to have the tool's name (query_3 or a custom name) in the Tool inspection to help debugging this king of situation 🙂

  • Avatar of Alban
    Alban
    ·
    ·

    Sounds good, thanks for the feedback!