Transformer file lock-out

[w860098]

This week I have had considerable problems generating the various data cubes when running Powerplay Transformer - I was encountering error code TR1901 ("The PowerCube can't be opened").
It subsequently transpired that the .mdc file had a lock set on it (i.e. it appeared that it was being shared with another user) but this is illogical because this is the only process that uses this file (we copy it into the user area after the processing is complete).
The only way I could get over this situation was to bounce the (Windows 2000) server and this released the locks.
Does anyone know how this problem might have occurred (e.g. could the lock have been set up by a previous (failed) run ?) and is there any easier way of removing the lock ?

 

[flex13]

With Transformer closed, you can search for .qyi files(they may have a different extension based on the version that you are using so search for .qy*) and delete them. This will delete any old checkpoint files that may be laying around.

As for the cube lock, this can occur if you are trying to build over a cube that is currently being used by either PPES or PowerPlay client. The suggested way to build cubes is to build them to a staging area, then copy them over for general consumption. This will avoid that problem.

These are pretty much the only times that the cube will be locked.

 

[GJParker]

You should be able to use the srevre manager on your windows 200 server to find out who has it locked. You can also remove locks from here

HTH

Gary Parker
MIS Data Analyst
Manchester, England