-
Notifications
You must be signed in to change notification settings - Fork 7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ai agent mysql tool cannot pass dymanic values using {{$fromAI()}} #11209
Comments
Hey @jithinagiboson, We have created an internal ticket to look into this which we will be tracking as "GHC-304" |
Hey @jithinagiboson, Can you expand the error details? Looking at that I suspect one of your 9 inputs doesn't have valid output data, Have you checked all 9? |
if i put the query static it works. But i want to select the table name dynamicaly from table list and call describe on that table name |
am trying to create a text to sql chat bot |
@jithinagiboson can you share the full output from the error so we can take a look? no execution data sounds like one of the 9 runs may not be returning anything. |
Perfect and what is the output of the model and are you using one that is smart enough to know that there are multiple tools that may need to be used? |
i am using qwen2.5 14b its very inteligent than llama3.1 for this stuff |
My_workflow (2).json |
Do you have the output of the model? I can see the input on the tool which could be different to the output of the model |
|
change ollama chat model format to JSON now output is shorter but same issue
|
Perfect thanks I will pass this to the team to look into. |
thank you |
Bug Description
i was trying to execute sql query which is dynamicaly populated by the ai agent
the table name is clearly generated by the ai and it is very visible on the expression output.But when i run it i shows no execution data available. i think its a bug.
i am using version 1.62.3
To Reproduce
just try to pass a dynamic value from ai to the query section
Expected behavior
the qury should have worked using the dynamic value which in my case was table name
Operating System
Linux Mint 21
n8n Version
1.62.3
Node.js Version
v20.10.0
Database
MySQL
Execution mode
main (default)
The text was updated successfully, but these errors were encountered: