Records not inserted into mysql table

One Star

Records not inserted into mysql table

Hello all,
Doing a relatively simple move from PostgreSQL into MySQL, though the operation is successful it does not insert any record into the specified MySQL table.
Testing talend as a new ETL tool and i'm still navigating my way around all its' functionality. I'll appreciate any help.
Thank you all.

Seventeen Stars

Re: Records not inserted into mysql table

At first take care the option Die on error is on. Now you can spot probably errors.
Next, if you use a separate tMysqlConnection take care you also use tMysqlCommit triggered with OnSubjobOk starting with the first component in the last writing flow.
For more help, please post a image of your job, so we can spot further possible pitfalls.
One Star

Re: Records not inserted into mysql table

I thought i posted this with my original post. Yes the option "die on error" is on.
 Many thanks for your time.

Seventeen Stars

Re: Records not inserted into mysql table

Ok, now the image is visible. I take a look at it.
I would say, this is fairly straight forward and should work. Do you see some error messages in the Job console window. I would bet you will see some.
One Star

Re: Records not inserted into mysql table

No errors - below is the output from the job console window.
Starting job DataLoadMySQL at 14:01 02/10/2014.
connecting to socket on port 3726
connected
disconnected
Job DataLoadMySQL ended at 14:01 02/10/2014.
Seventeen Stars

Re: Records not inserted into mysql table

GO to the Job view and here to the register Extras&Logs and switch on Log output.
What do you have set as Action on data?
One Star

Re: Records not inserted into mysql table

Action on data is set to "insert".. I deleted the table.
Seventeen Stars

Re: Records not inserted into mysql table

The only possible explanation is you have managed to avoid showing log output ;-). Currently I do not have any idea what could be wrong in your job. I would start debugging in such - seldom - case.
I do usually much more complex things with a MySQL database, so I am a bit at loss with your problem. You could post the component settings of the output component, perhaps this brings more light in your issue.
One Star

Re: Records not inserted into mysql table

I just posted the component settings of the output component.
Seventeen Stars

Re: Records not inserted into mysql table

Sorry, the resolution of your picture is by far to low to spot anything on it. Please use a bit higher solution.
I see you use an separate connection for the output component and the flow does not trigger anything after it. Please trigger with OnSubjobOk starting from your input component a tMysqlCommit. Now it is clear, you write and write and does nothing with the connection, not commit or close. Of course you will not see any data in your table.
It looks like you have added the connection somewhere on your job without handling the possibility of failure.
I would trigger from the tMysqlConnection with OnSubjobOk your flow (connect the trigger to the start component of your job).
We would have a much quicker solution of your problem if would have posted the whole picture of yur job and not only a snippet.
One Star

Re: Records not inserted into mysql table

Beautiful - Many thanks. Works well now, learning curve.
I've moved data into a MongoDB and didn't have to, assumed wrongly.
Thank you again.
Seventeen Stars

Re: Records not inserted into mysql table

Yes the actions in a MongoDB are atomic transactional. Thats because you do not need an explicit commit. But the MySQL usually works transactional. You can configure the tMysqlConnection also als auto commit. In this case you would not need an explicit commit.