Product:

Cognos TM1 9.5.2

Windows XP

Symptom:

TM1 architect is started on the Windows XP client, but disappears then.

If you start TM1 architect on the server, it starts and show the available TM1 servers.

Error message in windows event log:

Description:

Generate Activation Context failed for C:\Program Files\Cognos\TM1\bin\tm1p.dll. Reference error message: The operation completed successfully.

 

Description:

Syntax error in manifest or policy file “C:\WINDOWS\WinSxS\Policies\x86_Policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773\8.0.50727.762.policy” on line 12. The root or application manifest contains the noInherit element but the dependent assembly manifest does not contain the noInheritable element. Application manifests which contain the noInherit element may only depend on assemblies which are noInheritable.

 

Cause:

The client default settings are stored in this folder:

C:\Documents and Settings\All Users\Application Data\Applix\TM1\tm1p.ini

These settings are copied to new users who start TM1 Architect on the client computer.

 

TM1P.INI contains:

 

[TM1]

UseHttpConnector=F

HttpProxyServerPort=

IntegratedLogin=F

UseHttpProxyServer=

#AllowImportCAMClients=T

DataBaseDirectory=C:\Program Files\Cognos\TM1\Custom\TM1Data\PData

#CognosGatewayURI= http://FRANGOPC/cognos8/cgi-bin/cognos.cgi

AdvancedRulesEditor=F

HttpConnectorUrl=http://youraddress.com/tm1HttpProxy

HttpProxyServerHost=

AdminHost=ServerTM1

Language=ENG

UseExcelCubeViewer=F

InProcessLocalServer=T

ConnectLocalAtStartup=F

LocalServerNetworkProtocol=tcp

 

Possible Solution:

Ensure the Adminhost value is the correct Tm1 servername.

 

Recommendation is also to set AdvancedRulesEditor to true so it will show the new editor for the users, this editor demands that you have NET framework 3.5 installed on the client computer.

AdvancedRulesEditor=T

Ensure that the client can read this file from the hard disc.

 

If there is on a Microsoft Windows XP computer you need to have installed Service Pack 2.

Product:

Cognos TM1 10.1.1  (this will work with other versions of TM1 also)

Microsoft Windows 2008 R2 server

Problem:

How create a dump file of TM1 application crash and send it to Cognos Support ?

Solution:

In Windows 2008 you can change registry values to active the creation of a complete dump file, that you can then send to Cognos supports FTP site.

 

Login to your TM1 server as administrator

Create a folder to save the dump files in e.g. d:\crashdumps, need free space equal to size of TM1 application in memory (RAM).

Start Registry editor by enter regedit on the RUN line from the start menu.

Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft

\Windows\Windows Error Reporting\

Right click and select create a new key under Windows Error Reporting

Create the key Localdumps, if it does not already exists.

Right click and select create a new key under Windows Error Reporting\Localdumps.

Name the key tm1sd.exe

Right click on tm1sd.exe and select new – expandable string value.

Name it DumpFolder

Double click on it and enter the value of the folder e.g. d:\crashdumps

Right click on tm1sd.exe again and create a new DWORD 32bit value

Name it DumpType

Double click on it and enter the value of 2 for a full dump file.

Exit RegEdit program to save the changes.

 

To kill a TM1 process in task manager will not trigger the dump file, so you need to test the

dump create process in a different way.

This registry changes will work on both 32 and 64 bit versions of applications.

 

A other way to create the values in registry to active dumps for TM1 applications are to;

Copy and paste the following command into the Administrator command prompt window, and then press Enter to execute the command:

 

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\tm1sd.exe” /v DumpType /t REG_DWORD /d “2” /f

 

You should see a message like “The operation completed successfully.” after completion of the command.

 

Paste this line in the dos prompt to set the folder to store the dump file:

reg add “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\tm1sd.exe”  /v DumpFolder /t REG_EXPAND_SZ /d “d:\crashdumps” /f

 

You should see a message like “The operation completed successfully.” after completion of the command.

 

Collect also the listed log files and send to Cognos Support.

The Tm1server.log file. This file is located in the TM1 server data directory.

All TM1ProcessError.log files generated during the TM1 server session that crashed.  Check the name of the file for date and time when it was created. File names are assigned using the convention TM1ProcessError_time stamp_process name.log.

All TM1ProcessError.log files are stored in the TM1 server data directory.

 

Attach the cmplst.txt file from the C:\Program Files\ibm\cognos\tm1_64 folder, found in folder where you have installed your TM1 program.

 

Compress all the files with 7zip.org before you try to send it to Cognos Support.

Name the zip file with the PMR number you have got from Cognos Support.

E.g. cognospmrxxxxxxxxxxx.zip  (do not enter point or dashes in name)

 

You can upload files to the IBM® FTP server from a Web browser.

  1. Go to https://testcase.boulder.ibm.com.
  2. Log in with user name anonymous. No password is required for an anonymous login.
  3. Click the toibm folder.
  4. Click the im folder.
  5. Click Browse and navigate to the file you want to upload.
  6. Click Upload file (binary).

 

More information:

http://msdn.microsoft.com/en-us/library/windows/desktop/bb787181%28v=vs.85%29.aspx

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