Product:
Cognos TM1 9.5.2
Microsoft Windows 2008 R2

Problem:
When user surf to Cognos Application Web on the url http://tm1servername.domain.com:8080/pmpsvc
Then click on the icon for “update application” in the list they get the error
“Could not open specific application”

Cause:
The wrong cert file are in user catalog
C:\Users\%username%\AppData\Roaming\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7347.0\ssl
Copy the new certificates to this folder then it will work for that user.
Cognos Tm1 9.5.2 is not supported, so there is no provision agent.

Solution:
Copy the new cert to folder D:\NewSSLCerts
Create a bat file with this content:
d:
cd D:\NewSSLCerts
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7347.0\ssl*.*”
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7343.0\ssl*.*”
copy /B /Y D:\NewSSLCerts\*.* “%appdata%\CognosRCP\rcp\applications\ModelingADT_8.4.1\bins\bin_8.4.7278.0\ssl*.*”

Save the file as d:\updatecert.bat

Update the BAT file with correct path and ” characters.

Create a shortcut icon to that file on the users desktop by putting it in folder
C:\Users\Public\Desktop,   on a Microsoft Windows 2008 R2 server.
Let the user run the BAT file before starting administration of Cognos Application web.

If a new user start the administration program from the Tm1 application web (pmpsvc) in Tm1 9.5.2 he will get the error, but thereafter he maybe can update his user profile on his computer with above bat file.

More Information:

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

The version of the TM1 server installation can be determined be examining the contents of the cmplst.txt file and the file version of the tm1sd.exe file in the bin64 directory. The following is a list of version numbers from both the tm1sd.exe file and cmplst.txt file.
cmplst.txt file
Within the IBM Cognos TM1 install folder look for a file called cmplst.txt. The default installation location for TM1 10.1 and higher is typically C:\Program Files\ibm\cognos\tm1_64 and C:\Program Files\cognos\tm1 for 9.5.2 and lower.

Within this cmplst.txt file look for [Product Update Information]. If this section is missing or blank, then you have the RTM (first release) installed. If the section is populated, reference the table above to determine the service pack installed.
tm1sd.exe file
To find the version of the TM1 server, browse to the TM1 Server bin64 directory (or bin in 9.5.2), right click and select properties on the tm1sd.exe file. Examine the Product version field.

Note that TM1 9.5.2 and lower versions do not include a cmplst.txt file. You must determine the version of the TM1 Server by examining only the details of the tm1sd.exe file.

TM1 9.5.2 RTM – 9.5.20000.11857
TM1 9.5.2 Fixpack 1 – 9.5.20100.18046
TM1 9.5.2 Fixpack 2 – 9.5.20200.22178
TM1 9.5.2 Fixpack 3 – 9.5.20300.29580
TM1 9.5.2 Fixpack 3 Interim Fix 7 (http://www-01.ibm.com/support/docview.wss?uid=swg24039812) – 9.5.20328.42361

TM1 10.1 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.1.6237.212-0
tm1sd.exe version – 10.1.00000.20166

TM1 10.1 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.6301.21-0
tm1sd.exe version – 10.1.00100.24600

TM1 10.1 Fixpack 1 Interim Fix 3
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.6301.86-0
tm1sd.exe version – 10.1.00111.37787

TM1 10.1.1 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.1.7000.91-0
tm1sd.exe version – 10.1.10000.26473

TM1 10.1.1 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0
tm1sd.exe version – 10.1.10100.31864

TM1 10.1.1 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7102.32-0
tm1sd.exe version – 10.1.10200.39014

TM1 10.1.1 Fixpack 2 Interim Fix 4 (http://www-01.ibm.com/support/docview.wss?uid=swg24039813)
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7102.133-0
tm1sd.exe version – 10.1.10312.42293

TM1 10.2 RTM
cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5000.367-0
tm1sd.exe version – 10.2.00000.36339

TM1 10.2 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5001.145-0
tm1sd.exe version – 10.2.00100.39992

TM1 10.2 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5002.20-0
tm1sd.exe version – 10.2.00200.41411

TM1 10.2 Fixpack 2 Interim Fix 4 (http://www-01.ibm.com/support/docview.wss?uid=swg24039814)
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5002.1040-0
tm1sd.exe version – 10.2.00210.42310

TM1 10.2.2 RTM
tm1sd.exe version – cmplst.txt file – PLANANALYTICS_version=PLANANALYTICS-AW64-ML-RTM-10.2.5200.234-0
10.2.20000.50183

TM1 10.2.2 Fixpack 1
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5210.167-0
tm1sd.exe version – 10.2.20100.123

TM1 10.2.2 Fixpack 2
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5220.91-0
tm1sd.exe version – 10.2.2020055

TM1 10.2.2 Fixpack 3
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5230.146-0
tm1sd.exe version – 10.2.20300.93

TM1 10.2.2 Fixpack 3 Interim Fix 1009
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5230.1009-0
tm1sd.exe version – 10.2.20300.98

TM1 10.2.2 Fixpack 4
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5240.167-0
tm1sd.exe version – 10.2.20400.80

TM1 10.2.2 Fixpack 5
cmplst.txt file – PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5250.191-0
tm1sd.exe version – 10.2.20500.75

 

Information is from this site:

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

Product:
Cognos TM1 10.2.2
Microsoft Windows 2012 Server

Problem:
How do I list the Admin users in a TM1 application?

Solution:
There are different ways to get similar information;

List of users who have logged in to the TM1 application can be seen in the log file.

Here is a quick way to track user login/logout in TM1 using standard TM1 functionality, i.e. ACTIVE or blank STATUS Value from the }ClientProperties cube.

As of the TM1 9.1 release and later, the STATUS field is not automatically updated, so you will need to enable a background thread to keep the STATUS field up-to-date by setting the ClientPropertiesSyncInterval configuration parameter in tm1s.cfg file.

The background thread will wake up periodically and update the STATUS field for all clients indicating which are currently connected to the server. The configuration parameter ClientPropertiesSyncInterval is the number of seconds the background thread waits between updates. Example: ClientPropertiesSyncInterval=5

  • In the Server Explorer (TM1 Architect) , select View–>Display Control Objects from the top menu bar. Right click on Cubes and select Security Assignments.
  • Scroll down and ensure that Logging is checked for the }ClientProperties cube.
  • Select the tm1server and right click on View Transaction Log.
  • Select Cubes: }ClientProperties and the required date range.
  • Click Edit–>Select All–>Copy and then paste the records into an Excel spreadsheet.

