Unable to refresh the cognos powerplay cube using a cognoscript macro.

Error message:
AutoExe: trModel(CreateMDCFiles): (TR0102) The Process or action was cancelled at your request.

If you open the same model using PowerPlay Transformer and try to generate cubes, the following error pops up:

Powerplay Transformer Warning
(TR0787) The locking of cube 'd:\gg_etltools_model1.pyi' failed. It is probably in use by another application. Select Yes to retry, No to create the Cube using a temporary name or Cancel.

Solution:

  • The most probable cause is that the output cube file is locked by a system process. Although the model can seem to be unused by any application, the file still may be locked by a virus-scanner. It is recommended to exclude the Cognos files (mdl, mdc, pyi, pyh, qyi) from the real-time scanner.
  • The error may also appear when the cube refreshing process was interrupted. In that case the file may have been corrupted.
    The easiest workaround of the problem is to change the powercubes generation path in the model (it can be done in PowerPlay Transformer: Powercubes -> Properties -> Output -> PowerCube File Name).