How to recover a Framework Manager model from the content store in Cognos 8

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 /bin directory, and accessing the deleted model within Cognos 8 Report Studio. The model will be saved within the /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 /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 /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 /data/cqe/rtmodel directory has been created, and that an XML file has been added to the /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. This technique will NOT recover a full framework manager model. It does, however, recover a published packaged and package only represents a subset of a model.

Comments

Post a Comment

Popular posts from this blog

RSV-VAL-0032 expression is not valid. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'.

Image
Problem: RSV-VAL-0032 The following expression is not valid: [AdjRowsReturned] = 0. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[AdjRowsReturned]' is invalid Resolution: You might have used the calculated data item in the variable, which needs to be added in the page properties. - Click on the page and go to properties. Make sure you see 'page' on the top of the properties. - Click on properties icon under data section, you'll get pop up icon - Check mark the data item which is used for variable calc. You are good to go.Find the snapshot. .
Read more

How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it?

The AM_NamespaceReport Utility allows you to extract the namespace to an XML file. 1. Use the AM_NamespaceReport Utility to extract all users from the namespace to an XML file. am_namespacereport -h << host >> -p << port >> -r << basedn >> -n << namespace >> -D << username >> -w << password >> -f all -o << path to filename.xml >> e.g am_namespacereport -h cognoscamsevr -p 4004 -r o=cognos.com –n devcam -D admin -w admin -f all -o c:\temp\usrlst.xml 2. This will extract all user information to an XML file 3. Import the xml file into XLS spread sheet 4. Create ODBC connection using the ms-excel spread sheet driver 5. Create Data Source Connection and proceed creating FM Model & Publish 6. Create Report using Report Studio. 7. Save & Share the report The Access Manager Administration Guide (Appendix A) contains further information on this functionality.
Read more

BME-EX-0047 Unable to read preferences for the requested interface..

Issue When opening or creating a Framework Manager project the following error message is shown. Additionally, when attempting to create or open a report based on a package is made in Report Studio or Query Studio, the same error message is shown. Error BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface. Resolving the problem This happens due to a corrupt bmt.ini file in <Install Location>/c8/configuration directory. This issue can be resolved by extracting bmt.ini from last known good backup or even from installation files.
Read more