by ·0 Comments

Product:
IBM Cognos TM1 10.2.2
Microsoft Windows 2012 R2 Server
Microsoft Excel 2013

Symptom:
When starting TM1 Perspective and try to connect to a TM1 server with SSO login though CAM (Cognos Access Manager) it is slow and ends up with an error message:

“(N33) Connection Failed”

When you select the TM1 instance, Excel is stuck for a moment, and the dialog will ask for Native user name and password. Then you can suspect that the SSO will not work.
A TM1 instance on same Windows server without SSO works without an issue in TM1 Perspective.

It works to connect to other TM1 instances on the same Windows server, this suggest that the port used is not open in some firewalls or other application use the same port.

Solution:
On The TM1 instance with SSO, change the port number used for TM1 in the TM1S.CFG file.
Change it from today’s value to a value close to the one used in the TM1 application that works.

Set value in TM1S.CFG to:
PortNumber = 12348
ClientMessagePortNumber = 12349

Save the file.
Restart the TM1 instance service.
Start TM1 Perspective on client laptop and test again.

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

by ·0 Comments

Product:
IBM Cognos TM1 10.2.2
PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5250.191-0
Windows 2012 R2 server

Symptom:
When try to run the test script to call a Java code from a TI process outlined here
http://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.3.0/com.ibm.swg.ba.cognos.tm1_turb.10.3.0.doc/t_ti_configure_eclipse_java_ee_ide.html
get an error in the TI process.

Error message:
Error: Prolog procedure line (11): Errors occurred during execution of process “my.scripts.MyTestTI”. Check error log file for that process for more details

…java.lang.ClassNotFoundException…

Solution:

Check the tm1serverlog file for text like this;
2472 [] INFO 2016-07-25 13:30:30.643 TM1.Process [com.ibm.cognos.tm1.jos.extensions.ExtensionManager] – Insert new extension: C:\Program Files\ibm\cognos\tm1_64\bin64\javaextensions\user\myextension.jar
2472 [] ERROR 2016-07-25 13:30:31.018 TM1.Process [com.ibm.cognos.tm1.jos.extensions.JarFileExtensionRecord] – Extension has invalid extension.xml: C:\Program Files\ibm\cognos\tm1_64\bin64\javaextensions\user\myextension.jar
org.xml.sax.SAXParseException: Premature end of file.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
at com.ibm.cognos.tm1.jos.extensions.ExtensionXml.parseFromXML(ExtensionXml.java:86)
at com.ibm.cognos.tm1.jos.extensions.JarFileExtensionRecord.load(JarFileExtensionRecord.java:83)
at com.ibm.cognos.tm1.jos.extensions.ExtensionManager.insertExtension(ExtensionManager.java:96)
at com.ibm.cognos.tm1.jos.extensions.LocalJarRepository.scan(LocalJarRepository.java:72)
at com.ibm.cognos.tm1.jos.extensions.ExtensionManager.addRepository(ExtensionManager.java:51)
at com.ibm.cognos.tm1.jos.Main.addLocalRepository(Main.java:156)
at com.ibm.cognos.tm1.jos.Main.main(Main.java:127)

This mean that the jar file is corrupt.
Stop your TM1 application and then from the JAVA IDE recompile the file with ANT.
This is done by save the project after a small change.
Remember to stop the TM1 application service before any change to the jar file.

It is good to only have the jar file in one folder, in the example it should be in folder for your Tm1 application, can be like this:
C:\Tm1apps\Tm1Beginner\data\}javaextensions\user

More information:
https://www.ibm.com/developerworks/community/forums/html/forum?id=9cd3aebf-c4bb-4059-91f1-9f0925b6b959&ps=25#topicsPg=1

by ·0 Comments

Product:
Cognos TM1 10.1.1
Microsoft Windows 2012 server

Problem:
Error when saving in TM1 Cognos Configuration, after adding a new TM1 server.

Error message:
[ ERROR ] The cryptography information was not generated.
or
[Validation]
[ ERROR ] CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the encryption certificate with alias ‘encryption’ in the keystore ‘D:/Program Files/ibm/cognos/tm1_64/configuration/encryptkeypair\jEncKeystore’.
The parameter named ‘User ID and password’ located in ‘TM1 Application Server’ is currently invalid.

