Product:

Cognos TM1

Cognos BI

Windows 2008 R2 server

Symptom:

User is unable to deploy a Contributor app due to an error. Can not publish any application from the TM1 application web design in Tm1 performance modeler page to Cognos connection.

Error message:

An error occurred while creating Cognos objects: CAF

Det uppstog ett fel under uppdatering av cognos objektet: cmHeaderFault

 

Possible Solution:

To be able to publish to Cognos Connection you need rights there. If everyone is part of the system administrator group, then there often are no issues. But after you secure the Cognos connection portal, you need to add the users who should publish items to the Cognos connection to the group system administrators or group authors.

 

Surf to Cognos Connection

Go to Administration of Cognos Content

Click on security tab

Click on Cognos namespace

Go to system administrators group

Click more

Click set members

Click add

Click you domain namespace

Click search

Enter the name of the person who uses the tm1 contributor

Click search

When you find the person, select person and click the arrow to add him to the group

Click OK

Click OK

Test again to publish from Tm1 application web.

Product:

Cognos TM1 10.1.1

Windows 7

 

Symptom:

Error when you try to start performance modeler from application portal on a Windows 7 computer. You have installed the complete TM1 10.1.1 (tm1_64b_10.1.1_win_ml.tar ) 64 bit version on you local laptop.

 

Error message:

0% of cogrcpservlet from localhost completed

file download

Do you want to save this file, or find a program online to open it ?

Name: provagent.cogrcp_modeler

Type: unknown file type, 780 bytes

From: localhost

 

When you try to install PerformanceModeler.msi from file you get this error:

Accessing the feature…

Click OK to try again, or enter an alternate path to a folder containing the installation package ‘PerformanceModeler[1].msi’ in the box below.

 

The file ‘c:\program files\ibm\cognos\tm1_64\webapps\rcp_installs\performanceModeler.msi’ is not a valid installation package for the product IBM Cognos Performance Modeler.  Try to find the installation package ‘PerformanceModeler[1].msi’ in a folder from which you can install IBM Cognos Performance Modeler

Possible Solution:

Cognos TM1 is set to use only IP v4 from inside Cognos Configuration by default.

But you Windows 7 computer is setup to use IP v6. This will make it difficult for TM1 to find localhost or the computer name when it try to access it in different parts.

 

If you get this response when you use ping, then the computer is using IP v6.

C:\Users\roger>ping localhost  Pinging computername [::1] with 32 bytes of data:Reply from ::1: time<1msReply from ::1: time<1msReply from ::1: time<1msReply from ::1: time<1ms Ping statistics for ::1:    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),Approximate round trip times in milli-seconds:    Minimum = 0ms, Maximum = 0ms, Average = 0ms

 

Recommend to use the IP v4 setting in Cognos Configuration, if you do not have any other program on your computer who demand the use of IP v6.

 

Disable the use of IP v6 on all network connections to you computer.

Go to Windows Control Panel

Go to Network and Sharing Center

Click on Change adapter settings, in the left pane

Right click on “Local Area Connection” and select properties

Untick “Internet Protocol Version 6 (TCP/IPv6)” from the networking tab.

Click OK

Repate above for all adapters, including “Wireless Network Connection”.

 

Update you host file to ensure that 127.0.0.1 is used for localhost.

Go to C:\Windows\System32\drivers\etc folder

Open HOST file in notepad and find below rows:

 

# localhost name resolution is handled within DNS itself.

#          127.0.0.1       localhost

#          ::1             localhost

 

Remove the # in front of localhost line to get this result:

 

# localhost name resolution is handled within DNS itself.

127.0.0.1       localhost

#          ::1             localhost

 

Save the HOST file and exit notepad.

Remove previous installed IBM Cognos Performance Modeler from add/remove programs in windows control panel.

Remove previous saved performanceModeler.msi files from you download folder.

Restart the computer to ensure it get a IP v4 address.

Run ipconfig /flushdns in CMD prompt, to ensure you do not have old IP v6 address in cache.

Restart the IBM Cognos Application server service, to ensure it understand the change of IP.

Surf to Cognos TM1 Applications portal and start Performance modeler again.

