Status code = -9999 DSJE_DSJOB_ERROR

datisaq · Post by **datisaq** » Wed Feb 24, 2010 1:02 am

I am running a datastage job from the command line as given below:-

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -jobstatus BHDEVCN SampleRun

Where "SampleRun" is job which is not having any parameters.

while running i'm getting the following error:-

Error Status code = -99 DSJE_REPERROR job

I have ran the other jobs also but still the same error.

I tried this command "dsjob -lstages BHDEVCN SampleRun" also
it's correctly listing the stages in the job.

But while running (dsjob -run ) only the error comes...

Can anyone please tell me what might be the issue?

I searched also on the forum but didn't help me to fix the issue...

DS Experts please help me out...

zulfi123786 · Post by **zulfi123786** » Wed Feb 24, 2010 1:31 am

One possibility is that if I create a job with my user id in Designer and the if i try running the job with another id using this command and if the there is no access for the second id to run the created job this happens.

Solution:
Use the same id with which this job was created or if you are able to run the same job in designer with a specific id thed use the same to run using the command.

Also the list of status codes is available in the DataStage Guides, scroll through them for more information

ray.wurlod · Post by **ray.wurlod** » Wed Feb 24, 2010 2:22 am

All DataStage developers should have a umask of 002 and/or the setgid bit should be set on the project directory.

datisaq · Post by **datisaq** » Wed Feb 24, 2010 4:47 am

Thanks Ray for your reply...

Our project is BHDEVCN and the umask is set as "077" for it.

can you please tell me how to set gid for project / umask as 022?

ArndW · Post by **ArndW** » Wed Feb 24, 2010 5:32 am

What is your OS? This can be done in the user setup, or in the user ".profile" by executing "umask 022".

datisaq · Post by **datisaq** » Wed Feb 24, 2010 7:35 am

Hi Arndw,

we are on AIX.

could you tell me what is the command or the process to change the user setup or run the "umask 022".?

datisaq · Post by **datisaq** » Wed Feb 24, 2010 7:37 am

Hi Arndw,

we are on AIX.

could you tell me what is the command or the process to change the user setup or run the "umask 022".?

chulett · Post by **chulett** » Wed Feb 24, 2010 8:00 am

zulfi123786 wrote:This is strange but i am unable to delete this post, Please ignore

Not so strange, rather one cannot delete a post that has been replied to. So if you accidentally 'double post' (which is what I assume happened here) you need to delete the second one.

datisaq · Post by **datisaq** » Wed Feb 24, 2010 11:04 pm

DSExperts please help me out on this issue.......

chulett · Post by **chulett** » Wed Feb 24, 2010 11:42 pm

datisaq wrote:I have ran the other jobs also but still the same error.

And this means what exactly? You cannot run any job as all attempts get this error or everything else runs fine and you get this error only for this particular job?

datisaq · Post by **datisaq** » Wed Feb 24, 2010 11:56 pm

Hi craig thanks for your prompt response...

I cannot run any job from the command line as Ray has suggested to set some privileges..

could you please tell me, what privileges we have to set here..

It'll be really great if you tell me the exact commands...

chulett · Post by **chulett** » Thu Feb 25, 2010 12:18 am

Ray was responding to zulfi123786 rather than you, I believe. Your problem is one of syntax I would wager.

You need to provide full credentials from the command line, meaning userid and password. For 8.x they added in the need for the domain as well, so add all three to the command line and let us know what happens next. For completeness and just to make sure you cover all of your bases, I would add in the -server component as well so there's no doubt what you want to run from where by whom.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2010 1:10 am

I was responding to datisaq and still am.

Check out the permissions on objects in the project directory.

The best place to set umask is in the dsenv script.

Since you are certified in (what, exactly? there is no Information Server 8.1 certification as far as I am aware) you should have been aware of this - it's a fundamental requirement if there is to be more than one user using DataStage.

chulett · Post by **chulett** » Thu Feb 25, 2010 6:16 am

OK, just seemed that way to me based on zulfi123786 being the only one mentioning anything that seemed 'user based' where things worked under one user but didn't under another. Arnd was the one responding to datisaq's query on the how of the umask setting. I agree it's a best practice and all, I just don't see how you get from the original A to your B. Which is fine and wouldn't be the first time. Ah, well.

Still believe all they need are credentials.

datisaq · Post by **datisaq** » Fri Feb 26, 2010 11:24 pm

Thanks to all for your valuable inputs....

I am able to run from the command line after explicitly specifying the user,password and server name to the "dsjob" command.

DSXchange

Status code = -9999 DSJE_DSJOB_ERROR

Status code = -9999 DSJE_DSJOB_ERROR

Re: Status code = -9999 DSJE_DSJOB_ERROR