topic Re: Vertica Output Update Error in Talend Studio

Vertica Output Update Error

Anonymous — Mon, 07 Apr 2014 14:44:17 GMT

hi,
Im Getting Following errors:
Exception in component tVerticaOutput_1
java.sql.SQLException: (4856) ERROR: Syntax error at or near "WHERE"
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.tFileInputDelimited_1Process(WTDA_ETL_ipbillReRecievedFileExecution.java:787)
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.runJobInTOS(WTDA_ETL_ipbillReRecievedFileExecution.java:1342)
disconnected
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.main(WTDA_ETL_ipbillReRecievedFileExecution.java:1210)
Caused by: com.vertica.util.ServerException: (4856) ERROR: Syntax error at or near "WHERE"
... 12 more

When i give Action On data as "insert" then there is no error. When I give "Update or Insert" Option above error is coming and job got stopped.
Please Let me know solution for this.
Screen Shots are Added in Post.
Thanks and Regards,
Akshath Hegde

Re: Vertica Output Update Error

Anonymous — Tue, 08 Apr 2014 04:07:08 GMT

Hi,
What's your talend build version and Vertica Version? Is it OK with you when re-create a same job?
Best regards
Sabrina

Re: Vertica Output Update Error

Anonymous — Tue, 08 Apr 2014 05:40:26 GMT

hi,
Thank you for quick response.
Talend Version is : 5.2.2
Vertica Version : 6
and vertica connection with talend working fine, there is no problem in connection. only "update", "insert or update" is giving ERROR.
Regards,
Akshath Hegde

Re: Vertica Output Update Error

Anonymous — Tue, 08 Apr 2014 10:05:44 GMT

Hi,
It seems that all columns in your schema are in the key. Could you please have a try with one key for your update to see if this issue still repro?
Best regards
Sabrina

Re: Vertica Output Update Error

Anonymous — Tue, 08 Apr 2014 10:15:38 GMT

hi,
For one key its working fine. But i needed to use more then one column as key. i Think here its not possible... :-(
Thanks and Regards,
Akshath Hegde

Re: Vertica Output Update Error

Anonymous — Wed, 09 Apr 2014 03:23:31 GMT

Hi tayana_akki,
Could you please take a testing on talend latest version 5.4.1. I have made a testing on 5.4.1, everything is going well.
Feel free let me know if it is OK with you.
Best regards
Sabrina

Re: Vertica Output Update Error

_AnonymousUser — Tue, 12 Aug 2014 09:55:38 GMT

I'm getting this same behaviour with PostgreSQL,
tPostgresqlOutput, all columns marked as keys in
the schema, with both Update or insert and Insert
or update. If one or more columns are not keys,
the problem disappears.
I'm running TOS for Big Data (5.6.0.M1-r118307).
I made a new topic for PostgreSQL here:

JB