Db connection working but MySql not show output

[Anonymous]

hi

i have two database. first established in godaddy server and second is Mysql that in my PC. godaddy server contain all medical data storage according to our requirement. right now i want to move a particular date data move on my MySql workbench.  My job is working fine there is no error but there are some case when am confused whats going on .....

 1. if i will move particular date only than in my MySql some rows display. after that i execute again Sql command (select * from newread ); my database values differ .its value always fluctuate.

2. in Active express filter i will use any condition than Talend will not say any error but its does not show any output too.

Kindly share your information.

in this screenshot am using row1.TotalTestCount>=100 . in reality it exists in my  godaddy server, its has value.

sometime tmap indicate error but it properly move data. 

[Anonymous]

You need to show us the error you get in the output window

[Anonymous]

am not getting any error. only Error symbol indicate like this. its fetch data but in my database not reach. 

[Anonymous]

data not reach from godaddy server to mySql in some case. some time data move here to there.

[Anonymous]

Hey,

Run log would be really helpful to actually understand the issue.

Could you try below:

- Reconfigure a new tMap.

- Check writing data into a file/console for a particular date. Later validate if you are getting expected result. 

if you are good till now...

- activate the output component and check die on error(if not checked)

It seems some of your data not qualifying the target table structure but some does, that's the reason sometime it loads and sometimes it don't.

Regards

[Anonymous]

There will have been an error stack in the output window. We need to know what this says

[vapukov]

in addition to @rhall post - what function in testdate (tMap)?