Checking Operator Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudharma
Participant
Posts: 55
Joined: Wed Jan 24, 2007 10:28 am

Checking Operator Error

Post by sudharma »

Hi everyone ,

I get this Error when i run a job .

seq_rej: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0.

i really dont understand what this error means exactly. can anyone guide me how to work on this warning message when i run this job

thanks a lot
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Your job asks to preserve partitioning. A Sequential File that is writing must collect all partitions into a single stream and therefore can not preserve partitioning.

In the stage that precedes (feeds) the Sequential File stage, check the value of the Preserve Partitioning flag. Set it to "Clear".

Make sure also that the execution mode of the Sequential File stage is sequential, not parallel.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
koolnitz
Participant
Posts: 138
Joined: Wed Sep 07, 2005 5:39 am

Post by koolnitz »

Make sure also that the execution mode of the Sequential File stage is sequential, not parallel
Ray, does a sequential file stage support Parallel execution mode? I've never seen this option changeable - it's always greyed out (no-change mode) in all the sequential file stages used in my project. Do we need to change some setting to enable this option?

Thanks in advance!
Nitin Jain | India

If everything seems to be going well, you have obviously overlooked something.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A Sequential File stage supports parallel execution when reading multiple files. If you have only one File property and have not selected multiple readers per node, the parallel option will be disabled.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
koolnitz
Participant
Posts: 138
Joined: Wed Sep 07, 2005 5:39 am

Post by koolnitz »

seq_rej: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0.
I see. Got confused because the OP mentioned about the Seq file stage used as a target. I believe what you just explained is applicable to seq file stages used as source.

Thank you!
Nitin Jain | India

If everything seems to be going well, you have obviously overlooked something.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Even when used as a target a Sequential File stage may have multiple File properties, writing to different files. In this case it will execute in parallel mode unless constrained to do otherwise.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply