topic Postgresql CDC Error in Talend Studio

Postgresql CDC Error

_AnonymousUser — Thu, 30 Jun 2016 08:37:34 GMT

Hi,
I am creating a sample CDC on greenplum DB using postgres components but i i am facing issue on running mapping after creating CDC on the table. Please suggest about below issue.
Exception in component tPostgresqlOutput_3
org.postgresql.util.PSQLException: ERROR: function cannot execute on segment because it issues a non-SELECT statement (functions.c:135) (seg19 alpsdw5gp1dev.idc.ge.com:1028 pid=451468) (cdbdisp.c:1326)
Detail:
SQL statement "INSERT INTO "prod_test"."TCDC_films_test" ( "TALEND_CDC_SUBSCRIBERS_NAME", "TALEND_CDC_STATE", "TALEND_CDC_TYPE", "TALEND_CDC_CREATION_DATE", "code" ) SELECT "TALEND_CDC_SUBSCRIBER_NAME", '0', 'U', CURRENT_TIMESTAMP, $1 FROM "prod_test"."TSUBSCRIBERS" WHERE "TALEND_CDC_TABLE_TO_WATCH"='prod_test.films_test'"

Re: Postgresql CDC Error

Anonymous — Fri, 01 Jul 2016 03:27:27 GMT

Hi,
Did you follow up document about: TalendHelpCenteretting up a CDC environment to set up CDC environment for your Postgresql DB?
Could you please on which build version you got this issue?
Best regards
Sabrina

Re: Postgresql CDC Error

_AnonymousUser — Fri, 01 Jul 2016 10:47:21 GMT

Hi Sabrina,
Thanks for the response.
I am using Talend 5.6.1 version.
I am trying to perform CDC on trigger mode and followed the provided link.Database in greenplum database as the greenplum database doesn't have direct component like oracle (tOracleCDC), I am using tPostgresqlCDC. Created CDC connection and established table schemas along with TSUBSCRIBERS, as mentioned in the link tried to "view all Changes" no rows are found,