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.