Page 1 of 1

Cannot get exclusive access to job

Posted: Thu Jul 03, 2008 5:35 pm
by jim.paradies
Hi all,

I'm getting a lot of locking problems mainly when I export out of the DEV project and import into another project.

The problems start after an import is complete and I try to do a multi-job compile. When I do this most jobs work fine but some fail with the error "Cannot get exclusive access to job" and here is where the strange behaviour comes in.

1. I know that no-one else is using this project.

2. I check for locks using Director (Job/Cleanup Resources) and find no locks or processes.

3. I use UV shell (LIST.READU) to check for locks and find nothing

4. I use DS.TOOLS to check for locks and find nothing

5. I try to compile manually and it works

6. I try to force compile and it works

7. I try to run the job and get the error "Cannot get exclusive access to job Import_Data_MAPPING_Lattice_Crews."

The only time that the locks are released is when the server is bounced.

Note that this is running on Windows 8.0.1

Has anyone had similar experiences and found some way of releasing these "locks" without bouncing the box?

Posted: Thu Aug 21, 2008 12:58 am
by manuel.gomez
Suffering the same, impossible to get this fixed!!!

Posted: Thu Aug 21, 2008 1:26 am
by ArndW
What about the sessions listed in the web client for IIS, that can show a session and hold a lock that might not be visible from the DataStage engine.

Posted: Thu Aug 21, 2008 4:21 am
by ray.wurlod
Try to do a single-job compile in Designer. If the job is locked, the message box will yield the session ID of the owner. Open the web console for Information Server, go to Session Management and disconnect that session. This will release the lock.

This - I believe - is what Arnd was referring to.