One Star

Vertica Output Update Error

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
6 REPLIES
Moderator

Re: Vertica Output Update Error

Hi,
What's your talend build version and Vertica Version? Is it OK with you when re-create a same job?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Vertica Output Update Error

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
Moderator

Re: Vertica Output Update Error

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Vertica Output Update Error

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
Moderator

Re: Vertica Output Update Error

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Vertica Output Update Error

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