Product:

IBM Cognos BI 10.2.1

Windows 2008 R2 Server

Internet Explorer 10

Symptom:

When user surf to Cognos Connection things does not look correct, and if they try with FireFox it looks better. If the user press F12 inside IE and manually change the browser to use IE10 Compatibly mode it works better.

Problem:

Cognos BI 10.2.1 only supports IE 10 and IE 11 in compatibly mode.

Solution:

You can force the IE to use one mode for all traffic to a website by setting the value of HTTP Response Headers inside Internet Information Services (IIS) Manager.

Expand the folder three to the cgi-bin icon, and click on HTTP Response Headers

Click ADD

Enter X-UA-Compatible as Name

Enter IE=EmulateIE7 as Value

Click OK

Close IE and start IE again and test to surf to Cognos Connection.

Or you can change it direct in the web.config file for Cognos.

Go to folder C:\Program Files\ibm\cognos\c10_64\cgi-bin

Open web.config file in notepad

Add the <httpProtocol> section shown below:

 

<?xml version=”1.0″ encoding=”UTF-8″?>

<configuration>

<system.webServer>

<handlers>

<add name=”Cognos-ISAPI” path=”cognosisapi.dll” verb=”*” modules=”IsapiModule” scriptProcessor=”C:

\Program Files\ibm\cognos\c10_64\cgi-bin\cognosisapi.dll” resourceType=”Unspecified” preCondition=”bitness64″ />

<add name=”Cognos-CGI” path=”*.cgi” verb=”*” modules=”CgiModule” resourceType=”Unspecified” />

</handlers>

 

<httpProtocol>

<customHeaders>

<add name=”X-UA-Compatible” value=”IE=EmulateIE7″ />

</customHeaders>

</httpProtocol>

 

</system.webServer>

</configuration>

 

Save the web.config file.

Close internet explorer and test again to surf to Cognos Connection.

More info:

http://world.episerver.com/FAQ/Items/Configure-IIS-to-force-Internet-Explorer-8-to-run-in-Internet-Explorer-7-mode/

http://frankcode.wordpress.com/2013/10/17/a-guide-to-ie-compatibility-view-and-x-ua-compatible/

Product:

IBM Cognos Tm1 10.1.1 (version PLANANALYTICS-AW64-ML-RTM-10.1.7000.91-0)

PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0 ( TM1 fix pack1)

Windows 2008 R2 server

Symptom:

Inside Tm1web, you click on export icon and select export to pdf.

Select a Choose number of rows to export:

Select a Choose dimension titles to export:

click OK

Gives error message;

Error message:

Export in process. Please wait…

Error while Printing to PDF: No printers are installed. To install a printer click the File tab, and then click Print. Click No Printers Installed, and then click Add Printer. Follow the instructions in the Add Printer dialog box.

 

Cause:

The windows service account that is set for the IBM Cognos TM1 Excel Service, is not the same account used when installing TM1 server ( and the pdfcamp printer driver ).

 

Solution:

Stop IBM Cognos TM1 Excel Services

Uninstall the pdfcamp printer driver by run, D:\Program Files\ibm\cognos\tm1_64\bin\PDFCamp\unpdfx64.exe

Log off the TM1 server

Login to the TM1 server with the windows account that is use to run the TM1 Excel service.

Install the pdfcamp printer driver by run. D:\Program Files\ibm\cognos\tm1_64\bin\PDFCamp\setupx64.exe

Now the printer driver is there for the user running the service.

Set the PDFcamp Printer as default printer.

Start the IBM Cognos TM1 Excel Services.

Log off the server.

Test the TM1web function export to pdf.

Product:

IBM Cognos TM1 10.1.1

Windows 2008 R2 server

 

Problem:

How do I start TM1TOP on the server?

 

Solution:

There is different ways to start the TM1top application.

 

One is to start it direct from an CMD dialog.

Log on to TM1 server.

Right click on Command Prompt and select Run as Administrator.

Enter the following line (after you change the path to yours) and press enter

 

“d:\program files\ibm\cognos\tm1_64\bin64\tm1top.exe” -servername “tm1planning”

 

Change tm1planning to the name of your tm1 application e.g. planning sample.

If you have made a TM1TOP.INI file you want to use and placed it in folder TOPTEMP you can use this command:

 

“d:\program files\ibm\cognos\tm1_64\bin64\tm1top.exe” -i  d:\toptemp\tm1top.ini

 

A different way to do it is to copy the TM1TOP.EXE and TM1TOP.INI files in a folder call d:\toptemp

Then you need to add path to TM1 bin folder in you path on the server.

Right click on Computer icon and select properties

Click on Advanced System Settings

Click on Environment Variables

