Trouble Upserting Embeddings into PostgreSQL in Flowise v3

[omerbykbs]

Hello dear FlowiseAI community,

I'm encountering an issue when trying to upsert my embeddings into PostgreSQL. I've done this many times successfully with version 2, but in version 3 I’m getting the following error:

Status: 500
Error: documentStoreServices.insertIntoVectorStoreMiddleware - Error: documentStoreServices.insertIntoVectorStore - Error: documentStoreServices._insertIntoVectorStoreWorkerThread - Error: Error inserting: Seite 2 von 2

Notes:

• I'm using text-embedding-ada-002, and I've created vectors with a dimension of 1536, which is compatible with this model.

• There are no issues with my PostgreSQL connection.

• Based on my research, I believe the issue may be related to changes on the Flowise side in version 3.

Has anyone else encountered this? Any guidance or insight would be greatly appreciated.

Thank you in advance!

[omerbykbs]

I figured it out. Flowise V3 expects the column name to be pageContent. This was not the case in the previous version. Perhaps someone else may need this information.