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



Group memberships:
Premium Members

Joined: 31 Mar 2006
Posts: 163
Location: Paris
Points: 1245

Post Posted: Wed Jun 08, 2016 11:43 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
Hi gurus
Since a few days we have randomly the following error
failed to open file in datastage status=13
It's happen inside the jobs who wrote and read a file.
The write is ok the read failed.
After the abort we can relaunch the job and it works.
Can you help me ?
Thank you

_________________
Hope This Helps
Regards
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Wed Jun 08, 2016 5:07 pm Reply with quote    Back to top    

Check the permissions on the file and its parent folder, and determine under which user ID the jobs run (you may also need to check group membership).

Bonne chance!

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne

Last edited by ray.wurlod on Wed Jun 08, 2016 10:54 pm; edited 1 time in total
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1167

Points: 7709

Post Posted: Wed Jun 08, 2016 6:46 pm Reply with quote    Back to top    

Cluster environment and your job gets sent to a different host that doesn't have the mount?
Rate this response:  
Not yet rated
thurmy34



Group memberships:
Premium Members

Joined: 31 Mar 2006
Posts: 163
Location: Paris
Points: 1245

Post Posted: Thu Jun 09, 2016 1:29 am Reply with quote    Back to top    

Hi all
Thank you for your answers.
The weird thing is that we can write the file but not open it right after Inside the the same job.

_________________
Hope This Helps
Regards
Rate this response:  
Not yet rated
Teej
Participant



Joined: 08 Aug 2003
Posts: 677
Location: USA
Points: 4844

Post Posted: Thu Jun 09, 2016 12:46 pm Reply with quote    Back to top    

You should not be reading and writing to the same file at the same time. It just does not work well that way due to the locks that we impose while writing to the file.

I would suggest a review of the job design is in order.

_________________
Developer of DataStage Parallel Engine (Orchestrate).
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Fri Jun 10, 2016 12:33 am Reply with quote    Back to top    

Actually, Teej, such blocking operations are perfectly possible, feasible and even normal in server jobs. Put another way, in server jobs a passive stage can have an input link (writing) AND an o ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
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