sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Jun 23rd, 2009

 

I think it depends what you want to do with force_error fuction , it can used to fail the plan if there are data quality issue for example if you want a plan to fail if they are duplicate records in input file , here what you can do is you check for duplicate records in input and put a force error function to fail if there are duplicates in input file.

About the other question regarding the reformat , I think if you have a log port and log port is connect to a flow , the conponents treats malformed delimited records as rejects events and if you set never abort parameter then reformat will not fail. if you set the other option like  abort on first reject , the reformat component will fail.

I not sure from what context you want to use the force_error function. But this function is very useful when you want to fail any plan for data integrity issue which is very important in Data warehosue.

I hope it make sense.

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew 

• Jun 28th, 2009

 

force_error, as the name suggests it works on as to force an error in case of not meeting of any conditions mentioned.

The function can be used as per the requirment.Viz.,

1. If you want to stop execution of graph in case of not meeting a specific condition,say,you have to compare the input and out put records reconcilation and the graph should fail if the input record count is not same as output record count,
"THEN  set the reject-threshold to Abort on first reject" so that the graph stops.

N.B - force_error directs all the records meeting the condition to reject port with the error message to error port.

2.In certain special circumstances, you can also use to treat the reject port as an additional data flow path leaving the component. When using force_error to direct valid records to the reject port for separate processing, you must remember that invalid records will also be sent there. When using force_error for this purpose, "set the reject-threshold to Never Abort" so that the graph doesnot fails and meets the purpose.

Njoi!!
Abhi - fresh as dew!

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Aug 9th, 2009

 

Here you can set the two conditions for the reformat component
1. If you want to fail, set the reject thresold to fail on first reject
2. If don't want to fail , you set never to abort.

Force_error is used to abort any graph if the conditions are not met and you write the error errors records in file and then abort the graphs , this can done in different ways.

Mihira Barik

 Profile Answers by Mihira Barik Questions by Mihira Barik

• Sep 16th, 2009

 

force_error() fuction will not stop the graph, it will write the error message to the error port for that record and will process the next record.

venkat_jaksani

 Profile Answers by venkat_jaksani Questions by venkat_jaksani

• Jun 17th, 2010

 

It will not stop the execution of graph,it will continue with the next records.
It will used especially to send to send the data to an error port when it does not meet the specified condition with error message given in this function. To abort the graph use force_abort function.

shan

• Oct 11th, 2012

 

Forces error and writes the error note..

shan88

 Profile Answers by shan88 Questions by shan88

• Oct 22nd, 2013

 

force error displays the error message upon the failure of the graph,as u r placing never abort, no failure,so no force error.

raja

• Feb 9th, 2015

 

force_error function will not throw any error when we keep the reject threshold as never abort. but it will reject all unwanted records per requirement and will provide you the message.