We have a sequence job that was designed in DS Designer named D320_Court_Load_Seq. It consists of 3 jobs -- 1 to extract, one to load to a staging table (in DB2), then the 3rd loads to our production DB2.
The problem is that the 2nd job is not showing up at all in DS Director. It is there in the designer - and when I try to run the job, I get the following error:
Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DB2_DW
(Subroutine failed to complete successfully (30107))
I'm not sure what to do - or what I'm missing and I'm pretty inexperienced, so any help would be appreciated. The more detailed, the better!
Thanks in advance,
Clay
Job not showing up in Director
Moderators: chulett, rschirm, roy
Job not showing up in Director
Clay Heintze
IT-MC
La. Dept of Corrs.
IT-MC
La. Dept of Corrs.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Error calling subroutine: DSR_EXECJOB (Action=5);
Yes, I was able to recompile the 2nd job and it shows up now in Director, however when I try to run the job, I'm still getting the same error message.
Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DB2_DW
(Subroutine failed to complete successfully (30107))
Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DB2_DW
(Subroutine failed to complete successfully (30107))
Clay Heintze
IT-MC
La. Dept of Corrs.
IT-MC
La. Dept of Corrs.
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: Job not showing up in Director
Usually when I get "check DataStage is set up correctly", it is cured by quitting the client program and connecting again. If this is not fixing it for you, then indeed you have a problem in your project, you could try bouncing the DataStage engine, failing that as Craig says, get on the red telephone.Cheintze wrote:Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project DB2_DW
(Subroutine failed to complete successfully (30107))
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant