We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Postgresql Simba driver connection errors from Alteryx Server 2023.2

iannCambia1
6 - Meteoroid

We have scheduled workflows executing read queries from PostgreSQL database using a Simba driver-enabled Gallery connection.

 

Occasionally, the workflow fails with the following message:

 

Error - ToolId 89: Error SQLPrepare: [Simba][PostgreSQL] (20) Error occurred while trying to prepare a query: [SQLState 26000] ERROR:  prepared statement "PGODBCStmt--<various numbers here>" does not exist

 

Most often, when we simply re-execute the workflow, it runs successfully.

 

Any recommendations to stop the errors?

1 REPLY 1
apathetichell
20 - Arcturus

hmmm. you can turn on logging at the ODBC level in ODBC 64 on the Server -> I'd also check - is the query using a stored procedure or user defined function. Is the user permissions the same for both the user executing the workflow on Desktop - and the user executing on the Server? This sounds like something which should be creating logs on the Postgres end - and I'd look there first.