Can DB Generic Ouput adapter be used in "warehouse" mode?

44 Views

Hello,

I'm using Greenplum (Generic DB Output adapter in ESP) and started getting this response now after a few million

records are in my target table :

ConnectionWriter(ESPToDbTableB) is started.

2014-05-27 16:42:26.301 | 20622 | container | [SP-3-100005] (2468.241) sp(3349) Error executing SQL statement select * from wh._esp_b_stream. java.lang.OutOfMemoryError: GC overhead limit exceeded

2014-05-27 16:42:26.301 | 20622 | container | [SP-3-148011] (2468.241) sp(3349) ConnectionWriter(ESPToDbTableB) connection reset error: 2014-05-27 16:42:26 DBOutput_Adapter::resetConnection - executeQuery not successful - resetConnection() ended abnormally

The adapter is connected to a Stream in my ESP project, but only recently. Previous to being a Stream, it was a Flex Window. I would like

simple - blind inserts from the ESP project.....but it appears the adapter does not know this and is trying to pull in the entire contents of the table before

initializing and getting started.

Any advice greatly appreciated, as usual.

Thank you

Michael