topic ERROR in Talend Studio

ERROR

Anonymous — Sun, 08 Apr 2018 21:34:13 GMT

Hi,

I tried to excute a job but i got this error :

ERREUR: erreur de syntaxe sur ou près de « WHERE »Exception in component tPostgresqlOutput_1 (c)
org.postgresql.util.PSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at pfe_test2.c_0_1.c.tFileInputExcel_1Process(c.java:1519)
at pfe_test2.c_0_1.c.runJobInTOS(c.java:1970)
at pfe_test2.c_0_1.c.main(c.java:1819)

Any solution please ?

Re: ERROR

Anonymous — Mon, 09 Apr 2018 03:10:38 GMT

Hello,

Could you please upload your current job design screenshots on forum which will be helpful for us to address your issue quickly?

Best regards

Sabrina

Re: ERROR

manodwhb — Mon, 09 Apr 2018 08:04:54 GMT

@charfedinee,there is a syntax error in the tPostgresqlOutput_1,please checn the settings of tPostgresqlOutput_1.

Re: ERROR

Anonymous — Mon, 09 Apr 2018 12:42:25 GMT

Here you go !

Thanks for your reply

Capture.PNG

Re: ERROR

Anonymous — Mon, 09 Apr 2018 12:44:35 GMT

I'm kinda new to talend so if you kindly please show me how to check !

Re: ERROR

manodwhb — Tue, 10 Apr 2018 01:44:57 GMT

Can you share the tPostgresqloutput component settings?

Re: ERROR

Anonymous — Tue, 10 Apr 2018 07:30:10 GMT

Hello,

Please mask your sensitive data before posting your tPostgresqlOutput component setting screenshot on forum.

Best regards

Sabrina