Error in merging files at Sort stage

Sridhar Sivakoti · Post by **Sridhar Sivakoti** » Wed Nov 28, 2007 4:46 am

Hi,

In one server job having Sequential File ->Sort -> Transformer -> Sequential File stages.

When I am running this job it is taking long time and it is showing in running status only(It's not completing) when I abort the job I am getting below error.

StgFactAftMgrTillCntdwnAS400_SSNMasking..srtPosPrtnrId: Error in merging files
At row 1, link "outsrtPosPrtnrId"
Call to output link returned numeric error code: 17

Please let me know what might be the reason.

Thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Wed Nov 28, 2007 5:29 am

Killing the SORT stage while it still had heap files on the scratch disk was probably the cause.

Try using sort as a Filter command in the Sequential File stage; the Sort stage is substantially slower than the UNIX sort command.

chulett · Post by **chulett** » Wed Nov 28, 2007 8:06 am

How many records are you sorting? How long was 'long time'? The Server Sort stage is not meant for large volumes, leverage your O/S sort instead.

Nagaraj · Post by **Nagaraj** » Tue Jun 28, 2011 3:55 pm

what if even there its is failing, with a segmentation fault error? ???

ray.wurlod · Post by **ray.wurlod** » Tue Jun 28, 2011 4:56 pm

Please confirm that your environment, including version, is identical to that of the original poster. You are hijacking a thread in which the previous post is 30 months old!

Have you researched the possible causes of segmentation fault errors, either here or elsewhere?