The raw data in the Excel spreadsheet can be analyzed by creating a pivot table to count the number of OldValue or NewValue for each user (Key1) and for each day (LogTime). Convert the LogTime to a suitable month/year format to analyze the user login counts by month. Create your own Excel format for reporting TM1 User activity.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21424524

Use an external program to find the usages, try this to see if they can help you;

http://www.bspsoftware.com/products/metamanager/tm1/

https://www.motio.com/content/CognosTM1-free-software.do

Use a TI process to list the users in the security cube, into a different cube, this script below need to be edit to have the USERGROUPS you want to list, and then you have to look into the result cube, to see what GROUPS each user is part of. Should give that it is easy for you to see the number of user that are ADMIN in an application.

In each TM1 application, create a new TI process, and paste below code in PROLOG and EPILOG.

“edit” groups and save and run. You will have a new cube that will list users in group.

#————————————–

# Below code should be in PROLOG
# set default values
#————————————–

sTargetCube=’ClientMemberships’;
sClientDim=’Clients’;
sClientMemberDim=’ClientsMembership’;

sCube=’}ClientGroups’;
sDim=’}Clients’;

sGroup1=’ADMIN’;
sGroup2=’DataAdmin’;
#————————————–
# create dimensions if they do not exist
#————————————–

if (DimensionExists (sClientDim)=0);
DimensionCreate (sClientDim);
endif;

if (DimensionExists(sClientMemberDim)=0);
DimensionCreate (sClientMemberDim);
endif;
#——————————————–
# create cube if not exist
#——————————————–

If (Cubeexists (sTargetCube)=0);
CubeCreate (sTargetCube,sClientDim,sClientMemberDim);
endif;

#—————————————–
# create dimension hierarchy
#——————————————

#dimensiondeleteAllElements(‘ClientsMembership’);
dimensionelementInsertDirect( sClientMemberDim,”,’Sum’,’c’);
dimensionelementComponentAdddirect(sClientMemberDim,’Sum’,sGroup1,1);
dimensionelementComponentAdddirect(sClientMemberDim,’Sum’,sGroup2,1);

dimensiondeleteAllElements(sClientDim);
#————————————————————

# Below code should be in EPILOG
# check if client is member of group
#————————————————————-

i=1;
while(i<=dimsiz(sDim));
vClient=dimnm(sDim,i);
if(long(attrs(sDim,vClient,’}TM1_DefaultDisplayValue’ ))>0);
vClientName=attrs(sDim,vClient,’}TM1_DefaultDisplayValue’ );
else;
vClientName=vClient;
endif;

