SQL QnA not working as expected

[Vignesh-k-arc]

In SQL QnA, I tried to use postgres instead of singlestore.
In the first js function, it is getting connected to the database and also the schema is printed but the output is not reflected in the prompt template. Same problem in the second js function, the sql query is not getting executed.
this is the first workflow i tried
workflow 1: agents 03.09 Agents.json

workflow 2:
In the second workflow i tried to add variable nodes. the same issue persisted.

agents_v1_pg_03.09 Chatflow.json

Please provide help on how to solve this.

[yangzishy]

hello！ Have you solved it already?

[HenryHengZJ]

do you have analytic traces? If not, strongly recommend so you are able to find out whats wrong for each step. An example webinar series: https://memsql.wistia.com/medias/i1ra0jared

[hchor]

Yeah there are a number of things that can go wrong. I finally got it working. I'll try to update the example JSON when I have time (firstly, it's out of date with latest flowise).