Product:
Cognos BI 10.1.1 Transformer
Windows 2008 R2 server
Symptom:
Error when try to create with Cognos Transformer on a Microsoft Windows 2008 R2 server.
You may also get errors when working in Cognos Framework Manager on the server.
Error message:
“UT-DEF-0114 Cannot open lock file
Possible Cause:
The windows user and the service account that run the IBMCOGNOS service have lost rights to the folders, specially the \program files (x86)\ibm\cognos\c10\configuration folder.
Solution:
Even due the user is part of a Windows domain group that is included in the Windows 2008 servers local administrators group, do this on the server:
Right click on the server icon and click manage
Expand the Local User and Groups
Select Groups
Open Administrator group properties
Click on ADD
Enter the name of the user that you want to be able to run transformer
Click Check names to ensure they exist in the domain
Click OK
Log out of the server,
and let the user login and test if transformer works now.
If there is still is same error, add the user direct to the configuration folder
Right click on folder \c10\configuration and select properties
Select security tab
Click on EDIT
Click on ADD
Enter the name of the user that you want to be able to run transformer
Click Check names to ensure they exist in the domain
Click OK
Repeat the above step for that windows user account that is used to run the Cognos BI service, to ensure that reports and transformer will work when scheduled.
When the new user is marked in the list of Groups and user names
Mark ALLOW for MODIFY
(Read & execute, list, read should also be marked)
Click APPLY
Click OK
Log out of the server,
and let the user login and test if transformer works now.
You may need to do the same for the folders used by Framework manager, e.g. the folder where you create and save your framework projects.
More Information:
The list of recent used files in Cognos Transformer is stored in the file \program files (x86)\ibm\cognos\c10\configuration\cogtr.xml
Windows settings for Cognos Transformer program is stored in the file \users\%username%\cogtrwin.ini
The list of recent used files in Cognos Framework Manager is stored in the file \program files (x86)\ibm\cognos\c10\configuration\bmt.ini
In configuration folder file fm.ini also exist, if you do not have access to above files you get errors inside Cognos framework manager.