Sort Stage Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Poovalingam
Participant
Posts: 111
Joined: Mon Nov 30, 2009 7:21 am
Location: Bangalore

Sort Stage Error

Post by Poovalingam »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Poovalingam
Participant
Posts: 111
Joined: Mon Nov 30, 2009 7:21 am
Location: Bangalore

Post by Poovalingam »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply