dsjob (-jobinfo works, but -run does not)

perfman · Post by **perfman** » Thu Mar 27, 2008 5:27 pm

This is what I have tried:

[dsadm@perf MyProject]$ pwd
/opt/IBM/Ascential/DataStage/Projects/MyProject

[dsadm@perf MyProject]$ /opt/IBM/Ascential/DataStage/DSEngine/bin/dsjob -jobinfo "MyProject" testseq
Job Status : NOT RUNNING (99)
Job Controller : not available
Job Start Time : Fri Mar 28 10:03:39 2008
Job Wave Number : 0
User Status : not available
Job Control : not available
Interim Status : NOT RUNNING (99)
Invocation ID : not available
Last Run Time : not available
Job Process ID : 0
Invocation List : testseq

Status code = 0

[dsadm@perf MyProject]$ /opt/IBM/Ascential/DataStage/DSEngine/bin/dsjob -run "MyProject" testseq
Error running job

Status code = -99 DSJE_REPERROR
[dsadm@perf MyProject]$

chulett · Post by **chulett** » Thu Mar 27, 2008 5:35 pm

Does it work properly if you pass in the user credentials on the command line?

perfman · Post by **perfman** » Thu Mar 27, 2008 6:08 pm

I have tried a number of variations of that, but no it does not seem to work:

[dsadm@perf MyProject]$ /opt/IBM/Ascential/DataStage/DSEngine/bin/dsjob -user dsadm -password mypwd -jobinfo "MyProject" testseq
ERROR: Failed to open project

Status code = 81011
[dsadm@perf MyProject]$

I'm pretty sure I am authenticating properly because other wise I don't see how I could get the jobinfo, also when I try and "run" a job that does not exist I get a different error than when I try and run a job that does exist.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 7:29 pm

What happens if there are no quotes around the project name?

perfman · Post by **perfman** » Thu Mar 27, 2008 7:57 pm

It appears that there is no difference to any of these commands when ran with or without the quotes around the project

chulett · Post by **chulett** » Fri Mar 28, 2008 7:10 am

You don't need the quotes. The 'failed to open Project' only happens when it can't authenticate you from what I've seen, hence my request. Note that when you pass in '-user' and '-password' you must also include the '-server' option as well, even if you are currently on that same server.

So...

Code: Select all

$ dsjob -server MyServer -user dsadm -password mypwd -jobinfo MyProject testseq 

$ dsjob -server MyServer -user dsadm -password mypwd -run MyProject testseq

ArndW · Post by **ArndW** » Fri Mar 28, 2008 8:00 am

Try adding "-mode NORMAL"

perfman · Post by **perfman** » Fri Mar 28, 2008 2:51 pm

@ Chulett > Sure it sounds like a valid test. I successfully connected using user credentials after adding the server. However did not solve the problem. I can get jobinfo but not run a job.

@ ArndW > Thanks I tried it, but no luck

[dsadm@perf MyProject]$ $DSHOME/bin/dsjob -run -mode NORMAL "MyProject" testseq
Error running job

Status code = -99 DSJE_REPERROR

chulett · Post by **chulett** » Fri Mar 28, 2008 4:04 pm

That really makes no sense. It should be working fine for you, not really sure what in the heck we are missing. At this point, all I can think to suggest is to open a case with your official Support provider and see if they can shed any light on this. Sorry.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2008 5:04 pm

Is the job successfully compiled?

chulett · Post by **chulett** » Fri Mar 28, 2008 5:12 pm

I assumed successfully compiled and run before this. Would -jobinfo work on an uncompiled or 'unsuccessfully compiled' job?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2008 9:51 pm

Why not? DSGetJobInfo() does.

chulett · Post by **chulett** » Sat Mar 29, 2008 6:09 am

Ah... ok, just wondering as for some reason it seemed reasonable to me that it might not and I didn't recall ever specifically testing that. [shrug]

However, jobinfo is returning a 99 - not a 98 - so that should mean it is compiled.

perfman · Post by **perfman** » Sun Mar 30, 2008 1:27 am

I just double checked and yes it is compiled, also job runs with no errors or warnings from Designer/Director.

ArndW · Post by **ArndW** » Sun Mar 30, 2008 3:09 am

Are you logged in at UNIX with the same userid as you used to compile the job? If you create a dummy job (Column Generator -> copy stage) and compile that, can you run that one from the command line?