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.

Product:

Cognos TM1 9.5.2

Windows 2008 R2 Server

 

Symptom:

User can not access the TM1 Contributor web site and user can not run Cognos BI reports against TM1 data. But Architect can access the TM1 applications. The Apache TOMCAT service have stopped working.

IT department can not access the Windows 2008, server that run TM1, with Remote Desktop tools, they believe only solution is to reboot physical server.

 

Task Manager report that the Windows server have free memory and free cpu power.

Error message on TM1 server when you try to start notepad:

There is not enough free memory to run this program. Exit one or more programs, and then try again.

 

Possible Solution:

If you have tuned your TM1 application, it may be using features that is using windows system recourses more during heavy use than needed.

Remove the following parameter in your tm1s.cfg file:

LockPagesInMemory=T

or set it to

LockPagesInMemory=F

Then save the tm1s.cfg file

Update all tm1s.cfg file you have on your TM1 server.

Execute SaveAllData from inside TM1 Architect (to ensure no data is lost).

Restart the TM1 services from Windows services (to pickup the change in the tm1s.cfg file).

Monitor the TM1 server during heavy load to see if issue is solved.

 

More Information:

LockPagesInMemory=T locks the TM1 data in memory and take away system resources from the windows system to increase performance of TM1. But the Windows system will get lack of resources on a heavy used TM1 server, and therefore gradual stop the system from working.

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