Product:

Cognos TM1 9.5.2

Windows 2008 R2 server

 

Symptom:

TM1 application does not start.

In task manager the CPU usage is at 6% and the tm1sd application have a memory working set of 4840 Kb.

There are no error messages, or any new log files in the log folder for tm1.

 

Background:

You have moved a TM1 application from ONE server to a NEW server.

(this by coping the DATA folder from the old TM1 server)

You have updated the tm1s.cfg file with admin host and port number and log files paths.

You have register the TM1 application as a service with commando:

d:\program files\cognos\tm1\bin\tm1sd.exe -install -n TM1applicationname -z “d:\tm1data\TM1applicationfoldername”

(above path need to be modified to conform with your environment)

You have set the TM1 service to use a windows service account to start the service.

 

Cause:

The windows service account is not local admin on the new TM1 server.

Solution:

Add the windows service account to local administrator group and restart the service.

Start server manager

Go to Configuration

Go to Local Users and Groups

Go to Groups

Open Administrators

Click Add

Enter name of service account

Click Check Names

Click OK

Click OK

Product:

Cognos TM1 10.2.2

Microsoft Windows 7

Problem:

How update several workstations with the new TM1 certificates?

Solution:

If the users are allowed to run a POWERSHELL script, then something like this may solve the issue:

(you need to adjust PATH for your environment)

# the new certs need to be unziped in folder C:\NewSSLCerts
$strPath = “C:\Program Files\ibm\cognos\tm1_64\bin64\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath

     $CMD = $strPath + ‘importsslcert.exe’
     $arg1 = ‘-remove’
       & $CMD $arg1
     & $CMD

}Else{
  # // File does not exist
}

#  only copy the files to other folders
$strPath = “C:\Program Files\ibm\cognos\tm1_64\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

#  only copy the files to other folders like 32 bit version
$strPath = “C:\Program Files (x86)\ibm\cognos\tm1\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

#  only copy the files to other folders like other drive
$strPath = “d:\Program Files (x86)\ibm\cognos\tm1\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

 

More Information:

http://stevehardie.com/2013/04/powershell-check-if-file-exists/

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

http://ss64.com/ps/copy-item.html

Product:
Cognos Controller FAP 10.1.1
Windows 2008 R2 Server
Cognos TM1 10.2.2
Oracle database

Issue:
In a multi server setup, when you try to connect to the TM1 server from a terminal server where Cognos TM1 Architect is installed, you get the list of TM1 servers, but when you click on ONE TM1 server ( for example the one called FAP ) then there is no login. Only a not responding message for some time, and then you are back inside TM1 Architect.
If you use TM1 Architect on the same server as where TM1 is installed, then it works fine.

Possible Solution:
There are two networks cards in the TM1 server machine. One network card for access by clients, and the other network card for the company backup routines.
TM1 server will bind and only use the first network card found on the Microsoft Windows 2008 server. And if that is not the card used by clients, you will get this issue.
Go to Control Panel
Go to Network and Sharing Center
Click Change adapter settings
Press the ALT key to get menus on top in the dialog
Select Advance – advance settings from the menu
In adaptor and bindings dialog for connections you see two networks listed
Mark the one that belongs to the client network ( it may start with ip 10 ) and click on the up arrow icon on the right.
Click OK
Close the dialog.
Restart the TM1 services, and test again from TM1 Architect on the Terminal server or client computer.

Product:
Cognos TM1 10.2.2
Windows 2008 R2 Server

Issue:
How do I copy a cube from on TM1 server to another TM1 server in a different environment? The 2 TM1 servers are part of two different BI installations, they use the same Active Directory for authentication, and there are no firewall issues between the servers.

Possible Solution:
Use a ODBO connection in Cognos TM1 Architect to create the copy.
Start TM1 Architect and log in to the receiving TM1 server.
Right click and select to create a new process.
Select Datasource type: ODBO – cube.
In connection you need to enter this information:
ODBO Provider: IBM Cognos TM1 OLE DB MD Provider
ODBO Location: servername.domain.com (servername of the windows host that have TM1 admin service)
ODBO Datasource: FAP (name of the TM1 server where you want to get data from)
ODBO Catalog:
ODBO UserID: username (name of the admin user in TM1 application)
ODBO Password: password
Additional Connection Parameters: Provider String=”CAMNamespace=CDS”
The additional Connection Parameters is only if you have a TM1 application that use CAM/BI authentication – enter the name of the Cognos BI namespace, in our example CDS.
Click on CONNECT button – if no errors then you wrote the correct values above.
Go to Load ODBO Cube dialog tab
Select ODBO Cube to load from: FAPMonthlyCompanyDetails (or any other cube you want to import)
Select TM1 Cube to load to: FAPMonth (or any other name you have for it)
Cube Type: Physical Cube
TM1 Cube Action: Create Cube
Data Action: Store Values
Click on Cube Dimensions dialog tab
Here you can change what dimensions the values should connect to, or let the import create the new dimensions in your TM1 receiving server.
Click on MDX Query tab
Here you should be possible to adjust the MDX if you need to.
Click SAVE icon to save the process, give it a name like: FAP import from external server
Run the process.
Depending on the size of the TM1 Cube this can take some time.
When done you should have a copy of the cube and the dimensions.