if(cellgets(sCube, vClient, sGroup1) @=sGroup1);
dimensionelementinsertdirect(sClientDim,”,vClientName,’n’);
cellputn(1,sTargetCube,vClientName, sGroup1);
endif;

if(cellgets(sCube, vClient, sGroup2) @=DimensionElementPrincipalName(  ‘}Groups’,sGroup2 ) );
dimensionelementinsertdirect(sClientDim,”,vClientName,’n’);
cellputn(2,sTargetCube,vClientName, sGroup2);
endif;

i=i+1;
end;
#——————————————————————
# end of code
#——————————————————————

 

List license usage of TM1 with the TM1S.CFG parameter LicenseMetricTime

LicenseMetricTime=00:14:36

The file is created under the folder \ C:\Program Files\ibm\cognos\tm1_64\slmtagraw.

File name is IBM Cognos TM1_10.2.0_medlem register20150113200502294.slmtagraw , see the content of this file last in this doc.

 

Based on the little documentation that exists (i.e. in the .cfg file), I believe this will generate an XML file for the ILMT tool to pick up which is required for sub-capacity license monitoring.

 

NOTE: ILMT https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+License+Metric+Tool

is IBM software which is free and is required when PVU licensed software has been installed on a Virtual environment.

# LicenseMetricTime
# Sets the time of day the TM1 server will generate a License Metric Tag file.
# A License Metric Tag file is an XML file which contains information about license metrics consumed by software product instances.
# In the case of TM1 server, the reported authorized user metrics are the number of Modelers, Contributors and Explorers.
# The License Metric Tag files produced by various instances of TM1 servers are collected by the IBM License Metric Tool (ILMT) agent and aggregated to produce final metrics based on the TM1 product version.
#
# The format of the LicenseMetricTime parameter is dd:hh:mm where:
# * dd is the number of days from today that the system will start automatically producing License Metric tag files. For example, 00 is today, 01 is tomorrow.
# * hh:mm is the time of day in 24-hour format.
# Type: optional, dynamic
LicenseMetricTime=00:14:36

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21959520&myns=swgimgmt&mynp=OCSS9RXT&mync=E&cm_sp=swgimgmt-_-OCSS9RXT-_-E

Use AUDIT logging to find when users are logged into the Applications.

You want to enable audit logging for the TM1 server, process the audit log, and review the details of the audit log.

 

This shows how to use the audit log, for your or use any TM1 server that you have available.

 

Open Windows Explorer, and then navigate to Tm1 folder for your application or the example application GreatOutdoors

Open the tm1s.cfg file in Notepad.

You want to enable the audit log and specify how frequently this log is to be updated.

Set the value of the AuditLogOn parameter to T.

Set the value of the AuditLogUpdateInterval parameter to 60.

The AuditLogUpdateInterval indicates the amount of time, in minutes, that TM1waits before moving the events.  The events are moved from the temporary audit file into the final audit log.

Save the file and close Notepad.

 

You may need to restart your TM1 applications service to make the changes in TM1S.CFG to take affect.

 

From the Start menu, point to All Programs\IBM Cognos\TM1, and then click Architect.

Expand TM1, and then double-click greatoutdoors.

You are prompted to log on to the GreatOutdoors TM1 server.

In the UserName box, type admin, leave the Password box blank, and then click OK.

Ensure that greatoutdoors is selected, and then from the Server menu, click Process Audit Log Events.

You are prompted to update the audit log with the latest events.

Click Yes, and then from the Server menu, click View Audit Log.

The Audit Log window opens.

Click Run Query.

The Results section of the Audit Log window shows a list of audit events.

You can further refine your results by choosing a different time period, as well as by specifying the event owner and type.

Close the Audit Log window.

 

Export the Audit log to Excel for further processing.

 

More Information on the file:

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

<LicenseMetrics version=”0.1″

xmlns=”http://www.ibm.com/xml/ns/licensemetrics”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”

xsi:schemaLocation=”http://www.ibm.com/xml/ns/licensemetrics licensemetrics.xsd”>

<Product>

<ProductName>IBM Cognos TM1</ProductName>

<ProductVersion>10.2.0</ProductVersion>

<ProductId type=”guid”>4acad4f5525b4bd0a78723fcd6cd6154</ProductId>

<InstanceId type=”installation_path”><![CDATA[C:\Program Files\ibm\cognos\tm1_64\bin64]]></InstanceId>

<InstanceName><![CDATA[medlem register]]></InstanceName>