Possible solution:
In the Cognos configuration, remove the TM1 server you are trying to add…or re-add.

This is for TM1 10.1.1
Then save the configuration in plain text.
Select File – Export to clear text file
Select a folder to save the file in, like d:\temp
Name the file to cogstartup_backup.xml
Stop the Cognos TM1 servers (including IBM Cognos TM1 Application Server) on that physical server.
Close the TM1 configuration.
Go to the following install folder: Driver_letter:\Program Files\ibm\cognos\tm1_64\configuration.
Rename the CSK, SIGNKEYPAIR, and ENCRYPTKEYPAIR folders (add _old after the name).
Rename the cogstartup.xml to cogstartup.xml.old
Copy the file d:\temp\cogstartup_backup.xml to folder \Program Files\ibm\cognos\tm1_64\configuration\
Rename cogstartup_backup.xml to cogstartup.xml
Open the Configuration tool.
Click save, to test that it works now.
This should allow the encryption files to be recreated.
Then add your TM1 server and save your settings.

Below how to update the keys for CA11 or PA2 Local:

Steps to regenerate the cryptographic keys are as follows:
1. Stop the running of your service in Cognos Configuration.

2. On the Content Manager computer, click ‘File > Export As’.

3. Choose ‘Yes’ at the prompt and save the file. For example, name it ‘backup.xml’ which will be stored in the c11\configuration folder.

4. Close Cognos Configuration.

5. On the Content Manager computer, create a backup of the following files and directories before moving them to a different, secure location (as during the cryptographic keys regeneration process they will be re-created):

The files are:

· c11/configuration/cogstartup.xml

· c11/configuration/caSerial

· c11/configuration/certs/CAMCrypto.status

· c11/configuration/certs/CAMKeystore

· c11/configuration/certs/CAMKeystore.lock

· c11/temp/cam/freshness
The directory is

· c11/configuration/csk

6. In the c11\configuration folder, rename ‘backup.xml’ to ‘cogstartup.xml’.

7. Open Cognos Configuration, save the configuration and start the services.

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

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

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

by ·0 Comments

Product:
Cognos TM1 10.2.2
Windows 2012 R2 server

Symptom:
When try to login to TM1 Application web (pmpsvc) you get an error 500 message.
To surf to TM1WEB is works fine, and you can enter the TM1 application from TM1 architect.

Error message:
HTTP Status 500 –
type Exception report
message java.lang.NullPointerException
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:502)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause
java.lang.NullPointerException
com.ibm.cognos.fpmsvc.config.FPMConfig.getResourceManager(FPMConfig.java:612)
com.ibm.cognos.fpmsvc.exception.FPMSVCException.getMessageText(FPMSVCException.java:93)
com.ibm.cognos.fpmsvc.exception.FPMSVCException.getMessageText(FPMSVCException.java:89)
com.ibm.cognos.fpmsvc.exception.FPMSVCException.(FPMSVCException.java:30)
com.ibm.cognos.fpmsvc.session.FPMSessionManager.checkSessionPassport(FPMSessionManager.java:555)
com.ibm.cognos.fpmsvc.session.FPMSessionManager.checkSessionPassport(FPMSessionManager.java:439)
org.apache.jsp.applications_jsp._jspService(applications_jsp.java:188)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.
Apache Tomcat/6.0.35

Solution:
On the TM1 server – stop the IBM Cognos TM1 Application server.
In windows explorer go to folder C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\

Rename the file fpmsvc_config.xml to fpmsvc_config.xml.old
Rename the file fpmsvc_config.xml.new to fpmsvc_config.xml
Start the IBM Cognos TM1 Application server.

Surf to http://localhost:9510/pmpsvc
And enter new TM1 applications to the server.

The file fpmsvc_config.xml can have been corrupt when you added a new TM1 instance.

by ·0 Comments

Product:
IBM Cognos TM1 10.2.2
Microsoft Windows 2012 R2 Server
Sterling Integrator / Connect Direct

Problem:
When calling a BAT file from a TM1 TI process, to call other program, to send files or other systems task.
You get not the result you wanted.
The BAT file works fine when run direct in DOS prompt, and then the job get done.
But when called from a TI process – there are no errors – but the job is not executed.

