Page 1 of 1

Error in sequential file

Posted: Tue May 15, 2007 3:01 am
by sjordery
Hi all,

I am getting the follwing error(warning msg) in the sequential file(out put) while running.
-----------------------------------------------------------------------------
Sequential_File_31: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
-----------------------------------------------------------------------------
my design approach is like this

seq_file----->transformer--------->sort----------------->seq_file_31

The partioning method in the out put seq file is by default auto.
Then what the error is exctly saying?

Posted: Tue May 15, 2007 3:58 am
by Maveric
In the sort stage set the preserve partitioning property to clear from the drop down.

Posted: Tue May 15, 2007 4:17 am
by sjordery
Thanks Maveric its working fine nw.
Can you please specify what was the problem?

Posted: Tue May 15, 2007 4:19 pm
by ray.wurlod
The Sort stage previously had its preserve partitioning flag set to the default, namely Preserve. This instructs the downstream stage to try to preserve the partitioning of the data that entered the Sort stage.

Since the downstream stage is perforce required to operate in sequential mode, it is unable to do so, and therefore generates the warning and applies a collector to the data.

Setting the preserve partitioning flag to Clear removes the requirement to ask the downstream stage to preserve partitioning, so it can apply the collector without generating the warning.

If you want the entire data to remain sorted, open the Input link to the downstream Sequential File stage and change the Collector type to Sort Merge.