Pivotal Knowledge Base

Follow

Pivotal Greenplum Error: "Prepared Statement ""xxxx"" does not Exist"

Environment

Pivotal Greenplum: 4.2.x

OS: All Supported OS

Symptom

Pivotal Greenplum reports the error "prepared statement ""xxxx"" does not exist" when loading data with Informatica.

The following is seen in the Greenplum master log:

prepared statement ""xxx"" does not exist

The Informatica error:

SQL Error [
FnName: Execute -- [Infa][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: prepared statement "ST2AAAAC001850" does not exist(File prepare.c;Line 460;Routine FetchPreparedStatement;)
FnName: Execute -- [DataDirect][ODBC lib] Function sequence error].

Cause

The default setting in pg_bouncer is not using session pooling.

Resolution

Set session pooling in pg_bouncer.

Comments

Powered by Zendesk