Page 1 of 1

Getting error while importing a job

Posted: Tue Oct 28, 2008 12:04 pm
by nkbhosle
While importing a job i am getting error as "cannot get exclusive access to log for job <job name>. please reply ASAP because i am facing this problem while importing the jobs in pre-prod env

Thanks in advance

Posted: Tue Oct 28, 2008 1:20 pm
by mail2hfz
Please read this viewtopic.php?t=86415

Do a search on the forum for "cannot get exclusive access".
Check if the job is locked by any user or if no one is accessing that job try to kill it(use LIST.READU command to know who has opened the job and use dsdlockd -p command to clean up)

Posted: Tue Oct 28, 2008 3:10 pm
by trokosz
Well someone already has the Job open so tell them to close (including Job Monitor or Director)

Or

There is a orphanded lock so perform UNLOCK ALL

Or

If your IS 8 and greater then go to IS Console Sessiona Management and disconnect any orphaned sessions....

Posted: Wed Oct 29, 2008 12:53 am
by nkbhosle
mail2hfz wrote:Please read this viewtopic.php?t=86415

Do a search on the forum for "cannot get exclusive access".
Check if the job is locked by any user or if no one is accessing that job try to kill it(use LIST.READU command to know who has opened the job and use dsdlockd -p command to clean up)


I have tried all the options but could not resolve.Actually i have few jobs in preprod env and i want to overwrite the jobs with the import all the jobs have been overwrite but only 1 job i am getting the error "cannot get exclusive access to log for job"

Posted: Wed Oct 29, 2008 3:21 am
by hemanthakumar
if u restart the server then the deadlock cleared,then u can import the job first try to kill the pid in unix for that job last preference is to restart the server.

Posted: Wed Oct 29, 2008 6:26 am
by trokosz
I would not reboot but sure that is a forced solutioin.....

Look for phantoms such as ps -ef | grep pha or ps -ef | grep osh and kill them.....

Posted: Wed Oct 29, 2008 6:29 am
by chulett
What did you find when you searched for "cannot get exclusive access to log for job"? It's all explained out there.

Posted: Wed Oct 29, 2008 6:35 am
by keshav0307
you need not to restart the server.

do you know the ID for this job??

just check, if there is any lock for any process or job of this ID , and clear that.