More Information:
http://blog.tm1tutorials.com/2012/07/27/automating-data-transfers-between-tm1-servers/
http://blog.tm1tutorials.com/tag/odbo/

Product:
Cognos TM1 Architect 10.2.2
Windows 2008 R2 Server
Oracle database
Problem:
When importing data from an ODBC oracle database, the preview in TM1 Architect is blank. You see the columns name, but no data.
You use a query statement like this SELECT * FROM IA_RUNREPORT;
Solution:
One of the columns in oracle database is in the format TIMESTAMP, and that is not considered a number or a string by TM1. You must then in your SQL statement convert that to a STRING.
Use this command:
TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”,

So then your SQL statement inside TM1 TI process Data Source Query should be something like this:
SELECT RUN_ID, ENV_ID, SOLUTION_ID, USER_ID, TIME_ID, CONTENT_ID, USERNAME, NAMESPACE, USERID, CAMID, REPORTPATH, TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”, TARGET_TYPE, STATUS, ERRORDETAILS, RUNTIME, PACKAGE, HOST_IPADDR, PROC_ID, SESSION_ID, REQUEST_ID, TIMEZONE_OFFSET, THREADID FROM IA_RUNREPORT;
Check in your Oracle data source with SQL Developer if there are any column that is not in NUMBER or VARCHAR format, because that you need to take care of in the import SQL statement to TM1.

Product:

Cognos TM1 10.2.2

Windows 2008 R2 Server

 

Problem:

How create the measure dimension in a TI process?

And not use the TM1S.CFG parameter DefaultMeasureDimension=T

That will make the last dimension the measure dimension at every cube creation.

http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SS9RXT_10.1.0/com.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc/c_defaultmeasuresdimension_tm1.html%23DefaultMeasuresDimension_tm1

 

Solution:

Go into TM1 Architect and create a new TI process;

In PROLOG set some parameters for the cube.

#—————————–

# set default values

#——————————-

cCubeName = ‘IA.WLicensUsage’ ;

cDimParameter = ‘IA.WUsers’ ;

cDimMeasure=  ‘IA.WLicens’ ;

In EPILOG set this command

cellputs (cDimMeasure, ‘}CubeProperties’,cCubeName,’MEASURES_DIMENSION’);

 

Change the variables names to fit with your cube and dimensions names.

Product:

Cognos TM1 10.2.2

Microsoft Windows 2008 R2

 

Symptom:

The TM1 admin service do not start (tm1admsdx64).

If you look into the Windows Event log you find this message;

 

Event log message:

Log Name: Application

Source: Application Error

Date: 8/1/2015 12:32:16 AM

Event ID: 1000

Task Category: (100)

Level: Error

Keywords: Classic

User: N/A

Computer: servername.domain.com

Description:

Faulting application name: tm1admsd.exe, version: 10.2.20100.123, time stamp: 0x5423612c

Faulting module name: MSVCR100.dll, version: 10.0.40219.1, time stamp: 0x4d5f034a

Exception code: 0x40000015

Fault offset: 0x00000000000761c9

Faulting process id: 0x6d8

Faulting application start time: 0x01d0c3b20308c42b

Faulting application path: C:\Program Files\IBM\Cognos\tm1_64\bin64\tm1admsd.exe

Faulting module path: C:\Program Files\IBM\Cognos\tm1_64\bin64\MSVCR100.dll

Report Id: fe71016e-37d3-11e5-bd34-0050569d5f35

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=”2015-07-31T22:32:16.000000000Z” />

<EventRecordID>105927</EventRecordID>

<Channel>Application</Channel>

<Computer>servername.domain.com</Computer>

<Security />

</System>

<EventData>

<Data>tm1admsd.exe</Data>

<Data>10.2.20100.123</Data>

<Data>5423612c</Data>

<Data>MSVCR100.dll</Data>

<Data>10.0.40219.1</Data>

<Data>4d5f034a</Data>

<Data>40000015</Data>

<Data>00000000000761c9</Data>

<Data>6d8</Data>

<Data>01d0c3b20308c42b</Data>

<Data>C:\Program Files\IBM\Cognos\tm1_64\bin64\tm1admsd.exe</Data>

<Data>C:\Program Files\IBM\Cognos\tm1_64\bin64\MSVCR100.dll</Data>

<Data>fe71016e-37d3-11e5-bd34-0050569d5f35</Data>

