Product:
Cognos TM1 10.2
Windows 2008 R2 Server

Symptom:
TM1 application web is slow and it is resolved by restarting the TM1 Application service (tomcat).

Possible Solution:
1) In IBM Cognos Configuration of TM1, select Environment >TM1 Application Server, and increase “Maximum Memory in MB” from 768 to 1024 or 1536. The maximum that it can be set from this GUI is 4096 (in version 10.1x) – if set that high, be sure that the server has enough memory available to accommodate it. Restart the TM1 Application Server.

NOTE: In versions 10.2x the memory can be set higher than 4096 through the Cognos Configuration GUI – but, again, make sure there is enough RAM on the machine to accommodate it.

2) Launch the Apache Tomcat manager GUI from the cmd line (run the command prompt by using Run as Administrator) and navigate to the install directory for TM1 and the Tomcat bin folder (eg: C:\Program Files\ibm\cognos\tm1_64\tomcat\bin).
Type this:
tomcat6w.exe //ES//pmpsvc
Navigate to the Java tab, and in the Java Options window, navigate to the bottom of the options list and add in the following:
-Xgcpolicy:gencon
(the default garbage collector policy is “optthruput”)
Validate and close the window and restart TM1 Application Server.

Below is the list of default values for the TM1 Tomcat java:
-Dcatalina.base=C:\Program Files\ibm\cognos\tm1_64\tomcat
-Dcatalina.home=C:\Program Files\ibm\cognos\tm1_64\tomcat
-Djava.endorsed.dirs=C:\Program Files\ibm\cognos\tm1_64\tomcat\common\endorsed
-Djava.io.tmpdir=C:\Program Files\ibm\cognos\tm1_64\tomcat\temp
-Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true
-Xmx768m
-XX:MaxNewSize=384m
-XX:NewSize=192m
-XX:MaxPermSize=128m
-Dcom.sun.management.jmxremote.port=7999
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=true
-Dcom.sun.management.jmxremote.password=false
-Djmx.remote.x.server.connection.timeout=1000

NOTE: If you set the properties using the Apache Tomcat administration tab, start the TM1 Application Server using the Component Services option–do not use Cognos Configuration in that case as Cognos Configuration then resets the properties back to the shipped defaults.

3) If the server is a Virtual Machine (VMWare, ESXi) then go to Windows Control Panel, System and Security, Power Options, and change the power plan from “Balanced” to “High performance”.

4) Add exclusions to the antivirus to prevent “C:\Program Files\ibm\cognos\tm1_64\tomcat” and “C:\Program Files\ibm\cognos\tm1_64\webapps” from being scanned. Skipping scanning of all TM1 files is preferred – see below link.

5) Verify DEP is set to “Essential Windows programs and services only”. To do this : Right-click the”Computer” icon on your desktop, select “Properties”, select “Advanced System Settings”, select “Advanced” tab, under “Performances”, “Settings” button, “Data Execution Prevention” tab.

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

Product:
Cognos TM1 10.2.2
Microsoft Windows 2008 R2 server

Problem:
When users surf to TM1 Application Web and login they do not see the icons needed to start Performance Modeller nor do administration work. If some other user surf and login they see the icons needed.
http://tm1applicationservername.domain.com:9510/pmpsvc/
Possible Solution:
The user is not ADMIN in the published TM1 applications in TM1 application web.
When you login to TM1 application Web at address http://servername.domain.com:9510/pmpsvc/applications.jsp, you are assumed to be Administrator and also be administration inside the TM1 applications connected to the portal.
Normal end users that report values to TM1 applications should start the TM1 Application Web client from clicking on the link in Cognos Connection under IBM Cognos TM1 Application – My Applications folder.
Solve by make the Planning Sample a CAM used application.
Stop Planning Sample service.
Change to IntegratedSecurityMode=2 in C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp\TM1S.CFG file
Add the values that point to your BI servers in your TM1S.CFG file.
# CAMURI parameters have to be set to correct BI environment
ServerCAMURI=http://BIdispatcherservername.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://BIgatewayservername.domain.com/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=900
Save the file and start the Planning Sample service.
You also need to make some changes on the BI servers to get TM1 CAM to work.
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/tm1_inst.pdf

