MQSeries.net :: View topic

madrox · Posted: Thu May 09, 2019 7:33 am Post subject:

Hi Experts!
I am trying to use the sequence node to get incremental counts of errors that occur while processing a file
Here is what i am trying to achieve
I am reading a text file with multiple rows, reading each row at a time. I used the modeler to define the schema.
I have few validations conditions in a compute node apart from a few schema validations that i defined while modelling the schema. If there is a validation error i propagate the message to a sequence node.
If there is a schema validation the message will propagate from the File input node's catch terminal, i have added a compute node to read the exception and pass through to the same sequence node again.
When the end of file is reached the end of data terminal triggers and i have logic that when IsEmpty is true to override the startofsequence to 0.
I have configured the sequence node as follows
Path to sequence number: default path $OutputLocalEnvironment/Sequence/Number
Start of sequence definition
Literal : 1
End of Sequence definition
Literal : 9223372036854775807
I set the persistence mode to : Persistent

Here is what is happening
When a error occurs the message propagates to the sequence node and the sequence number increments. But when InputLocalEnvironment.File.IsEmpty is True although I explicitly Set the