( surf to http://localhost:9510/pmpsvc )

Install it and test the TM1 application again.

 

Note: that all TM1 applications (services) that you are going to use in Cognos TM1 applications portal must use the same authentication mode. Recommend IntegratedSecurityMode=1

Also the ADMIN user must have the same password in all the TM1 applications.

Product:

Cognos TM1 10.1.1

PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0

Windows 2008 R2 Server

Microsoft Office 2010

Symptom:

When you start TM1 architect in a new installation you get a error message, you also get a error message when you start TM1 perspective.

Error message in windows event log on client:

Log Name:      Application

Source:        SideBySide

Date:          2013-10-02 14:07:57

Event ID:      33

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      xxxxx

Description:

Activation context generation failed for “D:\Program Files\ibm\cognos\tm1_64\bin\tm1xl.ocx”. Dependent Assembly Microsoft.VC80.MFC,processorArchitecture=”x86″,publicKeyToken=”1fc8b3b9a1e18e3b”,type=”win32″,version=”8.0.50727.762″ could not be found. Please use sxstrace.exe for detailed diagnosis.

Event Xml:

<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>

<System>

<Provider Name=”SideBySide” />

<EventID Qualifiers=”49409″>33</EventID>

<Level>2</Level>

<Task>0</Task>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime=”2013-10-02T12:07:57.000000000Z” />

<EventRecordID>4145</EventRecordID>

<Channel>Application</Channel>

<Computer>xxxxxxxx</Computer>

<Security />

</System>

<EventData>

<Data>Microsoft.VC80.MFC,processorArchitecture=”x86″,publicKeyToken=”1fc8b3b9a1e18e3b”,type=”win32″,version=”8.0.50727.762″</Data>

<Data>D:\Program Files\ibm\cognos\tm1_64\bin\tm1xl.ocx</Data>

</Data>

</EventData>

</Event>

 

Activation context generation failed for “D:\Program Files\ibm\cognos\tm1_64\bin\tm1a.exe”. Dependent Assembly Microsoft.VC80.MFC,processorArchitecture=”x86″,publicKeyToken=”1fc8b3b9a1e18e3b”,type=”win32″,version=”8.0.50727.762″ could not be found. Please use sxstrace.exe for detailed diagnosis.

 

Activation context generation failed for “d:\Program Files\ibm\cognos\tm1_64\bin\tm1prc.dll”. Dependent Assembly Microsoft.VC80.MFC,processorArchitecture=”x86″,publicKeyToken=”1fc8b3b9a1e18e3b”,type=”win32″,version=”8.0.50727.762″ could not be found. Please use sxstrace.exe for detailed diagnosis.

 

Activation context generation failed for “d:\Program Files\ibm\cognos\tm1_64\bin\tm1xl.ocx”. Dependent Assembly Microsoft.VC80.MFC,processorArchitecture=”x86″,publicKeyToken=”1fc8b3b9a1e18e3b”,type=”win32″,version=”8.0.50727.762″ could not be found. Please use sxstrace.exe for detailed diagnosis.

 

Cause:

You have not installed C++ 2005 SP1.

 

Solution:

Install Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) from file

vcredist_x86.exe Date 2013-09-02 Size 2660 KB

File version 6.0.3790.0

Right click on file and run as administrator to install it on your server (computer).

In error text: Microsoft.VC80.MFC means it is Microsoft Visual C++ version 8 (AKA 2005) Microsoft Foundation Classes.

And version=”8.0.50727.762″ tells you what file you need to download and install.

Search on www.google.com to find the file to download from microsoft.

Download from here

http://www.microsoft.com/en-us/download/details.aspx?id=5638

In control panel – program and features – it is listed as Microsoft Visual C++ 2005 Redistributable version 8.0.56336

Product:
Cognos TM1 10.1.1
Architect
Windows 2008 R2 Server

Symptom:
List of cubes and views are not sorted alphabetical for a Swedish user.
ÅÄÖ are not in the right place in the list, they are after A instead of Z.

Solution:
Exit Tm1 architect
Go to windows control panel
Click on region and language icon
Change format from English to Swedish
Click OK
Start Tm1 architect
Login and have a look at the list.

Product:
TM1 9.5.1

Symptom:
Even than you are logged in as Administrator in Cognos TM1 Architect program, many menus are grey as you where logged in as a Anonymous or a person without Admin rights in the TM1 cube.

The user complain that they can not reach the Security – Clients/groups menu on the TM1 application.

Problem:
On the Citrix installation of TM1 Architect there are some files missing from the users folder.

Solution:
Copy the files tm1p8.lic and tm1p.ini from a working local installation of TM1 Architect to the Citrix server.
Place the files in folder c:\programdata\applix\tm1

More Information
http://www-01.ibm.com/support/docview.wss?uid=swg21419930

Product:
Cognos TM1 10.1.1
TM1 Application Web
Windows 2008 R2 Server