Added all TM1 developers, for all existing and new TM1 applications, to the Planning Sample application.
First update the C:\Users\%username%\AppData\Roaming\Applix\TM1\TM1P.INI file with the value to the BI servers.
AdvancedRulesEditor = T
AllowImportCAMClients = T
CognosGatewayURI = http://BIgatewayservername.domain.com/ibmcognos/cgi-bin/cognosisapi.dll
Save the file.
Start TM1 Architect and click on Planning sample to login as Admin.
Right click on planning sample and select security – clients/groups.
Click on Clients – add new clients.
You should get the Cognos Connection security page up so you can search your AD/LDAP domain for the users you want to add.
Click on your Active Directory folder.
Click on search in top right corner.
Enter the name of the user (this must be correct spelled)
Select Find text in Name and Description field.
Click search.
Mark the user and click arrow to add the users.
Click OK.
The users are added last in the Clients/groups on planning sample dialog.
Mark the user as ADMIN with a X in the column for ADMIN.
Click OK.
Select save data from menu and exit TM1 Architect.
Now you need to stop the TM1 service for Planning sample.
Change the TM1S.CFG file to IntegratedSecurityMode=5
Start the TM1 service for Planning sample.
Add planning sample to the IBM Cognos TM1 Applications site.
Add these values to TM1S.CFG file to make it work good in TM1 applications web;
DistributedPlanningOutputDir=tunit
PersistentFeeders=T
ForceReevaluationOfFeedersForFedCellsOnDataChange=T
AllowSeparateNandCRules = T
ParallelInteraction=T
ProportionSpreadToZeroCells=T
AllRuleCalcStargateOptimization=T
Surf to http://tm1servername.domain.com:9510/pmpsvc
Login as a person who already is administrator in TM1 applications there.
Click on the icon far to the right, Administer IBM Cognos TM1 Applications.
In the new page, under Server Names: click ADD
Enter the name of the TM1 host server as admin host.
Select Planning Sample from the drop down list and click OK.
Exit Internet Explorer.
Surf to applications web, click on the icon for performance modeller and now you should be able to select Planning Sample in the dropdown menu when performance modeller starts.

Then next time a user logins – he is an administrator in planning sample application and can start to create the IBM Cognos TM1 Applications for Web.

Product:

LICENSE_TM1-AW64-ML-RTM-10.2.5200.2-0

SWTAG_TM1-AW64-ML-RTM-10.2.5200.1-0

PLANANALYTICS-AW64-ML-RTM-10.2.5200.234-0

IBM Cognos TM1 10.2.2

Symptom:

When log in to TM1 application Web the session loops in Internet Explorer 8.

Error message:

No error message.

The URL in Internet Explorer is something like this;

http://ServerName3002.CompanyDomainName.com/ibmcognos/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/bridge.xts&c_env=portal/variables_plan.xml&c_cmd=../planning.html&ps=http%3A%2F%2FServerName0015.CompanyDomainName.com%3A9510&pg=%2Fapplications.jsp

http://ServerName3002.CompanyDomainName.com/ibmcognos/planning.html?cam_passport=MTsxMDE6MThkODU1N2EtZGQ4ZS05YzVkLTUxZTktNDZlMmZjOGUxZDEzOjIyMjgwMjg1ODU7MDszOzA7&CRN=contentLocale%3Den%26columnsPerPage%3D3%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2Fconstants%2FbiDirectionalOptionEnum%23biDirectionalFeaturesEnabled%3Dfalse%26productLocale%3Den%26showOptionSummary%3Dtrue%26showWelcomePage%3Dtrue%26skin%3Dcorporate%26linesPerPage%3D15%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2Fconstants%2FsystemOptionEnum%23accessibilityFeatures%3Dfalse%26listViewSeparator%3Dbackground%26displayMode%3Dlist%26timeZoneID%3DEurope%252FStockholm%26format%3DHTML%26showHiddenObjects%3Dfalse%26useAccessibilityFeatures%3Dfalse%26automaticPageRefresh%3D30%26&pg=%2fapplications.jsp&ps=http%3a%2f%2fServerName0015.CompanyDomainName.com%3a9510

