Creating .MDC file - Error:process or action cancelled at your request

[smsaji]

Hi,

Trying to create a .mdc file from .mdl file using C#. The following code seems to successfully load the Cognos application, open the .mdl file. When trying to create .mdc file, gives following error:

'trModel(CreateMDCFiles) : (TR0102) The process or action was cancelled at your request. '

Any help or link appreciated. thanks

Here is the code:

strModelPath = @"C:\Cognos\go_sales.mdl";
try
{
Type typeCognos = Type.GetTypeFromProgID("CognosTransformer.Application");
object objCognos = System.Activator.CreateInstance(typeCognos);

// Create the parameter list
object[] arguments = new object[] { strModelPath };
object[] argumentsMDC = new object[] {};

// Dynamically Invoke the Object
Object objresult = typeCognos.InvokeMember("OpenModel",
BindingFlags.InvokeMethod,null,objCognos,arguments);

Object resultMDC = typeCognos.InvokeMembe("CreateMDCFiles",
BindingFlags.InvokeMethod,null,objresult,argumentsMDC);

}
catch (Exception ex)
{
txtError.Text = "Main error: " + ex.Message + ex.StackTrace;
if (ex.InnerException != null)
{
txtError.Text = "Inner Exception : " + ex.InnerException.Message +
" Source " + ex.InnerException.Source +
" trace " + ex.InnerException.StackTrace;
}
}

saj

 

[smsaji]

Anyone can help as where to look for the 'Transformer logs' ie in which folder?

saj

 

[drlex]

saj,
Logs usually go in C:\Program Files\Cognos\cer4\bin.
That error message can result when the cube is already open or is locked from a previous failed build or when anti-virus software interrupts the process.
Failed builds will leave files in the designated temp area (see transformer configuration to determine this), such as .qyi & .lck files, so you may need to delete these prior to deleting the cube. (Remember to close Transformer prior to deleting the temp files).
Happy Friday,
lex

soi la, soi carré

 

[smsaji]

thank you drlex, deleted the .qui and .lck files and was able to create the cube!!