Loading data in to another db while on first db error

[Anonymous]

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.

[manodwhb]

@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

[Anonymous]

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.

[manodwhb]

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


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

[Anonymous]

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.

[manodwhb]

@kolen,on which component you are getting error?

[Anonymous]

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

how to make a DB component error.

[manodwhb]

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

[Anonymous]

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

[Anonymous]

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.