topic Re: [resolved] tOracleOutput / NB_LINE_REJECTED in Talend Studio

[resolved] tOracleOutput / NB_LINE_REJECTED

Anonymous — Thu, 18 Apr 2013 15:07:13 GMT

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

Re: [resolved] tOracleOutput / NB_LINE_REJECTED

Anonymous — Thu, 18 Apr 2013 16:57:57 GMT

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

Re: [resolved] tOracleOutput / NB_LINE_REJECTED

Anonymous — Fri, 19 Apr 2013 15:23:30 GMT

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