Exception in SCD component for MYSQL



  While executing a job (oracle -> mysql data transfer), it is showing following error.

 “Exception in component tMysqlSCD_1

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `dw_product_scd`' at line 1”

It is showing error in code generated by tool.

Kindly help with the resolution of this error.




avshah2's picture
Joined: Jan 28 2010 - 4:26am
Last seen: 9 years 8 months ago

1 Answer:


Hi Amit,


As you can see from the error, there is a problem with your MySQL synthax. THere is no way to solve the issue without looking at the SQL and probably the whole job.

Try to check what can be wrong with the SQL synthax by checking with the SQL manuals. If you cannot solve the issue you may want to export and attach the job here so I can try and test it.




stasp's picture
Joined: Jun 3 2009 - 9:53am
Last seen: 4 days 22 hours ago