DSXchange

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

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.

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.

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

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?