Solution:

Erase values in file fpmsvc_config.xml to start over again. It points to wrong BI server.

fpmsvc_config.xml file is found in folder C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration on the server where IBM Cognos TM1 Application Server (TM1WEB) is installed.

You must only point to the BI Content Manager as <dispatcher uri=.

When setting up TM1 10.2.2 with Cognos BI 10.2.1 security you need to have this files updated;

TM1 server C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ fpmsvc_config.xml

TM1 server C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ pmpsvc_config.xml

Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\ planning.html

Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\ pmhub.html

Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\tm1\web tm1web.html

Cognos BI report server C:\Program Files\ibm\cognos\c10_64\templates\ps\portal variables_TM1.xml

Cognos BI report server C:\Program Files\ibm\cognos\c10_64\templates\ps\portal variables_plan.xml

On Cognos BI report server open tm1_contribution.atom file in notepad from folder C:\Program Files\ibm\cognos\c10_64\configuration\icd\contributions\contrib\ tm1_contribution.atom to add the TM1 application.

On Cognos BI report server open tm1_en.properties file in notepad from folder C:\Program Files\ibm\cognos\c10_64\configuration\icd\contributions\contrib\ tm1_en.properties to add the Title of TM1 application to show in Cognos Workspace tool.

 

The files are updated with values like this;

In tm1web.html you need to add the TM1 Application Web server.

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

