One Star

[resolved] tOracleOutput / NB_LINE_REJECTED

I am testing the variable NB_LINE_REJECTED: ((Integer)globalMap.get("tOracleOutput_1_NB_LINE_REJECTED")) of a tOracleOutput. However it is not clear to me how and when this is triggered. I am receiving ORA-0001 error messages during the run, but the NB_LINE_REJECTED does not seem to respond.
The set-up of sub-job is: tJava --> tFileOutputDelimited
tJava has:
//String foo = "bar";
row28.numberlines = ((Integer)globalMap.get("tOracleOutput_1_NB_LINE"));
row28.inserted = ((Integer)globalMap.get("tOracleOutput_1_NB_LINE_INSERTED")) ;
row28.deleted = ((Integer)globalMap.get("tOracleOutput_1_NB_LINE_DELETED")) ;
row28.rejected = ((Integer)globalMap.get("tOracleOutput_1_NB_LINE_REJECTED")) ;
row28.timestamp = new Date();
NB_LINE and NB_LINE_INSERTED give back values, but not the NB_LINE_REJECTED
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] tOracleOutput / NB_LINE_REJECTED

Thanks a lot. Configuring the tOracleOutput component in the right way has indeed solved this problem.
2 REPLIES
Seventeen Stars

Re: [resolved] tOracleOutput / NB_LINE_REJECTED

This count has only values if in the reject flow is used.
The tOracleOutput component provides an reject flow only if:
1. Die On Error is switch of
2. The batch mode is not in use
3. There is a reject flow in use
One Star

Re: [resolved] tOracleOutput / NB_LINE_REJECTED

Thanks a lot. Configuring the tOracleOutput component in the right way has indeed solved this problem.