topic Re: Loading data in to another db while on first db error in Talend Studio

Loading data in to another db while on first db error

Anonymous — Mon, 06 Aug 2018 07:06:55 GMT

Hi Team,

I am using TOS. I need to load the data into another DB when an error occurs in the first DB, the total data has to be loaded into another DB while error. I tried using on component error load data into another db.But I failed in doing on component error.

input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2.where am stepping wrong.

Any other approach would be appreciated and helpful to me.

Thanks in advance.

Re: Loading data in to another db while on first db error

manodwhb — Mon, 06 Aug 2018 07:11:44 GMT

@kolen,you need to take the reject data from the first table means you need to follow the below way.

input-->tmap->outputdb--->Reject --->tmap->outputdb2

Re: Loading data in to another db while on first db error

Anonymous — Mon, 06 Aug 2018 07:16:25 GMT

Thanks for the Quick reply.

No sir. if DB fails in loading... the complete data has to load into another db.this is not about the rejected records.

if DB fails in any cause. the job should not terminate, instead, it should load into another db.

Re: Loading data in to another db while on first db error

manodwhb — Mon, 06 Aug 2018 07:29:31 GMT

Then go with this approach. are you getting any error?

input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2

Re: Loading data in to another db while on first db error

Anonymous — Mon, 06 Aug 2018 07:54:54 GMT

Yes, am getting an error.

like I took one "id" which is primary and passing null values which are throwing errors..but the job is getting exit. instead, it should flow to another job.

any idea! please suggest.

Re: Loading data in to another db while on first db error

manodwhb — Mon, 06 Aug 2018 07:56:47 GMT

@kolen,on which component you are getting error?

Re: Loading data in to another db while on first db error

Anonymous — Mon, 06 Aug 2018 08:18:06 GMT

I am getting a warning message. but the job is successful

how to make a DB component error.

Re: Loading data in to another db while on first db error

manodwhb — Mon, 06 Aug 2018 08:22:07 GMT

On the DBOutput component enable Die on error in Basic settings.

Re: Loading data in to another db while on first db error

Anonymous — Mon, 06 Aug 2018 10:57:11 GMT

Thank you for the idea.

can u please elaborate. the scenario to get the DB error.so that the flow should go to the 2nd DB

Thank you

Re: Loading data in to another db while on first db error

Anonymous — Thu, 16 Aug 2018 15:06:16 GMT

Hi Sir,

my req. is, if one DB is down at the time of insertion the flow of insertion at the particular record the insertion of that record should go to the other DB.with out fail.

Can u please suggest any idea...

Thanks in advance.

Re: Loading data in to another db while on first db error

manodwhb — Fri, 17 Aug 2018 05:52:28 GMT

@kolen,you can implement in below way.

input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2

Re: Loading data in to another db while on first db error

Anonymous — Fri, 17 Aug 2018 11:01:10 GMT

Thank you!

But I already applied this approach...but here again, the input has to read and load into another db.

But my req is not like that, while insertion if server down at particular record the records should insert into another DB.ie...while insertion if a server is down in db1 the rows should continue in inserting in db2...if server is up it should continue in db1 like that...the job should not stop till all rows got inserted.

Re: Loading data in to another db while on first db error

manodwhb — Tue, 11 Sep 2018 08:49:27 GMT

@kolen,try this way.

input-->tmap->outputdb--->rejects-->outputdb2