Scroll down system variables and select PATH

Click on Edit

At the end of the variable value add;

;d:\program files\ibm\cognos\tm1_64\bin64

Click OK

Click OK

Click OK

 

Go to the d:\toptemp folder in windows explorer

Click on the tm1top.exe file to start tm1top application.

 

The TM1TOP.INI file should have this values

 

adminhost=windowsservername

servername=tm1planning

logfile=tm1topplanninglog.txt

logappend=t

refresh=2

logperiod=10

 

(Important to not have any spaces in above tm1top.ini file)

adminhost=the name of the windows server where tm1 admin service are

servername=the name of the tm1 application

logfile=the name of the logfile you want to create

logappend=True to add error messages to the file every time you start the tm1top

refresh=2 seconds between updates on the screen

logperiod=10

 

Logperiod Specifies the time interval between updates being written to the log file, in seconds.

Setting this to zero disables logging.

For example, if the screen Refresh is set to 2 seconds, LogPeriod could be set to 10 seconds so that every fifth screen display will be output to decrease the amount of data written to the file.

The default value is 2 seconds.

 

The different commands in TM1TOP window:

 

N = Displays TM1 Top normal (thread status) mode.

S = Displays TM1 Top sandbox mode.

Q = Displays TM1 Top queue mode.

W = Writes the current TM1 Top information to a file.

X = Exits the TM1 Top utility.

H = Displays help text.

V  = Verifies a TM1 Top administrator session.

Displays a user name and password prompt so the TM1 administrator can log into the current session of TM1 Top and enter commands to cancel processing in other threads.

 

C = Cancels processing in another thread.

Note: Before using the Cancel command, an administrator must first log into the current session of TM1 Top by using the V (Verify) command.

 

K = Cancels a sandbox submission in the job queue for a specific job ID number.

Requires administrator login with the V (Verify) command.

 

Up, Down arrow keys = Use the up and down arrow keys to scroll the status display if there are more lines in the status than the height of the console window.

 

 

More Information

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

Product:

Cognos TM1 10.1

Windows 2008 R2 Server

 

Symptom:

Start a new TM1 server and try to connect to it with the TM1 Architect program.

You get a error after you have enter name and password.

 

Error message:

The specified server is not found

 

Solution:

If the error message “The specified server is not found” is before the login dialog in TM1 Architect then the local firewall is blocking the TM1 port.

 

Go to Windows Firewall with Advanced Security

Go to Inbond rules

Create a rule to allow local TCP port “12346” to any ip address.

Enable it and restart the firewall.

 

If the error message “The specified server is not found” is after the login dialog in TM1 Architect then there is some other process using the same port.

 

Stop the TM1 service.

Open Tm1s.cfg in notepad

Check the port number used by TM1 application server at line PortNumber=12346

Start a commando prompt (cmd)

Enter netstat to find if that port is in use by enter below command:

netstat -a | find “12346”

 

If no row is shown, then the port is free to use.

 

If you see below row – then it is occupied, and you need to use other port.

TCP 0.0.0.0:12346     SERVERNAME:0    LISTENING

 

Change if needed port in TM1S.CFG and start the TM1 service.

 

More Information:

If you move a TM1 application to a new server, you need to check this lines in the TM1s.cfg file to ensure they point to the correct value for the new environment.

 

IntegratedSecurityMode=5 You can try mode 1 if you have problems to login.

ServerName=  Should be the same, the name of the TM1 application in architect

DataBaseDirectory= Should be the folder path to the datafiles (often same as before)

LoggingDirectory= Should be the folder path to the logfiles (often same as before)

AdminHost= Should be the new TM1 admin servername

PortNumber= Should be the same number, if it is available on the new server

ServerCAMURI= Should be changed to the new Cognos BI server’s dispatch address

ClientCAMURI=  Should be changed to the new Cognos BI server’s gateway

Product:

Cognos TM1 10.2

PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5000.367-0

LICENSE_TM1_version=LICENSE_TM1-AW64-ML-RTM-10.2.5001.0-0

Windows 2008 R2 Server

Cognos BI

Symptom:

Can not login to Cognos TM1 when using CAM security.

It works when using the TM1 native security.

Error message:

The forward URL does not exist or it has failed validation. Ensure that a valid forward URL is specified.

Cause:

The file variables_tm1.xml is on the wrong BI server.

 

Solution:

Copy your updated variables_tm1.xml file to all your Cognos BI servers in your solution.

Place the file in folder \\biservername\d$\Program Files (x86)\ibm\cognos\c10_64\templates\ps\portal

 

In short is the installation to get CAM to work for TM1 10.2 web different from previous version.

 

