Forum OpenACS Q&A: Re: How to trace xql query problems
Does the xql file contain an <rdbms> element with all the right values? If something is not right in that element, it probably will not be recognized and loaded properly.
If I recall, with debug on, you should see (in the error log) that the QP does or does not find the query. It should also give the exact name it's looking for.