DB2SQL agent is running with errors: Cannot query the correct data via SQL statement.

[gavinju]

Self Checks

• I have searched for existing issues search for existing issues, including closed ones.
• I confirm that I am using English to submit this report (Language Policy).
• Non-english title submitions will be closed directly ( 非英文标题的提交将会被直接关闭 ) (Language Policy).
• Please do not modify this template :) and fill in all the required fields.

Describe your problem

Using text to sql、db assistant, there is an error: Cannot query the correct data via SQL statement.

What is the reason for this?

[dosubot]

@gavinju 🌟 Hey there! I'm here to help you with any bugs, questions, or even becoming a contributor. I'm your friendly neighborhood bot, ready to assist you while we wait for a human maintainer.

The error "Cannot query the correct data via SQL statement" occurs when the DB2SQL agent is unable to successfully execute a SQL query after multiple attempts to regenerate and refactor the SQL statement. This happens when the _run method in the agent/component/exesql.py file tries to execute a SQL statement, and if it fails, it attempts to regenerate the SQL statement using the _regenerate_sql method. If the regenerated SQL statement still fails to execute correctly after a specified number of attempts (self._param.loop), the error message is returned ^[1].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[KevinHuSh]

Could you debug ExecSQL alone with a executable statement that has been test through the database client?