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?

7 comments

Alban
·
·
Hi, could we get a screenshot of what you see in "Tools inspections"?
Romain Dechamps
·
·
Hello Alban, here it is
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.
Romain Dechamps
·
·
Which means it would try to call a database using the wrong tool, thus creating a fake name instead?
Alban
·
·
Hmm, give it a shot with only one tool enabled to rule out this hypothesis?
👍1
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 🙂
Alban
·
·
Sounds good, thanks for the feedback!