</Product>

<Metrics>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group ADMIN is a modeling group: The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group DataAdmin is a modeling group: The predefined admin group DataAdmin is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group SecurityAdmin is a modeling group: The predefined admin group SecurityAdmin is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>GROUP_DETAIL</SubType>

<Value><![CDATA[Group TESTGROUP is a contributor group: Group TESTGROUP has WRITE permission on cube ClientMemberships.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Modeling groups</SubType>

<Value>3</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Contributor groups</SubType>

<Value>1</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>GROUP_INFO</Type>

<SubType>Number of Explorer groups</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>AUTHORIZED_USER</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[Admin]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[User Admin is a Modeler. Belongs to group ADMIN. The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>AUTHORIZED_USER</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[Roger]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>MODELER</SubType>

<Value><![CDATA[User Roger is a Modeler. Belongs to group ADMIN. The predefined admin group ADMIN is considered a Modeling group.]]></Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Modeling users</SubType>

<Value>2</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Contributor users</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

<Metric LogTime=”Apr 18, 2016 7:05:02 PM GMT”>

<Type>USER_INFO</Type>

<SubType>Number of Explorer users</SubType>

<Value>0</Value>

<Period>

<StartTime>Apr 18, 2016 7:05:02 PM GMT</StartTime>

<EndTime>Apr 18, 2016 7:05:02 PM GMT</EndTime>

</Period>

</Metric>

</Metrics>

</LicenseMetrics>

Product:
CDM version 10.2.4
Microsoft Windows 2008 R2 server

Symptom:
Can not log on to CDM, the user get this error after selection of server
“Säkerhetsförhandlingsfel”

Error message in log file:
2016-10-19 14:19:03,628 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin DashboardPlugIn was loaded. ErrorFormat 0
2016-10-19 14:19:03,675 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin Filing was loaded. ErrorFormat 0
2016-10-19 14:19:03,675 [4] ERROR Ibm.CognosDM.Api.PluginsManager – CDCGN00500E (null) Plugin TasksPlugIn was loaded. ErrorFormat 0
2016-10-19 14:19:20,993 [1] ERROR Ibm.CognosDM.App – CDCGN00025E ExceptionToken: Unknown [LayoutPersistErrorException] Error 0 System.NullReferenceException: Object reference not set to an instance of an object.
at Ibm.CognosDM.Storage.Bases.UserDataSetBase..ctor(String storageLocation, String user)
at Ibm.CognosDM.Storage.DataSetInstances.get_UserSettings()
at Ibm.CognosDM.App.ApplicationExit(Object sender, ExitEventArgs e)

Check this as first step:
Can you also reset the IIS to see if it helps? Type “iisreset” in a Command Prompt window.

If the issue still persist, can you check whether the SSL certificate for CDM is still valid in IIS?

1. From the Start Menu, launch “Administrative Tools – Internet Information Services (IIS) Manager”
2. Highlight ‘Default Web Site’ or the Server name in IIS.
3. Click ‘Bindings’ or click on ‘Server Certificates’ – there you see Expiration Date direct.
4. Highlight your entry for ‘https’ and choose ‘Edit’
5. Click ‘View’
6. Check the Valid from/to dates

In this case the Certificate on the IIS for the default web site had expiry.

Solution:
Insert a new valid Certificate on the IIS server.

1. In the Internet Information Services (IIS) Manager console, under
Connections, select your server name.
2. Double-click Server Certificates.
3. Click Import.
4. Browse to and select the SSL certificate.
5. Enter the password for the certificate, and click OK.
6. Under Connections, select the website where the CognosDM-Server virtual directory is located. For example, select default.
7. Click Bindings. Select the https type, and click Edit.
9. In the SSL certificate window, select the certificate you imported, and click OK.
10. Close the Site Bindings window.
11. Select the CognosDM-Server website application.
12. Double-click SSL Settings.
13. Ensure that Require SSL is selected, and select Ignore in the Client certificates section.
14. Click Apply.

More information:
http://www.ibm.com/support/knowledgecenter/SSQK59_10.2.3/com.ibm.swg.ba.cognos.cdm_ig.10.2.3.doc/c_cdm_ig_ssl_certificates.html

Product:
Cognos Controller 10.2.1 Fix Pack 4
Microsoft Windows 2012 R2 server

Symptom:
Error when importing csv file with data, that have worked fine in previous version of Cognos Controller 10.1. The DiscardedRows are the same number as the Rowsread in Log Reports dialog.

Error message:
The value must be numeric.

The data we try to import contain a decimal value; e.g. 000.00

Solution:
Log on to the Cognos Controller server as the service account that run the Cognos Controller services.
Go to controller panel
Go to regional settings
Change to England (UK)
Click tab ‘Location’
Change this to ‘English (United Kingdom)’
Click tab “Administrative”
Click “Change system locale…” and change this to “English (United Kingdom)”:
Click “Copy Settings”
Tick the box “Welcome screen and system accounts”.
Tick the box “New user accounts”:
Click OK
Reboot the Controller application server

I think it is the value of Decimal symbol need to be changed from comma to a period that solves the issue.

The csv file that is imported to controller must be of a specific format.
Text file should use decimal point (not comma) for decimals and semicolon (not comma or
tab) as delimiter between the data fields.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21691867

Product:
Cognos BI 10.2.2
Microsoft Windows 2012 R2 Server

Question:
How to easy see if Content manager is up?

Solution:
Enter this in Internet Explorer
http://localhost:9300/p2pd/servlet
Change to localhost to your BI server name.

You get a text similar to this:

IBM Cognos Content Manager

IBM Cognos

Content Manager

Build: 10.2.6105.4
Start time: Tuesday, November 8, 2016 9:11:15 PM CET
Current time: Tuesday, November 8, 2016 9:21:28 PM CET
State: Running

More url you can use for testing:
# Get Dispatcher version
http://localhost:9300/p2pd/servlet/gc

# Determine if Content Manager is running
http://localhost:9300/p2pd/servlet

# Determine if Dispatcher (“pogo”) is alive
http://localhost:9300/p2pd/servlet/dispatch?b_action=/dbg

# View installed components
http://localhost:9300/p2pd/servlet/dispatch?b_action=cmplst

# Memory utilization
http://localhost:9300/p2pd/servlet/dispatch?b_action=/diagnostics

# Environment
http://localhost:9300/p2pd/servlet/dispatch/env

# Get load balancing statistics. Can also use this to verify the configuration of an install.
http://localhost:9300/p2pd/servlet/dispatch/p2plbDiag

# Pin requests for load balanced services to a specific Dispatcher (need to be logged in first)
http://localhost:9300/p2pd/servlet/dispatch/pin

# See if the Certificate Server is responding
http://localhost:9300/p2pd/servlet/dispatch/autoCAService

# Give some info if service is up — but that is easier to find with other command.
http://localhost:9300/p2pd/servlet/dispatch/testping

This is what you get with testping:

<?xml version=”1.0″?>

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle=”http://schemas.xmlsoap.org/soap/encoding/” xmlns:bus=”http://developer.cognos.com/schemas/bibus/3/” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:SOAP-ENC=”http://schemas.xmlsoap.org/soap/encoding/” xmlns:SOAP-ENV=”http://schemas.xmlsoap.org/soap/envelope/”><SOAP-ENV:Header><bus:biBusHeader xsi:type=”bus:biBusHeader”><bus:tracking xsi:type=”bus:tracking”/><bus:dispatcherTransportVars xsi:type=”SOAP-ENC:Array” SOAP-ENC:arrayType=”bus:dispatcherTransportVar[]”><item xsi:type=”bus:dispatcherTransportVar”><name xsi:type=”xsd:string”>p2plb_result</name><value xsi:type=”xsd:string”>ok</value></item><item xsi:type=”bus:dispatcherTransportVar”><name xsi:type=”xsd:string”>p2plb_messagetimes</name><value xsi:type=”xsd:string”>1478636020024,1478636020024,1478636020024,0</value></item></bus:dispatcherTransportVars></bus:biBusHeader></SOAP-ENV:Header><SOAP-ENV:Body><l:p2plbPingResponse status=”ok” xmlns:l=”http://developer.cognos.com/schemas/p2pd/lb/1/”/></SOAP-ENV:Body></SOAP-ENV:Envelope>

# XML Parser Information
http://localhost:9300/p2pd/servlet/dispatch/xts.diag

# Determine if the SDK is installed by having the Dispatcher access the SDK WSDL file
http://localhost:9300/p2pd/servlet/dispatch?wsdl

# About IBM Cognos Connection
http://localhost:9300/p2pd/servlet/dispatch?b_action=xts.run&m=portal/about.xts

 

More information:

http://www.cogknowhow.com/index.php/knowledge-articles/36-tools/105-jvm-memory-utilization

https://community.watsonanalytics.com/discussions/questions/23687/what-diagnostic-urls-are-available-with-cognos-ana.html