Postgresql Simba driver connection errors from Alteryx Server 2023.2

Question

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?

apathetichell · Answer

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.