DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Poovalingam
Participant



Joined: 30 Nov 2009
Posts: 111
Location: Bangalore
Points: 975

Post Posted: Tue Jun 28, 2016 10:09 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42268
Location: Denver, CO
Points: 217033

Post Posted: Tue Jun 28, 2016 10:31 am Reply with quote    Back to top    

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

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
Poovalingam
Participant



Joined: 30 Nov 2009
Posts: 111
Location: Bangalore
Points: 975

Post Posted: Tue Jun 28, 2016 12:31 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42268
Location: Denver, CO
Points: 217033

Post Posted: Tue Jun 28, 2016 4:39 pm Reply with quote    Back to top    

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

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours