COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: raj_aries81 on 03 Aug 2016 09:02:48 PM

Title: (TR0787) The locking of cube issue
Post by: raj_aries81 on 03 Aug 2016 09:02:48 PM

I'm using command line script to build two different cubes using one mdl file. These two cubes are built daily at different time with a gap of 2 hrs.

Most of the times they run flawlessly.However, occasionally first cube gets stuck at "Updating the PowerCube metadata" step and when the second cube is triggered, it obviously fails with - (TR0787) The locking of cube 'xxxyyy.mdc' failed. It is probably in use by another application. Select Yes to retry, No to create the cube using a temporary name or Cancel.

Below is the command line that I'm using & Deployment tab 'Automatically copy & activate' is enabled.

cogtr -n -c -nologo -dLogFileName="<logfilename.log>" -g"<cube name>" -m"<mdl file path>"     

Not sure what could be the reason for the first cube to get stuck at "Updating the PowerCube metadata". Is there any other log file or folder where I can find the reason for this endless wait.

Appreciate your time and help in this regard.


Thanks
Raj