topic Re: Related to Database and tmap in Talend Studio

Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 06:16:53 GMT

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.

Re: Related to Database and tmap

manodwhb — Thu, 15 Mar 2018 07:23:11 GMT

Can you a reject link from output table to text file output and see what are you geeting anything to rejecte file?

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 07:33:40 GMT

i do but am not getting any file in reject list.

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 09:36:06 GMT

you have any other approach to complete my target

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 10:10:08 GMT

7460 rows are getting through your tMap filtering. Are you getting anything in your output window? Are you sure your data is committed?

Something is not being shown here. Are you sure you're querying the correct database?

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 10:20:30 GMT

am sure my data is committed. now am delete my job and meta data too and create again now its working. i don't know whats happen. i want to know what happen, why it is treating like this ?

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 10:27:09 GMT

There will be a reason. Unfortunately you didn't give us enough information. To identify what is wrong it helps to see the configuration of all components and any outputs in the output window.

I have seen this happen when using the wrong context by mistake. You think the data should be in one table but its in another. From what you showed, it looked like around 7000 rows were sent to the database.

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 10:36:23 GMT

sir you can think like this. it may be i did not give enough information. am try my best and check properly which table was committed. am saying there can be another reason behind this yet next time i will share proper information.

Re: Related to Database and tmap

manodwhb — Thu, 15 Mar 2018 11:09:14 GMT

Can you show the configutation of Table output?

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 11:31:09 GMT

SQL outputtmap

am updating but not getting output in SQL DB. Please tell me what i will do ?

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 11:35:34 GMT

when testdate is 2018-03-14 am getting this

Re: Related to Database and tmap

dasari16 — Thu, 15 Mar 2018 13:30:57 GMT

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.

Re: Related to Database and tmap

Anonymous — Thu, 15 Mar 2018 13:36:13 GMT

@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.

Re: Related to Database and tmap

Anonymous — Fri, 16 Mar 2018 05:19:34 GMT

sir tLogRow console is empty.

Re: Related to Database and tmap

Anonymous — Fri, 16 Mar 2018 07:03:08 GMT

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?

Re: Related to Database and tmap

dasari16 — Fri, 16 Mar 2018 07:37:16 GMT

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.

Re: Related to Database and tmap

Anonymous — Fri, 16 Mar 2018 08:51:41 GMT

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

Re: Related to Database and tmap

Anonymous — Fri, 16 Mar 2018 08:54:49 GMT

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.