</EventData>

</Event>

 

 

Possible Cause:

Some time before you find message in Windows event log about

Event ID: 2013

Description:

The D: disk is at or near capacity. You may need to delete some files.

and you check the D drive to find there is very little space free.

Erase some file to free some GB and restart of server to see if that helps.

 

Possible Solution:

On TM1 servers, change the Virtual Memory for Windows 2008, to not be System Managed and instead set it to be fixed at the same level as the amount of RAM in the server.

Go to Control Panel – System – Advance system settings

Click Settings button for Performance

Click the Advanced tab

Click Change for Virtual Memory

In Virtual Memory dialog

Click on hard drive e.g. D:

Click Custom Size and set a value of

initial size to 8192 MB

maximum size to 33791 MB

(values depend on your hardware).

Click SET.

Click OK.

Restart the Windows server.

Product:
Cognos TM1 10.1.1
Windows 2008 R2
Internet Explorer

Symptom:
When user from TM1WEB try to export a view to excel using “snapshot to excel” nothing happens. Sometimes there are text in the dialog to select report heading that says “inactivate translation”. Restart of IE or change of language settings does not help.

Solution:
There is a add on installed in your browser, that prevents TM1WEB to send to Excel.
Look at the top of your browser window – if there are a extra line of buttons you may have a add on toolbar. In one case it was “Google Toolbar” that gave the problem.
Turn off Google Toolbar by click on the left “x” and select permanent deactivate Google toolbar.

More information:
https://en.wikipedia.org/wiki/Google_Toolbar
https://support.google.com/toolbar/answer/9231?hl=en&ref_topic=1727206&vid=1-635757569835073343-1277689272

https://support.google.com/toolbar/answer/146786?vid=1-635757566323118119-1277689272

Product:
Cognos TM1 performance modeler 10.2.2
Windows 2012 R2
RDP server (terminal server)

Symptom:
You start Performance modeler local on the terminal server and connects to the TM1 server.
When you select “import data” you get a error message. But after the message (you click OK one) then you get your drive dialog to select a txt file.

You get same error if you from Excel on same server select File – Open.

“This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator”.

Solution:
This is by setup on the Terminal server. You should not have access to the C drive.
This is a normal behavior.

Ask the Terminal Server administrator for a better behavior.

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

Product:
Cognos TM1 10.2.2
Windows 2012 R2

 

Problem:
How run TM1TOP on a windows 2012 server from a bat file?

 

Solution:
Create a new folder on you TM1 server, e.g. D:\TM1TOP

 

Copy the 3 files to a separate folder on your TM1 server.
Tm1top.exe file from a earlier version of TM1.
tm1top.ini should be updated to contain the values for you TM1 server, or as below.

 

# The possible fields which can be set in this file are listed below.  Note that the
# field names are not case sensitive.  For example AllowMultiModes and allowmultimodes
# are equivalent.
#
# adminhost – admin server, default is localhost
# servername – TM1 server name
# logfile – log the status line to a log file
# logperiod – time(sec) that the status lines are written to the log file
# logappend [T,F] – When a new session is started should the log data be
#        appended to the log file specified by logfile
# refresh – time(sec) that the display is refreshed. Default is 2 seconds
# adminsvrsslcertid – SSL admin certificate ID, default is tm1adminserver
# adminsvrsslcertauthority – SSL admin server certificate Authority file,
#        default is in the ssl directory
# adminsvrsslcertrevlist – SSL admin server certificate revocation file
# exportadminsvrsslcert – export the admin server SSL certificate
# adminsvrsslexportkeyid – id used to export the admin server SSL certificate

 

adminhost=

servername=

logfile=

logperiod=

logappend=

refresh=

adminsvrsslcertid=

adminsvrsslcertauthority=

adminsvrsslcertrevlist=

exportadminsvrsslcert=

adminsvrsslexportkeyid=

 

# AllowMultiModes=[T,F]

# If AllowMultiModes is set to T, TM1Top supports additional display modes that show details of Sandbox

# and Job Queue operation.  The mode is selected when TM1Top is running by processing one

# of the following keys:  (N=Normal, S=Sandbox, Q=Job Queue)

# The default value if AllowMultiModes is not specified is T.

AllowMultiModes=

 

# DisplayMode (N=Normal, S=Sandbox, Q=Job Queue)

# DisplayMode selects the display mode that TM1Top that is in effect when TM1Top starts.

# The default value if this configuration entry doesn’t exist in the file is N for Normal mode.

DisplayMode=

 

Create a tm1topfap.bat file to start the session. It can contain values like this;

tm1top -servername “FAP” -refresh 1

pause

 

Save the bat file and run it – if it works you should have a white dos dialog that show tm1top: -adminhost localhost -servername FAP -refresh 1

 

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

 

More information:

http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page674/index.html

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