Related to Database and tmap

[Anonymous]

its my simple jobSQL servertmap testing 

hi, this screenshot are explaining to enough what am facing. job is running without any error still am not getting any output. there is any else suggestion so that i can complete my task please share. 

[Anonymous]

when testdate is 2018-03-14  am getting this 

[dasari16]

well, place tlog between tmap and output component and if you are able to see the records in tlog then it means the records are not being commit to DB. look at the batch size & commit number.

[Anonymous]

@desari16 there are clearly 7640 records coming out of the tMap. I guarantee the tLogRow would have printed 7640 rows of data to the output.

[Anonymous]

 

 sir tLogRow console is empty.

[Anonymous]

That is strange, but I notice the job is not saved (the * by the name). What version are you using? I've seen the situation before when you make a change and run it without saving.... but that was a long time ago. Does the same thing happen after you force a save?

[dasari16]

Lets break the job to debug.

1) Are you referring to the same host details in both the places (with in ETL job and from SQL server management console)?
2) Manually insert 1 record into table using insert statement and if success.
3) Take off the active expression and parse expression from your tmap and run the job to insert into DB. Check the data from management console
4) If job runs successful add your each condition in active expression and run again.
5) As said by @rhall make sure you have saved your job with changes.

Kindly do provide Talend version and screen shot's.

[Anonymous]

its true am not saved my job but am notice if tLogRow has any value comes from any input it keeps but there is not any value.  now what i will do so that i can achieve my target .

Thank you

[Anonymous]

Ah.... this could be your tMap config. Can you check the row name going into your tMap is the same as your row name preceeding the column names you've specified in your tMap output table.