Records not inserted into mysql table

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

I just posted the component settings of the output component.

[Anonymous]

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.