You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

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 :
globalMap.toString()
I see these values in the globalMap variable :
{
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"
)
==> 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 ![]()
NOTE : I tried with a subjob, and it even don't get those values in globalMap.
Last edited by Elnourso (2009-11-24 12:41:11)
Offline
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
Offline
Pages: 1