topic Re: Talend New Job Error in Talend Studio

Talend New Job Error

Anonymous — Wed, 14 Aug 2013 12:46:15 GMT

Hi,
When execute a new job, i have got the below error message.
Please find the attached screen shot.
So Please let me know, In which situation the below mentioned error appear.
"Starting job bpcateg at 16:57 14/08/2013.

connecting to socket on port 3718
connected
Exception in component tMSSqlInput_1
java.sql.SQLException: Incorrect syntax near the keyword 'VALUES'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
at migaration.bpcateg_0_1.bpcateg.tMSSqlInput_1Process(bpcateg.java:3595)
at migaration.bpcateg_0_1.bpcateg.runJobInTOS(bpcateg.java:7446)
at migaration.bpcateg_0_1.bpcateg.main(bpcateg.java:7312)
disconnected
Job bpcateg ended at 16:57 14/08/2013. "
Thanks
Siva

Re: Talend New Job Error

djugal — Wed, 14 Aug 2013 14:14:53 GMT

the sql seems incorrect in the input component can you show me the query of that component

Re: Talend New Job Error

Anonymous — Wed, 14 Aug 2013 15:48:27 GMT

Hi,
Please find the attached screen shot of the SQL query.
Thanks
Siva

Re: Talend New Job Error

Anonymous — Wed, 14 Aug 2013 21:19:22 GMT

It looks like the identifier VALUES matchs with a reserved word.
Put that identifier into double quotas ARCOS."VALUES" should work.

Re: Talend New Job Error

Anonymous — Wed, 28 Aug 2013 07:05:36 GMT

hi
i am getting error as incorrect syntax near the keyword 'order' but not showing any error symbol on any components.For information order is my target table.
can anyone help me out to resolve this issue.

Re: Talend New Job Error

alevy — Thu, 29 Aug 2013 14:45:46 GMT

"order" is a SQL key word so, if that is your table name, you need to delimit it with double-quotes. Since double-quotes have a specific meaning for Java (being to delimit a string), you will also need to escape the double-quotes with a back-slash.
In the tOutput component, make the table name: "\"order\""