Cannot get exclusive access to job to compile it!

[dsedi]

Hi,

one of our job strucked in between a load 2 days before
the situation fron the director is it gave 4 warning messages
like
------------------
GetMissingSecurityID: Column REJECT_VAL_TRANS_STG_ID floating point decimal not fully supported. Adjusting scale.
.
.
.
--------------------
and then while trying to reset it says (in director)

"Clearing file RT_STATUS403"

still i am not able to compile the job !

anybody have any idea?

Thanks in advance
Dsedi

[ArndW]

Morning dsedi,

You need to go into the Director -> Cleanup Resources (in enabled in your installation) or in the Administrator and remove the locks that are still set on that job. Other post describe the steps you need to do in details, as does the documentation. I thought that these lock issues had mostly been resolved in V7.x but I encountered the same issue yesterday with an aborted Px run.

[dsedi]

Thanks ArndW!!

I did that several times...even i kill that job thru UNIX command in unix machine..
regarding this, i approched a ascential tech support person too..

..but no use...

i am not able to do anything with the job...

any way I have an another copy in my backup..
but what to know why this was happend..

Thanks Again!

Edi

[ArndW]

dsedi,

avoid doing a "kill -9" of processes, that's a harsh way to remove processes and you might still have locks hanging around after doing that. Did you do a "Clear Status File" as well from the Director? If you are the only one in DS you could do a PORT.STATUS to see what DataStage thinks is out there.

[dsedi]

yes ArndW!

that is what i post in the initial message

"Clearing file RT_STATUS403"

the above message is because of clearing the status file!

Thanks again!

Edi

[T42]

Do not view the log while you're trying to compile the job.