#1 2009-11-24 12:40:29

Elnourso
Member
Registered: 2009-11-09
Posts: 23

GlobalMap and PostJob

Hello,

I haven't found anybody having the same problem :

I have a simple job
MSSqlInput --> tMap --> tDB2Output  --> tDB2Rollback

As I am testing, I do an immediate rollback.

(see image for logging)

Appearently, this does not fill/increment the globalMap values I need to log.
In tJava_1 linked (to the tPostJob_1)  when I  call :

Code:

globalMap.toString()

I see these values in the globalMap variable :

Code:

{
tDB2Output_1_NB_LINE=0,    
tDB2Output_1_NB_LINE_UPDATED=0, 
tDB2Output_1_NB_LINE_DELETED=0,      
tDB2Output_1_NB_LINE_INSERTED=0, 
tLogRow_CONSOLE=java.io.PrintStream@1c86be5, 
tMSSqlInput_1_QUERY=SELECT TOP 3..... FROM    dbo.xxxx, 
tUnite_1_NB_LINE=3, 
tJava_1_SUBPROCESS_STATE=0, 
tMSSqlInput_1_NB_LINE=3, 
tPostjob_1_SUBPROCESS_STATE=0, 
tLogCatcher_1_SUBPROCESS_STATE=1, 
tLogRow_1_NB_LINE=3
}

==> remark that there are no rejects listed, although I see them outputted as needed in the tLogRow_1 (prefixed "REJECTED" wink )

==> My question is : how can I get the processed lines amounts to put them in my tBufferOutput_1 (I know there are records processed and rejected, as I see them pass in the tLogRow_1 coponent), as these are fed at the end of the job.


Thank you so much in advance for the quickest winner smile

NOTE : I tried with a subjob, and it even don't get those values in globalMap.


Uploaded Images

Last edited by Elnourso (2009-11-24 12:41:11)

Offline

#2 2009-11-24 13:28:57

Elnourso
Member
Registered: 2009-11-09
Posts: 23

Re: GlobalMap and PostJob

For your peace of mind :p

I checked and in the tPostJob,  I don't get to the job variables nb_line_tDB2Output_1, nb_line_inserted_tDB2Output_1, nb_line_update_tDB2Output_1...

snifff...

Offline

#3 2009-11-26 12:22:58

Elnourso
Member
Registered: 2009-11-09
Posts: 23

Re: GlobalMap and PostJob

Little "up"...

Offline

#4 2009-11-26 13:43:14

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: GlobalMap and PostJob

Hello

I checked and in the tPostJob,  I don't get to the job variables nb_line_tDB2Output_1, nb_line_inserted_tDB2Output_1, nb_line_update_tDB2Output_1...

From your image, i see there only 3 rows pass to tDB2Output and you get 3 reject output, so the global vars nb_line is 0 or null, it is normal.
nb_line_inserted_tDB2Output_1 counts the number of inserted rows.
nb_line_updated_tDB2Output_1 counts the number of updated rows.

Best regards

         shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#5 2009-11-26 14:21:03

Elnourso
Member
Registered: 2009-11-09
Posts: 23

Re: GlobalMap and PostJob

Thank you shong,

I thought that nb_line would contain all the lines, even rejected.

I'll see then without auto-rollback what this will do...

Cheers,

Offline

Board footer

Powered by FluxBB