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.

Product:
Cognos TM1 9.5.2
Windows 2008 R2 server
Microsoft Excel 2003 (11.5612.5606)

Symptom:
When from TM1WEB select to slice to excel or snapshot to excel, you select “export rows in current page” and “plan_version” for dimensions titles to export. That give a total of 5 new sheets to be generated. You get a error message after some time.

Error message:
Export in process. Please wait…
A problem occurred while resetting culture settings : Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

Possible Solution:
Stop all TM1 services on the Windows server, including the TM1 Excel Service.
For Office 2003 users you must Create a 1033 directory under C:\Program Files\Microsoft Office\Office11. Then, copy excel.exe to the 1033 directory, and rename it as xllex.dll.
For Office 2007 users you must copy (DO NOT CUT) the “xllex.dll” that is in C:\Program Files\Microsoft Office\OFFICE12\1033 into the following directory: C:\Program Files\Microsoft Office\Office12.
For Office 2010 users you must copy (DO NOT CUT) the “xllex.dll” that is in C:\Program Files\Microsoft Office\OFFICE14\1033 into the following directory: C:\Program Files\Microsoft Office\Office14.
Ensure that all TM1 service use the same Windows domain service account.
Start all TM1 service on the Windows server.
Check that your version of Excel is English.
Ensure that Internet explorer uses English (United States) [en-US] as Language Preference,
set in Internet Explorer under TOOLS – INTERNET OPTIONS – GENERAL – LANGUAGES.
Click on ADD to add the English language.
Click on MOVE UP to place English as first language in the list.
Click OK
Close Internet Explorer

In some cases you need to ensure that Regional settings on the TM1 server for the Windows service account is set to English.
Go to control panel and click on “region and language” settings.
Select format to be English (United States)
Click APPLY

If you get a new error after above changes that say
“There was a problem sending the command to the program”
when you start TM1 perspective with Excel 2003 then you must in excel do this;
Go to TOOLS – OPTIONS – GENERAL tab
clear the checkbox for “Ignore other applications”
Click OK.

For Excel 2007 you need to Bring up the Excel options, go to advanced and then scroll down to the “General” section. Make sure that
“Ignore other applications that use Dynamic Data Exchange (DDE)” is not checked.

Now TM1 perspective will work.

More information
The additional workaround for Office 2007 & Office 2010 is slightly different for Office 2003 which is listed in the “KB 320369” article.

Product:
Cognos TM1 9.5.2
Windows 2008 R2 server

Symptom:
When you are inside TM1 Contributor web site and click on “update application” icon you get a error message. You can start the TM1 application, it is only the Admin dialog that does not work.

Error message:
Connecting to server application error
Could not open specified application

Cause:
The TM1 application have not been successfully installed to the new TM1 contributor server

Solution:
You need to do this steps if you want to move a complete TM1 application between servers.

How to export a TM1 contributor application from PROD server:

Open the TM1 Contributor Portal.
1. Mark the application to export.
2. Click Export button.
3. Click Save on the File Download dialog box.
4. Navigate to the directory where you want to save the export file.
5. Click Save.
This create a zip file of your TM1 Contributor application.

Go into TM1 Architect and open you TM1 application – select SAVEALL.
Exit TM1 Architect.
Stop the TM1 windows service.

Zip the datafolder for your TM1 application on the PROD server.

Copy the ZIP files over to the other TM1 server.

How to import a TM1 contributor application to DEV server:

We assume you already have a TM1 application here, that you only want to update with data from the other TM1 server.

If you allready have a application in the TM1 Contributor application with the same name, you need to delete it first as Administrator in the TM1 Contributor Portal on the DEV server.

Stop the TM1 windows service.
Unzip the datafolder files to the TM1 application folder on the DEV server.
Make any changes needed to tm1s.cfg file ( e.g. change server name)
Start the TM1 windows service.

1. Open TM1 server from architect.
2. Run the following TM1 control TI Process: “}tp_admin_delete_all”
3. Click OK on Provide Parameters Values dialog.
4. Exit TM1 Architect program.

Import the TM1 Contributor application as an Administrator in the TM1
Contributor Portal

Steps:
1. Open the TM1 Contributor Portal.
2. Click import button.
3. The Application Import window opens.
4. Select the TM1 Server onto which you want to import the application.
5. Click Browse next to the Application file field.
6. Navigate to the application (.zip) file, then click Open.
7. Select the Import application security option if you want to import security
settings with the application.
8. Select the Import application properties option if you want to import
property settings with the application.
9. Click Import.

Now you should be able to click on the UPDATE APPLICATION icon.

Any status indicators of the TM1 contributor nodes can be lost during the process.