Four Stars

Loading data in to another db while on first db error

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.

11 REPLIES
Twelve Stars

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

@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

Manohar B
Four Stars

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

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.

Twelve Stars

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

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


input-->tmap->outputdb--->oncomponent error--->input-->tmap->outputdb2
Manohar B
Four Stars

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

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.

Twelve Stars

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

@kolen,on which component you are getting error?

Manohar B
Four Stars

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

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

how to make a DB component error.

 

Twelve Stars

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

On the DBOutput component enable Die on error in Basic settings.
Manohar B
Four Stars

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

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

Four Stars

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

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.

 

Twelve Stars

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

@kolen,you can implement in below way.

 

 

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

Manohar B
Four Stars

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

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.