Symptom:
New installed TM1 application server, when user surf to TM1 Application web the top right icons is missing (my preferences, help and help options). If you have the mouse pointer over the red cross, the function text will show.

You have surfed to http://tm1server.domain.se:9510/pmpsvc, and logged in to get this issue.
This can happen on a TM1 and BI installation where Cognos BI are on a separate server from Cognos TM1.

Cause:
The Cognos BI server is setup with customized skins. This skin folder is not located on the TM1 application server. Therefore we are missing some icons.

Solution:
Logon to the Cognos BI server and find the customized skin that is used under folder
\\biservername\d$\Program Files (x86)\ibm\cognos\c10_gw\webcontent\skins\NIPPON\shared\images
(the folder path can be different on your Cognos BI gateway server)

On the Cognos TM1 server create this folder
D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\skins\NIPPON\shared\images

Copy the images from the BI server folder \Program Files (x86)\ibm\cognos\c10_gw\webcontent\skins\NIPPON\shared\images
to the TM1 server folder
D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\skins\NIPPON\shared\images

(replace NIPPON with your skin name in above folders)
(because this is TOMCAT using this folder the NIPPON name is case sensitive)
Restart the TM1 application server and test again.

Product:
Cognos TM1
Cognos BI
Windows 2008 R2 server

Symptom:
Can not apply formatting in active forms for TM1.

Solution:
Before installation of TM1, you need to install Microsoft Excel on the TM1 server to make Tm1web work.
Active Forms formatting does not work if you have a language specific Excel version, you must install a Microsoft Excel Multilanguage version.

Recommend that to any Tm1 installation, always install the Microsoft Office multi language versions of Excel 2010.

Product:
Cognos TM1 10.1.1
Windows 2008 R2 server
CAM security

Symptom:
Switched to cam security from TM1 native security and when you login to TM1 Architect you get error message. You get same error message if you try to surf to TM1 Application web at
http://tm1server.domain.se:9510/pmpsvc

IntegratedSecurityMode=5
will give error, but not
IntegratedSecurityMode=2

Error message:
404 – file or directory not found

Possible Solution:
The value in TM1s.cfg for ClientCAMURI is pointing to the wrong Cognos BI server.
When you use security 1 or 2 then the CAM address is not used, and you will not get issues.

