Loading

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

Publiceringsdatum: Apr 13, 2024
Beskrivning

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. 
Lösning
Configure the PostgreSQL "Pooling mode" to "session", as described here.
Knowledge-artikelnummer

001472522

 
Laddar
Salesforce Help | Article