var tm1webServices = [“http://ServerName0015.CompanyDomainName.com:9510″];

In variables_TM1.xml you need to add the TM1 Application Web server.

<urls>

<url is-regex=”true”>http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebLogin.aspx</url>

<url is-regex=”true”>http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebLoginHandler.aspx</url>

<url is-regex=”true”>http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebMain.aspx</url>

 

 

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

</urls>

In variables_plan.xml is not changed by you, but it is different than previous TM1 version.

In pmhub.html you need to add the TM1 Application Web server.

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

var pmhubURLs = [“http://ServerName0015:9510″,”http://ServerName0015.CompanyDomainName.com:9510”];

In planning.html you need to add the TM1 Application Web server.

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

var planningServices = [“http://ServerName0015.CompanyDomainName.com:9510”];

 

In fpmsvc_config.xml you normal not need to add anything as it is updated the first time you surf to http://tm1webservername:9510/pmpsvc, but it can look like this;

 

<?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://ServerName0015.CompanyDomainName.com:9410/bv”/>

 

<scorecarding enabled=”true”/>

 

 

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

 

<resource path=””/>

 

<users path=””/>

 

<external uri=”http://ServerName0015.CompanyDomainName.com:9510″/>

<session timeout=”65″/>

</service>

<tm1>

 

<gateway uri=”http://ServerName3002.CompanyDomainName.com/ibmcognos/cgi-bin/cognosisapi.dll”/>

 

<alternate_gateway_uris>

<alternate_gateway uri=”*”/>

</alternate_gateway_uris>

<dispatcher uri=”http://ServerName0014.CompanyDomainName.com:9300/p2pd/servlet/dispatch”/>

<admin_host name=”SERVERNAME0020.CompanyDomainName.com”>

<servers>

<server name=”Tm1 application name …”/>

</servers>

</admin_host>

</tm1>

 

<!–

The Cognos Insight publish feature enforces a set of minimum system requirements that are required to perform a publish. These are requirements on the system running

the TM1 Applications service where the new TM1 servers will be created. To change these system requirement settings add the <insight_publish> element.

maximumCDDDataMB – The maximum amount of TM1 data that can be sent in a publish request

maximumTM1ServersAllowed – The maximum number of servers that can run on this machine. This is the maximum number of servers that are registered with the tm1Admin service.

minimumFreeDiskSpaceMbRequired – The amount of disk space that must be available on the drive where the Tm1 data is published.

minimumFreeDiskSpaceMbRequired – The amount of free memory that must be available on the publish server.

–>

<!–

<insight_publish enabled=”true” maximumCDDDataMB=”100″>

<system_requirements maximumTM1ServersAllowed=”10″ minimumFreeDiskSpaceMbRequired=”5000″ minimumFreeMemoryMbRequired=”500″/>

</insight_publish>

–>

<!– If low on disk space you can set a different drive for the published TM1 server data as an alternative to reducing minimumFreeDiskSpaceMbRequired –>

<!–

<insight_publish enabled=”true” maximumCDDDataMB=”100″>

<tm1Data path=”E:\PublishedServers”/>

<system_requirements maximumTM1ServersAllowed=”10″ minimumFreeDiskSpaceMbRequired=”5000″ minimumFreeMemoryMbRequired=”500″/>

</insight_publish>

–>

 

<insight pmpsvcPingTime=”30″/>

<insight_publish enabled=”false”/>

</fpm_config>

You should only change <session timeout=”65″/> to a higher value than the timeout in Cognos BI server.

 

Product:
IBM Cognos TM1 10.2.2
Windows 2008 R2 server

Problem:
When user start Performance Modeller and after enter the TM1 server and logged on to the BI environment, they get a list of TM1 application that are made available in TM1 application web, after selecting APP1 they get error message:
Access Error
The user “username” does not have sufficient rights to use Performance Modeler.
Solution:
The “username” does not have access inside the TM1 application APP1, this he should not have because he is not part of that APPLICATION. The issue is that you can select from all TM1 applications that are published to TM1 Application Web, but that does not mean that you are listed as a Developer/Admin inside the TM1 application to be able to use Performance Modeler with that TM1 application.
Let the user try to login to some other TM1 application e.g. Planning Sample where you previous have made the “username” a admin in that TM1 application.

More Information:
To be able to work with a TM1 application in Performance Modeler it must first be added to the TM1 application web.
Surf to http://TM1applicationwebservername.domain.com:9510/pmpsvc/applications.jsp
Log in as Administrator in previous published TM1 application.
Click on icon for ”Administer IBM Cognos TM1 Applications”.
Click ADD for the Server Names, to add your TM1 application.
Enter the TM1 server name at Admin Host and select your application from dropdown list.
Click OK.
After it is added – it is not shown in the TM1 application portal, but you can select it when you start TM1 Performance Modeler.

Product:
Cognos TM1 10.2.2
TM1 Perspective
Windows 2008 R2 servers
Citrix servers
Problem:
When start TM1 perspective you get a message in Excel that say:
Insert Smart Card
Please insert a smart card.
And when you click cancel you get this message:
Microsoft Office Excel Security Notice
Microsoft Office has identified a potential security concern.
Warning: This digital signature is invalid and cannot be trusted. The macros will be disabled.
File Path: C:\Program Files (x86)\ibm\cognos\tm1_perspectives\bin\tm1p.xla
Only button is [Disable Macros]
Solution:
Go to Excel Options.
Click Trust Center.
Click Trust Center Settings.
Click Trusted Locations.
Click Add New Location.
Click Browse
Go to C:\Program Files (x86)\ibm\cognos\tm1_perspectives\bin
Click OK
Click OK
Restart Excel and Try again

Product:

Cognos TM1 Architect 10.2.2

Windows 2008 R2 Server

Cognos BI 10.2.1 Fix pack 2

Problem:

Sometimes when try to add users to a existing TM1 application inside TM1 architect you get a crash. After that you need to logoff the computer and login again to maybe be able to not get this crash. The crash happens random, but always when you add CAM users.

Error message:

TM1 Architect has stopped working

-Check online for a solution

-Close the program

Problem signature:

Problem Event Name: APPCRASH

Application Name: tm1a.exe

Application Version: 10.2.20000.50159

Fault Module Name: C8ITKShared.dll

Fault Module Version: 10.2.50.0

…

Error found in Microsoft Event log on client:

Log Name:      Application

Source:        Application Error

Date:          2014-12-09 08:38:56

Event ID:      1000

Task Category: (100)

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      servername.domain.com

Description:

Faulting application name: tm1a.exe, version: 10.2.20000.50159, time stamp: 0x536252da

Faulting module name: C8ITKShared.dll, version: 10.2.50.0, time stamp: 0x51840c06

Exception code: 0xc0000005

Fault offset: 0x000146e0

Faulting process id: 0x3a4

Faulting application start time: 0x01d01382c5a63795

Faulting application path: C:\Program Files (x86)\IBM\Cognos\tm1_architect\bin\tm1a.exe

Faulting module path: C:\Program Files (x86)\IBM\Cognos\tm1_architect\bin\C8ITKShared.dll

Report Id: 6df507c2-7f76-11e4-a9fc-fc15b4179054

Event Xml:

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

<System>

<Provider Name=”Application Error” />

<EventID Qualifiers=”0″>1000</EventID>

<Level>2</Level>

<Task>100</Task>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime=”2014-12-09T07:38:56.000000000Z” />

<EventRecordID>49328</EventRecordID>

<Channel>Application</Channel>

<Computer>servername.com</Computer>

<Security />

</System>

<EventData>

<Data>tm1a.exe</Data>

<Data>10.2.20000.50159</Data>

<Data>536252da</Data>

<Data>C8ITKShared.dll</Data>

<Data>10.2.50.0</Data>

<Data>51840c06</Data>

<Data>c0000005</Data>

<Data>000146e0</Data>

<Data>3a4</Data>

<Data>01d01382c5a63795</Data>

<Data>C:\Program Files (x86)\IBM\Cognos\tm1_architect\bin\tm1a.exe</Data>

<Data>C:\Program Files (x86)\IBM\Cognos\tm1_architect\bin\C8ITKShared.dll</Data>

<Data>6df507c2-7f76-11e4-a9fc-fc15b4179054</Data>

</EventData>

</Event>

 

Possible solution:

Inside TM1 Architect, ensure you use FQDN server names to connect to TM1 servers.

Select File and Options

At login parameters at admin host field ensure you have written servername.domain.com instead of only server name.

Change and try again.

Check that the IBM Cognos TM1 Server version of the file C8ITKShared.dll

is exactly the same as the one on the TM1 Architect client computer.

If they are not the same version, you can get this error.

 

On the client computer you have installed the TM1 client’s files, and the TM1 Architect files in different folders.

Add the path to the TM1 Bin folder for the client files to the PATH variable in Windows.

Right click on My Computer and select  Properties.

Click on Advance System settings

Click on Environments Variables

Mark PATH and click on EDIT.

Add  C:\Program Files (x86)\IBM\Cognos\tm1_api\bin to the Variable Value

Click OK

Click OK

Click OK

Logoff  the computer and login again.

The path to the bin folder can be different in your installation.

Product:

Cognos TM1 10.2.2

Cognos Insight

Windows 2008 R2 Server

Cognos BI 10.2.1

Problem:

When you start Cognos Insight from TM1 Application Web you get a error message.

Error Message:

Unexpected error. Contact your system administrator.

[CCLMsg: system text=’Unable to create the directory app-tempdir: temp

Verify that the directory exists. Verify that the application has permission to access the directory.’]

com.cognos.ccl4j.exceptions.CCLRuntimeException (root com.cognos.ccl4j.exceptions.CCLRuntimeException):

[CCLMsg: system text=’Unable to create the directory app-tempdir: temp

Verify that the directory exists. Verify that the application has permission to access the directory.’]

at com.ibm.cdt.data.model.interfce.tm1.planning.model.Model.getDirpath(Model.java:582)

at com.ibm.cdt.data.model.interfce.tm1.planning.model.Model.getTempDirpath(Model.java:495)

at com.ibm.cdt.data.model.interfce.tm1.planning.model.Model.setApplicationConfiguration(Model.java:488)

at com.ibm.cdt.data.model.interfce.tm1.planning.model.Model.openModelForApplication(Model.java:408)

at com.ibm.cdt.data.model.interfce.tm1.planning.model.Model.openModel(Model.java:162)

at com.ibm.cdt.ui.common.utility.ApplicationConnectionHelper$CDFPlanningDataServer.getApplication(ApplicationConnectionHelper.java:517)

at com.ibm.cdt.ui.common.utility.ApplicationConnectionHelper.getCurrentApplication(ApplicationConnectionHelper.java:108)

at com.ibm.cdt.ui.common.application.CDFDashboardManager.getCurrentApplication(CDFDashboardManager.java:3863)

at com.ibm.cdt.ui.common.application.CDFDashboardManager.getCurrentModelState(CDFDashboardManager.java:3918)

at com.ibm.cdt.ui.common.application.CDFDashboardManager$3.handleCreatedEvent(CDFDashboardManager.java:462)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

at java.lang.reflect.Method.invoke(Method.java:619)

at com.cognos.utils.events.EventSupport$MulticastHandler.invoke(EventSupport.java:332)

at com.sun.proxy.$Proxy5.handleCreatedEvent(Unknown Source)

at com.ibm.cdt.ui.common.application.CDFDashboardManager.createProject(CDFDashboardManager.java:1095)

at com.ibm.cdt.ui.common.tm1.connect.ConnectTm1Helper.relaunchDashboard(ConnectTm1Helper.java:177)

at com.ibm.cdt.ui.common.tm1.connect.ConnectTm1Helper.connect(ConnectTm1Helper.java:98)

at com.ibm.cdt.ui.common.tm1.connect.ConnectTm1Helper.connectToPlanningApp(ConnectTm1Helper.java:106)

at com.ibm.cdt.ui.common.operations.ConnectToPlanningAppOperation.execute(ConnectToPlanningAppOperation.java:45)

at com.ibm.cdt.ui.common.application.CDFApplicationDesktop.execute(CDFApplicationDesktop.java:1603)

at com.ibm.cdt.ui.common.actions.ConnectToTm1Action.connect(ConnectToTm1Action.java:106)

at com.ibm.cdt.ui.common.actions.ConnectToTm1Action.run(ConnectToTm1Action.java:62)

at com.ibm.cdt.ui.common.application.CDFDashboardManager.connectToTM1(CDFDashboardManager.java:1482)

at com.ibm.cdt.desktop.ui.command.ConnectToTM1Handler.execute(ConnectToTM1Handler.java:38)

at com.ibm.cdf.cui.common.commands.CDFCommandService.executeCommand(CDFCommandService.java:54)

at com.ibm.cdf.cui.common.actions.CDFCommandAction.executeCommand(CDFCommandAction.java:92)

at com.ibm.cdf.cui.common.actions.CDFCommandAction.run(CDFCommandAction.java:87)

at com.ibm.cdf.cui.utilities.popup.CDFBaseMenuItem.runAction(CDFBaseMenuItem.java:661)

at com.ibm.cdf.cui.utilities.popup.CDFBaseMenuItem.mouseUp(CDFBaseMenuItem.java:683)

at com.ibm.cdf.cui.utilities.popup.CDFBaseMenuItem$2.handleEvent(CDFBaseMenuItem.java:141)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.filterEvent(Display.java:1262)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1052)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)

at com.ibm.cdt.desktop.Application$6.run(Application.java:262)

at com.ibm.cdt.desktop.Application$1.run(Application.java:97)

at com.ibm.cdt.desktop.Application.start(Application.java:267)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

at java.lang.reflect.Method.invoke(Method.java:619)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)

at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

 

Solution:

Create a TEMP folder at this location

C:\Program Files\IBM\Cognos Insight\bins\bin_10.2.5210.88

The path can be different at your installation, but under the bin folder with versions number create an empty TEMP folder.

Now it is only one TM1 folder below there.

The installation missed to create the TEMP folder.

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