Db connection working but MySql not show output

Highlighted
Seven Stars

Db connection working but MySql not show output

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.

 

db_demo.JPGin 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. 

error.JPG

Sixteen Stars

Re: Db connection working but MySql not show output

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

Seven Stars

Re: Db connection working but MySql not show output

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

Seven Stars

Re: Db connection working but MySql not show output

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

 

Four Stars

Re: Db connection working but MySql not show output

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

 

 

Sixteen Stars

Re: Db connection working but MySql not show output

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

Twelve Stars

Re: Db connection working but MySql not show output

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

-----------