unable to delete job

[2ksaint]

Im unable to delete the job using director, manager, designer.

* Tried cleaning up the reources, logs
* Tried using ds.tools in Administrator->command
Process performed in Command using ds.tools
(4-for admin previlege, then 7 for clean up the lock, then giving the process id, then enter yes)

Error message: "Cannot get exclusive access to job cmbatjbs"

Please provide solution to this issue, i tried information provided in the forum, still no luck.

[chulett]

You need to get rid of whatever process has the job. It could be as simple as someone browsing the job's log. Did you get the job's number and look for it in Cleanup Resources?

[2ksaint]

thanks for replying chulett.

I checked the team to find out whether anybody is opened the job or viwing the log, but no one opened or view the log.

I also got the job number and checked the cleanup resource and cleared everything and tried to delete the job, still no luck.

Once the try to delete and get the error message, then i check the cleanup resource for the job id and found there is a different no in the cleanup resource.

Still no luck. IS there anything like any temp folder of the job which holds the file? so that i can navigate that folder and delete that file. which might resolve the issue.

[ray.wurlod]

NO!!!

This is a database, not a set of files in a directory.

Execute this command in an operating system shell.

Code: Select all

$DSHOME/bin/list_readu | grep $jobname

Substitute for $jobname as appropriate.

This will tell you information about the lock on the job, including the process id of the lock's owner. If that process no longer exists

Code: Select all

ps -ef | grep $pid | grep -v grep

then - and only then - is it safe to release the lock.

Get back with your discovery about the lock and we'll then talk about where to go from there.

[2ksaint]

thanks ray,

I tried entering the command:

list_readu | grep $cmbatjbs

I got the message stating
"sh: cmbatjbs: Parameter not set.
Abnormal Termination of Datastage.
Fault type is 13, Layer type is unknown."

If i enter the command like

list_readu | grep cmbatjbs

I dont get any messages

What to do now, Is there any other way i can delete the job.

Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected"

Error message. This message occur in all other jobs too.

Does the above error be the cause for all?..

[chulett]

Note: In the mean time I'm also getting "Abnormal Termination of stage $jobname: TRN_PASS (transformer stage) detected"

Error message. This message occur in all other jobs too.

New problem = new thread. Start a new discussion to talk about this and, when you do, please clarify that you do indeed mean *all* other jobs.

[chulett]

I tried entering the command:

list_readu | grep $cmbatjbs

Ray never meant you to stick a dollar sign in front of either a job name or the pid being looked for. When you tried it without one, is "cmbatjbs" your exact job name, all lower-case? You can add the "-i" option to grep to make it case insensitive if you like, see if that helps.

At some point, if you literally cannot figure out what needs to be done to free the resources do you can delete this job... restart DataStage. That would certainly accomplish that goal but if you've never had to do that we'd probably be back here with questions about why it won't restart.

Let's just wait and see what Ray has in mind as the next steps, shall we?

[ray.wurlod]

Waiting to see the list_readu result...

[2ksaint]

thanks ray & chulett,

I retried running the command with other job of the same issue and found the result given below:

list_readu | grep CMN_GET_BATCH_ID_JBS
1074987009 402 0 50988 26 RU 14548 sami CMN_GET_BATCH_ID_JBS

Note: Sami is the login id we use and CMN_GET_BATCH_ID_JBS is the job that is need to be deleted.

the above information might help, i think....

[ray.wurlod]

I'm going to get you to do a slightly unnecessary step that will make following explanations clearer. I want you to execute the same command but to include the headers from the list_readu command.

Code: Select all

list_readu | head -2 ; list_readu | grep CMN_GET_BATCH_ID_JBS

Please post the result, as I am not at a UNIX site at the moment and have to do all this from memory.

[sambit]

I faced the same issue and tried the command provided by Ray. The output says,

Active Record Locks:
Abnormal termination of DataStage.
Fault type is 13. Layer type is Unknown.


Any solution?