Director error with a particular folder only

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Director error with a particular folder only

Post by satish_valavala »

We are getting the following error when we try to open/refresh the DS Director for a particular folder only. Its fine with the rest of the folders.

Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DEV_my_proj
(Subroutine failed to complete successfully (30107))
Regards
VS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sounds like the project may need re-indexing (using DS.REINDEX ALL next time you can get exclusive access to the project).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Post by satish_valavala »

DS.REINDEX ALL didn't worked out. Problem still exists , even after running DS.REINDEX ALL (as an admin) . Any idea.
Regards
VS
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You have to ensure you have exclusive access to the Project - no running jobs, no orphaned client connections - nothing other than you can be in / connected to the project - or it won't work. Did you?
-craig

"You can never have too many knives" -- Logan Nine Fingers
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Re: Director error with a particular folder only

Post by John Smith »

satish_valavala wrote:We are getting the following error when we try to open/refresh the DS Director for a particular folder only. Its fine with the rest of the folders.

Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DEV_my_proj
(Subroutine failed to complete successfully (30107))
If the REINDEX didn't work even after you did it in exclusive access mode, you might have to reimport that folder from a backup.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

did you notice any error or warnings during ReIndexing.
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Post by satish_valavala »

I didn't noticed any warnings during Reindexing.
Regards
VS
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

Post by satish_valavala »

I didn't noticed any warnings during Reindexing.
Regards
VS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How carefully did you look? Did you capture the output (for example using COMO) for later inspection?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply