Loading

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

Data pubblicazione: Apr 13, 2024
Descrizione

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. 
Risoluzione
Configure the PostgreSQL "Pooling mode" to "session", as described here.
Numero articolo Knowledge

001472522

 
Caricamento
Salesforce Help | Article