Job complied but unable to run

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
egosz
Participant
Posts: 9
Joined: Sat Mar 12, 2005 7:49 pm
Location: Melbourne

Job complied but unable to run

Post by egosz »

Hi guys

I am currently getting trouble with a server job which basically does feeding the table in Oracle database with a fixed-width data text file.

I currently have two projects at my DS server. The strange thing here is that the above job was compiled and run successfully within the first project, but exactly the same job was compiled with no error but be unable to run. When i run in DS Director its status is still compiled, not fail as therefore no log to examine the cause.

Any thoughts would be appreciated.

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

That is rather odd. My first thought is that this is a multi-instance job and your log filters are set such that you don't see the instances; a rather unlikely scenario. If you put these two lines into your server job control what happens?

Code: Select all

   $INCLUDE DSINCLUDE JOBCONTROL.H
   CALL DSLogWarn("I am in the jobcontrol!","")
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Post by kollurianu »

What is an multi instance job?

any answers appreciated,

Thank you,.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please start a new thread rather than hijacking someone else's. Thanks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
What is your input source in the job?

Ketfos
egosz
Participant
Posts: 9
Joined: Sat Mar 12, 2005 7:49 pm
Location: Melbourne

Post by egosz »

The input source of the job is a sequential file with delimiter ",".

Cheers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

egosz,

did you put the 2 lines in your job and run it?
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
as ArndW said ODD !
Just to be sure check that you didn't run it in 1 project and looked in the other's log entries?!
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply