check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Anonymous — Sat, 16 Nov 2024 02:23:45 GMT

Hi,

Am try to create a dim table and insert the data using tmysqlscd type1 component,when i run the job table will be created and only one row has been inserted and also getting the following error message has been displayed.

Starting job dim at 17:21 19/05/2020.

[statistics] connecting to socket on port 3710
[statistics] connected
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 '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[statistics] disconnected

Job dim ended at 17:22 19/05/2020. [exit code=0]

i have 16 unique values but only one record has been inserted,but i want to insert those 16 unique values,

for your reference 3 screenshot has been added.

how to solve those two issue,please assist me......

Re: check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

manodwhb — Fri, 22 May 2020 06:11:15 GMT

@Dhandu502 , You are missing sourcekeys. please check the below link.

https://help.talend.com/reader/r_2sHfaW~Sj8~uR2mko5iw/rjT7TYPqnYE7~ss1nRHZzg

topic Re: check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in Talend Studio

check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Re: check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1