Problem
How to recover a Framework Manager model from the content store in Cognos 8 (in case the Framework Manager project directory was corrupted or deleted ).


Environment
Cognos 8

Solution
It is possible to recover a model from the project store by creating a cqeconfig.xml file in the <C8Root>/bin directory, and accessing the deleted model within Cognos 8 Report Studio. The model will be saved within the <C8Root>/data/cqe/rtmodel directory.
Access the model by creating an empty model in Framework Manager, and overwriting the model.xml file with the xml file extracted from the content store.

Steps:
1. Create a cqeconfig.xml file and save under <C8ROOT>/configuration Place the following in the file. Due to this file the XML version of the model will be stored in the rtmodel directory as well:

<?xml version="1.0" encoding="UTF-8" ?>
<configuration company="Cognos" version="0.1" rendition="cer2">
<component name="CQE">
<section name="General Options">
<entry name="KeepModelXML" value="1" />
</section>
</component>
</configuration>

2. Stop 'Cognos 8' service and rename the <C8Root>/data/cqe/rtmodel directory, or delete all content. When a framework is opened the rtmodel version of the framework is copied there again.
3. Restart the 'Cognos 8' Service
4. Open Cognos 8 Report Studio, and create a new report based on the package you wish to recover. Run the report.
5. Check if a new <C8Root>/data/cqe/rtmodel directory has been created, and that an XML file has been added to the <C8Root>/data/cqe/rtmodel directory. Copy the XMl file which contain your framework content to another directory ie. c:\fm_rescue.
6. Rename or delete cqconfig.xml or delete it.
7. Restart the 'Cognos 8' Service again.
8. Open Framework Manager, and create a new, empty project. (Select the design language, and cancel out at the MetaData wizard step and save).
9. Close Framework Manager.
10. Goto the directory for the empty Framework Manager project.
11. Copy the generated xml file by Cognos 8 content query engine from the c:\fmrescue directory, into the framework Manager project directory.
12. In the Framework Manager project directory, delete the original model.xml file and rename the generated xml file to model.xml.
13. Open the restore model in Framework Manager and save it.

note: Don't forget to change the name for the publish package, if you want to publish the model without overwriting the original one.

www.cogknowhow.com

Comments

roadwarrior

+1

 

 

Note: This technique will NOT recover a full framework manager model. It does, however, recover a published packaged. Keep in mind that a Model can contain many packages, and a package only represents a subset of a model. In some cases the published package may indeed represent the entire FM model, but it may not.
A framework manager model is a series of file system files. the only way to be sure to recover the full and complete framework manager model is from a full file system backup, not from the Content Store.

Saturday 08 January 2011, 17:52

Guru

+1

 

 

Agree, but this technique gives you at least some parts of the framework instead of nothing.

Valuable addition i would say.
Thx!

Sunday 23 January 2011, 09:25

kavsoo

+1

 

 

This worked perfectly and saved me a lot of time for me folks.

However I have a question though, there is no mention of CQEconfig.xml after deleting it (step # 6). Don't we have to copy it back to the /configuration folder?

Thanks a bunch, keep sharing the wisdom.

Tuesday 17 May 2011, 11:40

lhankins

+1

 

 

You can also use MotioPI (free tool for Cognos Admins) to recover lost Framework Manager models (without having to change CQEConfig.xml or restart Cognos). Here's a blog post which shows how :

http://www.motio.com/blog/2011/09/06/recover-lost-cognos-framework-manager-model.do

Tuesday 06 September 2011, 15:00

CognosGirl

0

 

 

Here is a similar method with screenshots

http://performanceg2.com/2011/08/30/recovering-framework-manager-from-content-store/

Sunday 02 October 2011, 15:44

Please login to post comments or replies.