Example of TI code to call a BAT file:
SIpath = ‘C:\cdroot\processer\PW188\PW188.bat’;
ExecuteCommand ( SIpath, 0);

Possible solution:
On the Microsoft Windows 2012 server create this two folders (if they do not exist):
C:\Windows\System32\config\systemprofile\Desktop
C:\Windows\SysWOW64\config\systemprofile\Desktop

This folders are needed when you run Applications without a user logged in, in Windows.

by ·0 Comments

Product:
Cognos TM1 10.2.2
PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.2.5240.167-0
Microsoft Windows 2012 R2 Server

Problem:
Error message when surf to PMHUB at http://windowsserver.domain.se:9510/pmhub/pm/admin

Error message:
HTTP Status 500 – Servlet.init() for servlet equinoxbridgeservlet threw exception

Solution:
Go to IBM Cognos Configuration for TM1 on the server.
Right click on TM1 Applications server and select STOP.
(You can also stop the IBM Cognos TM1 Application server from the Windows Services)
Delete folder pmhub at C:\Program Files\IBM\cognos\tm1_64\tomcat\work\Catalina\localhost\pmhub
Start TM1 Applications Server from inside IBM Cognos Configuration program.

This will recreate the application in TOMCAT and it will work again.

When you apply a FIX PACK to TM1 you must;
Stop the services.
Delete the config.ini file found in folder C:\Program Files\IBM\cognos\tm1_64\tomcat\work\Catalina\localhost\pmhub\eclipse\configuration\
Open Cognos Configuration and click SAVE.
Then you can start the TM1 services again.

by ·0 Comments

Produkt:
Cognos Controller 10.2.1
Microsoft Windows 2008 R2 Server

Issue:
In the list of data sources in Cognos Controller Configuration is more databases than in the list that is shown for the Cognos Controller user when he log on to the Cognos Controller application with his Cognos Controller client program.
The Controller Configuration program was started on server as a normal user.
Solution:
When you start Controller Configuration program on the Windows server, you must start it with “Run as Administrator” to make it read the udl file from folder C:\Program Files\ibm\cognos\ccr_64\data\
Otherwise it will read the files from folder (and that can be different content):
C:\Users\%user%\AppData\Local\VirtualStore\Program Files\ibm\cognos\ccr_64\data\
The Controller services will only read the UDL files from the real C:\Program Files\ibm\cognos\ccr_64\data\ folder.
For security, New Windows OS forbids programs from writing to a variety of “sensitive” areas, among them the Windows folder and the Program Files folder. That includes all subfolders of Program Files, so this ban would be a hardship on older programs that store INI files or data files along with the program itself. To avoid disabling these programs, Windows OS lies to them. When they try to write to a banned location, it says “Sure, no problem!” but actually saves the data in a holding area called the Virtual Store. And when the program tries to read back the data it wrote, Windows Operating System slips in the data from the Virtual Store. The old program works fine, and other programs aren’t affected. A similar process handles programs that write to now-forbidden areas of the Registry.
Start – run command and enter %localappdata%\VirtualStore\ to see this users store.

http://www.pcmag.com/article2/0,2817,2325762,00.asp

by ·0 Comments

Product:
Cognos Controller 10.2.1
Cognos TM1 10.2.2
Cognos BI 10.2.1

Symptom:
When publish from FAP program to TM1 cube with a Windows account you cannot login. But same account work when you access the TM1 cube from TM1 Architect.

Background:
TM1 and Controller are using CAM authentication against a BI server that is connected to the Company’s Active Directory.
The windows user account is in a different sub domain, than the TM1 and Controller servers, that are in an other sub domain in the Company Active Directory.
The FAP program cannot add sub domain information at login, as you can when you login to TM1 Architect.
If you use a Windows account that is in the same sub domain as the TM1 server, then the login works.

Solution:
Check the name space connection string at the Cognos Configuration on the BI server. It should point to the top of the AD domain. If it point to a single AD server in the domain, that server cannot have access of the whole AD, and therefor miss the account. This because the sub domain info is not passed on from the FAP program.
Ensure that the AD connection point to the top of the domain, or to a load balancer in front of the AD servers.

