Talend New Job Error

[Anonymous]

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

[djugal]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[alevy]

"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\""