Copy the value from ClientCAMURI (http://biserver02.domain.se/ibmcognos/cgi-bin/cognosisapi.dll) and start Internet explorer, paste the value in and try to surf to it, if you get errors here. Then it will not either work for TM1.

Update your TM1s.cfg file and restart your TM1 application service.

ServerCAMURI=http://biserver.domain.se:9300/p2pd/servlet/dispatch
ClientCAMURI=http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=1800
CAMPortalVariableFile=portal\variables_TM1.xml
AllowSeparateNandCRules=T
GroupsCreationLimit=100
MaximumCubeLoadThreads = 11

The value in TM1p.ini file (in folder C:\Users\%username%\AppData\Roaming\Applix\TM1) is only used when you add users to the TM1 application from TM1 architect. It should have the same value as the TM1S.CFG file.


AllowImportCAMClients = F
CognosGatewayURI = http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll

Product:

Windows 2008 R2 server

IBM Cognos TM1 10.2

Cognos BI server is installed on a Windows server

Problem:

How do I setup Cognos TM1 10.2?  ( the old version)

Solution:

Download the file tm1_64b_10.2.0_win_ml.tar.gz (CIPW2ML) from IBM website with your IBM account. More info at http://www-01.ibm.com/support/docview.wss?uid=swg24033833

 

Before you install TM1 10.2 check this things:

On the Windows 2008 Server you need to ensure that the printer spooler service is running.

Go to RUN on the server start menu, and enter Services.msc

Start the “print spooler” service and set it to automatic.

 

Check that NET framework 4.00 is installed.

Go to Windows Explorer, and check that you have this folder

C:\Windows\Microsoft.NET\Framework\v4.0.30319

If you are missing NET framework – please download and install NET framework 4.00 from

http://www.microsoft.com/en-gb/download/details.aspx?id=17718

Run the file dotNetFx40_Full_x86_x64.exe to install Net Framework.

You must have Net framework version 4 to use Architect or Perspectives all functions.

 

(Recommended that you have a dedicated workstation with Windows 7 and Excel 2010 where you install TM1 Perspectives and Architect for the TM1 developers to use.)

 

Ensure you have installed Microsoft Visual C++ 2010 Redistributable

Go to Control panel – program and features

Check that you have installed

Microsoft Visual C++ 2010 Redistributable – x64 10.0.30319

Microsoft Visual C++ 2010 Redistributable – x86 10.0.30319 or 10.0.40219

If not download the files from

http://www.microsoft.com/en-us/download/details.aspx?id=14632

and install by right click and select “Run as Administrator” on the files;

vcredist_x64.exe   (size 5585 KB)

vcredist_x86.exe   (size 4879 KB)

 

Log on to the Microsoft Windows 2008 server as a local administrator.

Turn off any running anti-virus software on the server.

Set the User Access Controller settings (UAC) to “never notify”.

 

Run D:\install\tm1_64b_10.2.0_win_ml\winx64h\iisetup.exe to start the installation.

Select all parts, including the IBM Cognos Insight and IBM Cognos TM1 Performance Modeler.

Wait during the installation – it take some time.

 

Start IBM Cognos Configuration with “Run as Administrator”

Change localhost under the TM1 Application Server tab to the name of the Windows server.

Leave localhost as is under the Environment tab.

Start the TM1 admin server by right click on it and select start.

Do the same for TM1 Application Server, SData, Planning Sample and GO_New_Stores.

 

Start notepad from start menu by selecting “Run as administrator”

Open tm1p.ini file from folder c:\programdata\applix\tm1 in notepad.

Change it’s content from this:

[TM1]

DataBaseDirectory = ..\samples\tm1\PData

AdminHost =

ConnectLocalAtStartup = F

LocalServerNetworkProtocol = tcp

IntegratedLogin = F

AdvancedRulesEditor = F

#AllowImportCAMClients = F

#CognosGatewayURI = http:/LocalHost/cognos10/cgi-bin/cognos.cgi

 

To this content:

[TM1]

DataBaseDirectory = ..\samples\tm1\PData

AdminHost = tm1servername

ConnectLocalAtStartup = F

LocalServerNetworkProtocol = tcp

IntegratedLogin = F

AdvancedRulesEditor = T

AllowImportCAMClients = T

CognosGatewayURI = http://biservername.domain.com/ibmcognos/cgi-bin/cognosisap.dll

 

(change biservername to your already installed Cognos BI 10 server)

(change tm1servername to the name of the Windows server where you install TM1)

Save the file and exit notepad.

 

Start Architect from start menu under IBM Cognos TM1 – 64 folder.

Click on Planning Sample to login

Login with user: Admin and password: apple

Exit Architect

This to test the login of Architect.

 

Change settings in a TM1 server to allow Cognos authentication (CAM login)

 

Stop the GO_New_Stores Tm1 application from IBM Cognos Configuration.

Open the file D:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\tm1s.cfg

Add these lines to TM1 server configuration file: (Tm1s.cfg)

 

ServerCAMURI=http://biservername.domain.com:9300/p2pd/servlet/dispatch

ClientCAMURI=http://biservername.domain.com/ibmcognos/cgi-bin/cognosisapi.dll

ClientPingCAMPassport=900

CAMPortalVariableFile=templates\ps\portal\variables_plan.xml

DistributedPlanningOutputDir=.\tunit

ForceReevaluationOfFeedersForFedCellsOnDataChange=T

AllowSeparateNandCRules=T

IntegratedSecurityMode=2

 

And save the configuration file.

Start the GO_New_Stores Tm1 application from IBM Cognos Configuration.

 

Start Architect.

Click on GO_New_Stores to login as the Admin.

Right click GO_New_Stores and select security – client/groups.

Click client menu and select add new client

Click on your domain – not cognos.

Click on search icon in top right corner.

Enter the name of the admin user you want to be able to setup the TM1 application.

Search for him.

Mark the user in the list and click Arrow icon to add him to the group.

Click OK to add him to the TM1 application security.

Mark him as ADMIN in TM1 application.

Click OK and exit Architect.

 

Stop the GO_New_Stores Tm1 application from IBM Cognos Configuration.

Open the file D:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\tm1s.cfg

in notepad as administrator and change the IntegratedSecurityMode line to:

IntegratedSecurityMode=5

Save the file.

Start the GO_New_Stores Tm1 application from IBM Cognos Configuration.

 

Start Architect.

Click on GO_New_Stores to login as the Windows user account instead.

 

To start TM1WEB you surf to this address:

http://tm1servername:9510/tm1web

 

for IBM Cognos TM1 Application use:

http://tm1servername:9510/pmpsvc

 

for IBM Cognos Performance Management Hub use:

http://tm1servername:9510/pmhub/pm/admin

 

for TM1 Operations Console use:

http://tm1servername:9510/pmhub/pm/opsconsole

 

To get TM1WEB to work you need to add some files to the BI server.

 

Extract this files D:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\gateway_files\ tm1web_gateway.zip to a d:\temp folder.

 

Rename the variables_TM1.xml.sample to variables_TM1.xml file

Update the variables_tm1.xml file with the tm1 server name.

Copy the varibales_tm1.xml file to folder C:\Program Files\ibm\cognos\c10\templates\ps\portal on the Cognos BI server (both on BI report server and Content Manager server).

 

Update the file tm1web.html with the name of the TM1server at line:

// Update the following to point to the location of the TM1Web service(s)

var tm1webServices = [“http://tm1servername:9510”];

 

Copy the tm1web.html file to folder C:\Program Files\ibm\cognos\c10\webcontent\tm1\web on the Cognos BI server.  (if the folder \tm1\web does not exist, create it on BI server).

 

Mostly you do not need to restart the Cognos BI server to make the changes take affect, but if nothing else helps try a restart of Cognos BI.

 

More information:

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.2.0.doc%2Ft_tm1_inst_tm1web_cogsecurity.html

 

To get TM1 Application Web to use Cognos authentication you also need to:

 

There are three files, that you need to copy to the Cognos BI server:

variables_plan.xml

planning.html

icon_active_application.gif

Extract the contents of the D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\gateway_files\planning_gateway.zip into three different locations on the Cognos BI C10 server.

 

variables_plan.xml -> C:\Program Files\ibm\cognos\c10\templates\ps\portal

planning.html -> C:\Program Files\ibm\cognos\c10\webcontent

icon_active_application.gif -> C:\Program Files\ibm\cognos\c10\webcontent\ps\portal\image

icon_active_application.gif -> C:\Program Files\ibm\cognos\c10\webcontent\icd\feeds\image

 

Update the planning.html with the TM1 server name at this section:

// Update the following to point to the location of the planning service(s)

 

var planningServices = [“http://TM1machine.company.com:9510”];

 

More information:

http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_inst.10.2.0.doc%2Fc_tm1_inst_new_10_2_0_install_requirements.html

To ensure that Cognos TM1 Applications can properly detect a CAM session termination, set the pmpsvc session timeout to a value higher than the CAM session timeout.

 

Open the file D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ fpmsvc_config.xml

 

And edit session timeout value to 120 or something higher than what you have set in IBM Cognos Configuration for Cognos BI at the security – authentication – inactivity timeout in seconds.

 

<?xml version=”1.0″ encoding=”UTF-8″?><fpm_config xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”fpmsvc_config.xsd”>

<service forceQualifiedPaths=”true”>

<businessViewpoint enabled=”false” uri=”http://localhost:9410/bv”/>

<scorecarding enabled=”true”/>

 

<provisioning allowInstalls=”true” allowUpdates=”true” uri=””/>

<resource path=””/>

<users path=””/>

<external uri=”http://localhost:9510″/>

<session timeout=”60″/>

</service>

<tm1>

<gateway uri=””/>

……………………….

 

 

To start using the TM1 applications you need to add applications.

Surf to http://tm1servername:9510/pmpsvc

Enter TM1servername as Admin host (it will be prepopulated)

Select the TM1 application GO_New_Stores to use.

TM1 application web URL should be:

http://tm1servername:9510/tm1web/Contributor.jsp

Cognos BI gateway URI should be:

http://biservername/ibmcognos/cgi-bin/cognosisapi.dll

Click OK.

 

If you are missing icons in the toolbar for TM1 Application Web, then you are probably using a custom skin in your Cognos BI environment. Change to use a default skin like “business” to get the icons to show.

 

Restart the TM1 server to make changes take affect.

Check this to get SSO to work https://allthingscognos.wordpress.com/2014/08/26/configuring-performance-modeller-and-tm1-web-with-cam-security-for-tm1-10-2-n/

Product:
TM1 10.1 Perspective
Windows 2008 R2 Server
Citrix Server

Symptom:
When you start TM1 Perspective (Excel 2010) from Citrix portal you get a error message.

Error message:
Run-time error ‘429’: ActiveX component can’t create object

Solution:
After you have installed TM1 Perspective on the server,
you need to start the application once to create some registry values before other can run it.

Log in as local administrator on the server
Start TM1 Perspective.
Close TM1 Perspective (and Excel)
Log out from server.

Now other users should be able to login.