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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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