DSXchange

Hi,
I'm getting the error "Error in retrieving stage property values
DSTAGE-SORT-0041`:`Directory already existing" during run time. This is happening intermittently. I can understand some problem in doing the sorting but not able to guess the root cause. Kindly help me in getting the root cause.

Job Design: OracleConnetor -> Sort Stage -> Transformer -> HashFiles
Sort stage properties:
Sort Spec: C1 asc, Col2 asc
max rows in Virtual memory: 100
Temporary Directory: <blank>
Escape Character: \
Tracing Level:0
Stable Sort: no
Column Separator: ,
max open files: 10

Thanks & Regards,
Poovalingam.

So... only in this one job or any job with a Sort stage?

This is the only server job having sort stage in it in the project. All other jobs are parallel jobs. But I created a new server job with a sort stage and it is running fine. This problem is not occurring at everytime. Sometime running fine but sometime not.

Just a guess but try supplying an actual directory for the 'Temporary Directory', one it could use as scratch space.