Framework Manager Error while publishing new package

Cognos Error :

[ ERROR ] CAM-CRP-1315 Current configuration points to a different Trust Domain than originally configured.

[ ERROR ] The cryptography information was not generated


Solution : Delete csk,signkeypair and encryptkeypair folders in configuration directory and resave Configuration
Manager.

Interpretation : This can usually happen when you are trying to point from Development environment to Production environment or any other environment by simply changing the configuration in Cognos Configuration Manager.It will prompt informational message as unable to decrpyt userid password.

You will get same error for Transformer too and solution is same.

Configuring Essbase Connection for Cognos 8.4

Steps to Configure Essbase 7.1 in Cognos 8.4 Server

Environment : Cognos 8.4 in Unix Server,Essbase 7.1

Hello Friends, I did not find any good details about it in Cognos documentation,so thought to share with you all so that you do not have to troubleshoot from your side.
Also if you encounter below error,this solution can also help:
Error message : Unable to find or load the shared library 'ld.so.1: BIBusTKServerMain: fatal: /global/site/vendor/cognos/c8_64/./bin/libDB2OlapODP.so: open failed: No such file or directory - /global/site/vendor/cognos/c8_64/./bin/libDB2OlapODP.so' (or one of its dependents) containing the provider 'DB2OlapODP'. Please contact your administrator.

Step1 : Installation of Essbase Client on Cognos Server.
The structure will look like this once you install essbase client in Cognos Unix Server.The installation is pretty easy for Essbase and mostly have to click next.
Servername://Hyperion $ ls -ltr
total 4
drwxr-xr-x 3 common
drwxr-xr-x 9 Essbase


Step 2 : Include the arbor path in Cognos server script.In our case we are using unix so the path will look like as below :

# ESSBASE
export ARBORPATH=//Hyperion/Essbase;

export LD_LIBRARY_PATH=$otherpath:$ARBORPATH/bin:$LD_LIBRARY_PATH;
export PATH=$otherpath:$ARBORPATH/bin:$PATH;


Step 3 : Change the following entries in qseconfig.xml in /configuration directory.
Change following line :
Search for provider name="DB2OlapODP" and in that change
libraryName=doodp82 from existing libraryName=essodp93


By default cognos comes on configured with Essbase 9 so to change to Essbase 7.1 you have to make below changes.

Step 4 : Restart the Services using configuration manager.

Step 5 : Test the connection by creating a Data Source in Cognos connection and pointing it to your Essbase server.Make sure the firewall ports are open between the servers.

Arithmetic overflow or other arithmetic exception while selecting values from Report Studio query

Issue : User trying to select query from Report studio,by selecting the query item and it displayes below error message

UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.

UDA-SQL-0144 An arithmetic exception was detected.

[IBM][CLI Driver][DB2/6000] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003

UDA-CUR-0000 Unable to fetch the row.


Anaysis :

When checked in detail the query item was a numeric value with a large no of rows in database.
The column is integer and the rollup is defined as Automatic and Aggregation function is defined as Total.

In the expression editor, when searching for values for a data item, the results you obtain may contain unexpected results if the data item is not a string data type. Because users can edit the expression for a data item, IBM Cognos 8 cannot determine with certainty what the data type is.

Therefore, IBM Cognos 8 guesses the data type of the data item by looking at its aggregate and rollup aggregate set

Try to change the Aggregation function and Roll up aggregation to Not Applicable and then try searching the values.

The Things you can try is changing the attribute from Framework manager itself.

Note : The below observations are just based on my analysis incase you find some other reasons and solutions for its,please let me also know.

Modeler Role setting for Cognos 8 incase you do not want to give Server Admin rights

Problem : Got new transformer licenses,but need to setup Modeler role in Cognos 8 configuration.Do not want to give System Administrator roles to
modelers and want to restrict access only what they will require.

Error Messages :

TR0164 Data source create problem. CCL-RCI-0002 The Soap server returned a Soap fault.

CM-REQ-4012 you do not have the appropriate permissions to update or delete the object "/Directory/Cognos" or a related object


Solution : Some of the points are from Cognos documentatin,however it is not more specific there in document.


1) Database client software is installed, or available for modelers to install, on the Transformer computers that are used to access IBM Cognos 8 data sources.

2) Modelers must have privileges to create a data source in IBM Cognos Administration.

The good way to do it is create a role as Cognos modeler in Cognos group and assign the roles required as below to it.The individual modeller ids can be
added to group then.

Go to IBM Cognos Configuration.

To enable capabilites select the Administrator Set Properties tab.Add the Modeler group you created and assign just traverse permission here.

Click on Administration and select Set Properties for Data Source Connections.Add the Modeler group and assign read,write,execute and traverse permission here.

Go back to main Capabilites page and select Set Properties for Cognos Viewer.Add the Modeler group and assign execute and traverse permission here.


3) Modelers must have access to a location in which to store the PowerCube after building it.

4) To build PowerCubes on a specific Transformer server, modelers should have FTP privileges to transfer models and execute privileges to build cubes on that server.
Normally its good idea to restrict access as far as possible in server.

Error while opening Framework Manager Data Source Connections

Error:

QE-DEF-0368 Unable to decrypt user name and password from the Content Store. Use Cognos Configuration to configure your reporting environment.

Environment : FM in Windows and Cognos 8 BI server in Solaris 9.

Solution :
Close Framework Manager and Cognos Configuration from machine.From the \crn\configuration folder on the Framework Manager installation, rename / deleted these directories:

1) csk
2) signkeypair
3) encryptkeypair

Open configuration manager and save the configuration.Launch Framework Manager and and it should be work fine.