Unzip the D:\Program Files\IBM\cognos\tm1_64\webapps\tm1web\gateway_files\ tm1web_gateway.zip files.

Rename d:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\gateway_files\tm1web_gateway\templates\ps\portal variables_TM1.xml.sample to variables_TM1.xml.

Update variables_tm1.xml with the TM1 server name at line 23 instead of localhost:

<CRNenv>

<urls>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLogin.aspx</url>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebLoginHandler.aspx</url>

<url is-regex=”true”>http://localhost/TM1Web(/\([aAsS]\([A-Za-z0-9]+\)\))?/TM1WebMain.aspx</url>

<url>../tm1/web/tm1web.html</url>

</urls>

<cookies>

<param name=”cam_passport”/>

</cookies>

</CRNenv>

 

Update the tm1web.html file to Cognos TM1 Web server name at line 40:

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

var tm1webServices = [“http://localhost:8080”];

Change to:

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

 

Copy the files to your Cognos BI installation:

variables_TM1.xml = Copy to d:\Program Files\ibm\cognos\c10_64\templates\ps\portal templates\ps\portal on your Cognos BI report server and content manager server.

Tm1web.html = Copy to d:\Program Files\ibm\cognos\c10\webcontent\tm1\web on your Cognos BI gateway server.

 

In tm1s.cfg file you need for each TM1 application add the values for:

 

ServerCAMURI=http://biservername:9300/p2pd/servlet/dispatch

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

ClientPingCAMPassport=900

CAMPortalVariableFile=portal\variables_TM1.xml

DistributedPlanningOutputDir=.\tunit

ForceReevaluationOfFeedersForFedCellsOnDataChange=T

AllowSeparateNandCRules=T

 

The value CAMPortalVariableFile is not needed in the TM1S.CFG file for tm1web to work.

 

More (same) 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

Product:

Cognos TM1 10.1.1

Windows 2008 R2 server

Cognos BI 10.1.1 CAM security

Symptom:

When you surf to TM1 application web you get a error when you try to sign in.

(http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll?…)

You have upgrade or installed a new TM1 10.1.1 server and connected it with a existing Cognos BI installation.

Error message:

PRS-PRH-0221

The file “portal\variables_plan.xml” could not be opened.

Cause:

The variables_plan.xml file is not on the correct location on the Cognos BI server.

 

Solution:

On the TM1 server find the folder D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\gateway_files

Unzip the file planning_gateway.zip to your Cognos BI server and your Cognos BI gateway server.

 

This should give that the files come to this folders:

planning.html  should in folder …\c10\webcontent

variables_plan.xml should in folder …\c10\templates\ps\portal

icon_active_application.gif  should in folder …c10\webcontent\ps\portal\images

Update the planning.html file to contain the name of the TM1 server at line 38

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

var planningServices = [“http://tm1server.domain.se:9510”];

 

More information:

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

Product:

Cognos TM1 10.1.1 Perspective

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

Windows 2008 R2 server

Microsoft Office 2010 32 bit  version 14.0.6023.1000

Symptom:

When you start TM1 perspective on a new computer you get a error message, and can not load TM1 perspective into Microsoft Excel 2010.

Error Message:

Could not load an object because it is not available on this machine.

Compile error in hidden module: MenuFuncs.

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “Help” for information on how to correct this error.

 

Cause:

http://support.microsoft.com/kb/2597986

 

Solution:

Find the correct MSCOMCTL.OCX file from a different computer, where TM1 perspective is working with Microsoft Excel 2010.

 

Correct version is dated 2012-06-06 8:49 AM and 1046 KB in size.

File version 6.1.98.34

Product version 6.01.9834

 

On the computer where you have the problem.

Exit Excel

Go to folder %systemroot%\sysWOW64

Rename file mscomctl.ocx to mscomctl.ocx.old.txt

Copy the correct mscomctl.ocx fil to folder c:\windows\syswow64

Start a cmd prompt with “run as administrator”

Enter cd %systemroot%

Enter cd syswow64

Enter regsvr32 /u mscomctl.ocx

Click OK on dialog

Enter regsvr32  mscomctl.ocx

Click OK on dialog

 

Start Tm1 Perspective again and test.

Product:

IBM Cognos TM1 10.1.1

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

Performance Modeler

Windows 2008 R2 server

Symptom:

When adding CAM users in Cognos TM1 Performance Modeler, you get a error message when you click on CANCEL in the add user dialog (this is the dialog showing the Cognos and namespace groups from the Cognos connection portal security tab).

Error message:

Internal Application Problem

There was an internal application problem. Try to save your work and exit the application. Check console for complete stack trace.

java.lang.NullPointerException

at

com.ibm.mdt.widgets.cube.actions.AddGroupAction.run(AddGroupAction.java:110)

at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)

 

Solution:

Instead of adding user by right click on the list of users inside Performance Modeler, use the icon in the toolbar at the top to add users, or add groups.

By using the icon for this function, it will work better.

The context menu can in some cases give errors.

Product:

TM1 10.1.1

Operations Console

Windows 2008 R2 server

 

Symptom:

Try to login to a Operations Console session, you have enter the following:

adminhost: localhost

servername: planning sample

group: cognos\admin

username: admin

password: apple

 

Error message:

The specified group does not exist on the server

 

Cause:

Operations Console may have problems with group names that contain a \ backslash or other characters. Recommendation to use simple group names like  MONITOR or ADMIN.

 

Solution:

Start TM1 Architect and add a group with name MONITOR

Add users to this group MONITOR that should be allowed to MONITOR the TM1 application.

Exit Architect.

 

Update the D:\Program Files\ibm\cognos\tm1_64\webapps\tm1operationsconsole\WEB-INF\configuration\ OpsConfig.xml file to reflect the change of group.

 

<?xml version=”1.0″ encoding=”UTF-8″?>

<Ops>

<AdminHost name=”localhost”>

<Server name = “Planning Sample”>

<Group>MONITOR</Group>

</Server>

</AdminHost>

<DashboardRefreshRate>5</DashboardRefreshRate>

<EnhancedStatusDetail>true</EnhancedStatusDetail>

</Ops>

 

Opsconfig.xml should look like above. Save the file.

You may need to change localhost with your servername, and planning sample if you want to use a different TM1 application as security container for Operation Console.

 

Go to Windows services and restart the “IBM Cognos TM1 Application Server” to make changes take affect.

Surf to http://localhost:9510/tm1operationsconsole/ to test the change.

Product:
Cognos TM1 10.1.1
Operations Console
Windows 2008 R2 Server

Symptom:
Can not login to Operations Console using a CAM id.

Problem:
An error occurred in authentication

Solution:
You must enter the namespace id before the username;
like this LDAP\kalle instead of entering kalle
You can check the namespace spelling inside TM1 Architect:
Login to TM1 application from Architect
Right click and select security – client/groups
Then in the left username field you see how you should write the username to operations console.
LDAP\kalle

LDAP is replaced by the Cognos BI namespace name you created in Cognos Configuration for BI.
kalle have to be replaced by your user name.

More information from IBM:
The current documentation on installing and using the Cognos TM1 Operations Console 10.1 does not explicitly state that CAM is not supported for authentication when logging on to the Operations Console. You must use native TM1 authentication to log on to the Operations Console.

However, though native TM1 authentication is required to log on to the Operations Console, the Operations Console can monitor any TM1 server that is configured to use CAM to manage user access.

Additionally, though you can monitor a TM1 server that is configured to use CAM, you cannot use the Operations Console to kill a thread for such a server. The Operations Console allows you to kill threads only for servers that use native TM1 authentication.

“For the error “An error occured in authentication”, if the user does not have enough free connections this error will be generated. Operations Console (OpsConsole) takes up an extra port, so if the user only has, let’s say 2 connections allowed, and they are already logged in to Perspectives and also to TM1Web, then their 2 connections are used up so they will get this error when attempting to log in to OpsConsole. Check the MaximumPorts for the user in the }ClientProperties cube to verify if this is the problem. If not practical to increase the maximum number of ports, then the user will need to log out of one of the other applications in order to log into OpsConsole.

That error can also be caused if the user is not using the correct namespace. This should be the Namespace ID that is noted in Configuration Manager, not the name of the namespace that is outside of Cognos BI. For example, if there is an AD namespace (outside of Cognos) and the Namespace ID is Cognos, the login to use would be Cognos\username (Cognos\jdoe) not AD\username.

For “The specified group does not exist on the server”, this would only be an issue if using CAM authentication. There is a defect where this error occurs if the group being used is the alias for the group rather than the actual name of the group – doing this will generate this error.

For example, if the group Cognos\Everyone (the alias name) is used in the OpsConfig.xml and then used to attempt to log in to OpsConsole, this error will be encountered. Instead, it is necessary to use CAMID(“xxxxx.com:x:xxxxxxEveryone”), which should not generate the error. The defect asks for this to function the same as the username, which requires the alias and not the actual name (just the opposite). At this writing there is no target date as to when this may be fixed, and no APAR was generated because this was detected in-house, not through a customer. The workaround suggested should allow functionality.”

http://www-01.ibm.com/support/docview.wss?uid=swg27034273

http://www-01.ibm.com/support/docview.wss?uid=swg21610251

http://www-01.ibm.com/support/docview.wss?uid=swg21620207