mdc file locked

[Tomadams]

We are running Cognos 10.1.1 against a Sybase IQ database.
Whenever we start the cube build we get the error message that says the mdc file is locked,
The problem started when the cube build stopped when it hit the 2 gig limit.
We removed the 2010 data from the input stream and restarted the build. It did not start, but gave a message that the .mdc file was locked.
Since then we have tried;
1. Verified that no one had the file open
2. Re-pointed the .mdc file
3. Renamed the .mdc file
4. Performed a warm restart of the server
5. Performed a full clean house
6. Tried to build with a different instance of transformer on a PC
7. Saved the model as a .pyj and tried the build with the new .pyj
8. Performed a cold reboot
9. Stopped anti virus

All these efforts had the same results – File Locked.
We are approaching critical stage. The cube is very complex and took several months to build.

Thanks in advance for your thoughts
Tom

 

[drlex]

Tom,
It sounds like the temporary files were not deleted, based on my experience of the Windows version of Transformer 7.4, which should be similar to 10. Under preferences, there is a tab for Directories, which gives a location for the Model Temporary Files, being a QYI & LCK file. It may be that the type has changed slightly, but by checking the location and looking for files with a modification date that matches the termination of your build, you should be able to identify and move* them. By watching the creation of temp files in another cube build, you can be a little more certain about this step!

Hope that helps
lex


(* move, so that if you're incorrect, you haven't deleted something important)

soi là, soi carré

 

[drlex]

Forgot to add (and assuming that you're using Windows rather than Unix), you could use a utility like "Handle" to check on the purported locking of the file -

http://technet.microsoft.com/en-gb/sysinternals/bb896655

soi là, soi carré