PostgreSQL tool error for OpenAI Message Assistant node

Mark_S · October 24, 2024, 2:51pm

Describe the problem/error/question

Hey

I’m trying to setup tools for OpenAI Message Assistant node. I have this error for postgreSQL Executy Query tool. It works well for another query with dynamic variable + it works well with static value.

What is the error message (if any)?

No execution data available

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

n8n version: 1.63.1
Database (default: SQLite): PostgreSQL internal
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
Operating system:

ria · October 29, 2024, 10:36am

Hi @Mark_S

Thanks for posting here and welcome to the community!

We’ve already merged a fix for this bug and it should be released soon.

github.com/n8n-io/n8n

fix(core): Fix resolving of $fromAI expression via `evaluateExpression`

n8n-io:master ← n8n-io:ai-393-community-issue-ai-agent-mysql-tool-cannot-pass-dymanic

opened 02:22PM - 24 Oct 24 UTC

OlegIvaniv

+6 -2

## Summary This fixes an issue with resolving `$fromAI` expression when combine…d with `noDataExpression` and `evaluateExpression`. Because we're calling `.execute` of the wrapped tool node directly, the execute functions(`getExecuteFunctions`) would get created with references to the root node, and the root node's name would be passed in `evaluateExpression`. To fix this, I changed `evaluateExpression` to be a named function so that it could access the current node's context and use `this.getNode().name` to get the node's name to resolve the expression. ## Related Linear tickets, Github issues, and Community forum posts - https://github.com/n8n-io/n8n/issues/11209 ## Review / Merge checklist - [ ] PR title and summary are descriptive. ([conventions](../blob/master/.github/pull_request_title_conventions.md))  - [ ] [Docs updated](https://github.com/n8n-io/n8n-docs) or follow-up ticket created. - [ ] Tests included.  - [ ] PR Labeled with `release/backport` (if the PR is an urgent fix that needs to be backported)

Let us know if this fixes it for you!

Mark_S · November 18, 2024, 6:45pm

Hello!
Thank you for response. I updated my version and have new error. Agent trying to run simple query that works well with PostgreSQL node but fails with tool.

system · February 16, 2025, 6:45pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.