Loading

PostgreSQL Extracts Fail to Refresh with Error "Connectionless Failure: ERROR: prepared statement "S_2" already exists"

Date de publication: Apr 13, 2024
Description

Extract refreshes for Postgres data sources may fail with the following error:

"Connectionless Failure ( status code = 10000, ERROR: prepared statement "S_2" already exists Unable to connect to the PostgreSQL server "". Check that the server is running and that you have access privileges to the requested database. )"

Cause

PostgreSQL database pooling is misconfigured for Tableau. 
Résolution
Configure the PostgreSQL "Pooling mode" to "session", as described here.
Numéro d’article de la base de connaissances

001472522

 
Chargement
Salesforce Help | Article