Error while creating the sql using Vanna's generate sql

[jais001]

Hi Guyz,

Iam trying to generate sql and querying in the DB. But it was working fine till now, and now frequently I am getting 2 types of errors:

I have currently initialized the vanna object globally as a singleton object since these error where occurring everytime. Now the frequency of errors has reduced but still occurring when new type of questions are asked. How can I solve this.

1. string indices must be integers, not 'str'
2. "object of type 'NoneType' has no len()",

This error is thrown from the generate_sql function, I have no way of knowing what is the reason. The question which was working fine recently is now throwing this exception frequently.

My vanna version is: vanna[chromadb,openai,postgres]==0.7.6

Can someone help me to fix this issue. Can I know what is the cause of this issue?

Thanks