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