by ·0 Comments

Product:
Cognos Controller 10.2.1 fix pack 4
Windows 2012 R2 server

Problem:
How install the Cognos Controller client on a Citrix server?

Fix pack downloaded from here
http://www-01.ibm.com/support/docview.wss?uid=swg24041934
http://www-01.ibm.com/support/docview.wss?uid=swg24042066

Solution:
The IBM Cognos Controller client has the following 3rd party dependencies that needs to be satisfied:
1. Microsoft .net Framework 2.0SP2 (Present in Windows 7 and Windows Server 2008 R2 from start).
2. In the case where IBM Cognos Controller 10.2.1FP4 is installed to run as a local client on a Windows 10 client machine, it is required that Microsoft .NET Framework 3.5 Service Pack 1 is installed.
3. Acrobat Reader 9.3 or ‘X’.
4. Microsoft Excel 2007 or 2010, 2013, 2016.
5. Internet Explorer 8 or 9 or 10 or 11.

Copy the ccrlocalclient.msi file from folder c:\program files\ibm\cognos\ccr_64\webcontent\ccr
To a share you created for the installation.
In that share create a text file called EXCEL.EXE.CONFIG with this content:

<configuration>
  <startup>
     <supportedRuntime version=”v2.0.50727″/>
  </startup>
 <runtime>                                                               
 <generatePublisherEvidence enabled=”false”/>                           
</runtime>
 </configuration>

Then you can install Controller program from the share to the local computer.

The Controller client installation in Citrix is performed in a similar way to any local installation. There are however a few things to observe in the installation process as Controller is installed in a shared Citrix environment.

The installation steps in Citrix are as follows:
1. Copy the ‘Excel.exe.config’ file to the Office installation folder (needs to be in the same location as excel.exe.)
2. Set terminal server in install mode, at the command prompt type:

change user /install

3. Run the installation from the command-line (convenient way to supply configuration parameters):

msiexec /i ccrlocalclient.msi WSSURL=http://servername.domain.com/ibmcognos/controllerserver HELPURL=http://servername.domain.com/ibmcognos/controllerhelp

4. Change back to execute mode:

change user /execute

5. Check the following registry key to ensure that not all users get the Controller Excel-link loaded from start:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows NT\CurrentVersion\Terminal Server\Install\Software\Microsoft\Office\14.0\Excel\Options

There are different ways to check this, however, at the lowest level of this key there should not be an ‘OPEN’ value pointing to ‘/R \controllerxl.xll’ present!

In Internet Explorer the Cognos Controller server must be with the local sites to allow SSO login.
Go to Internet Options
Click Security tab
Select Local Intranet and click Sites button
Click Advanced button
Enter the url for the server ( http://servername.domain.com ) and click ADD
Repeat for only server name ( http://servername ) and click ADD
Click Close
Click OK
Click OK

More information
https://msdn.microsoft.com/en-us/library/windows/desktop/aa367988%28v=vs.85%29.aspx
http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1375106167322&osPlatforms=Windows#sw-2
http://www-01.ibm.com/support/docview.wss?uid=swg21608353

by ·0 Comments

Product:
Cognos Controller 10.2.1
Microsoft Windows 2012 R2
Microsoft SQL 2012 database in cluster setup

Symptom:
After the SQL cluster have rolled from Node A to Node B, then the first Controller user to login and run a standard report get an error message. He run the report a second time and it gives the same error message. The third time he run the report it works fine. Same issue for other reports.
Thereafter the reports work fine inside Cognos Controller, until next time you role the Cluster.

Error Message:
RQP-DEF-0177
Ett fel inträffade när åtgärden ‘sqlStart’ status=’-121’ utfördes.
UDA-SQL0564 [Microsoft OLE DB Provdier for SQL Server][DBNETLIB]
General network error.
(SQLSTATE=08S01, SQLERRORCODE=11)

Solution:
After you have shifted the SQL cluster, restart the Cognos BI service on the Application server.
Wait the 5 minutes it takes to restart the IBM Cognos service, and then login to Cognos Controller client and test again to run report. Now it should work the first time.

The Cognos BI service check if it have contact with the database, if it loose contact – it will not use that node for some time.

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