Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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.