Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Postgresql CDC Error

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'"
Labels (2)
2 Replies
Anonymous
Not applicable

Hi,
Did you follow up document about: TalendHelpCenter0683p000009M9p6.pngetting 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
_AnonymousUser
Specialist III
Specialist III
Author

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, 
0683p000009MAsV.png
0683p000009MAkC.png
0683p000009MAkC.png 0683p000009MAlB.png