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 Planning 10.1.1 fix pack 3
Windows 2008 R2 server
Oracle Database

Problem:
There is a difference in time to do import of deployment packages in the Cognos Planning PROD and DEV environments. In Production it takes 1 minute, in Development servers it take 40 minutes.
On the Cognos Planning server there is little use of CPU or Memory, also on the Oracle server there is little use of CPU and Memory. It looks like it is waiting.
The time between the step “Creating…” and “Created…” in CAC Monitor Console Deployments is the one that take time because of this.
Because:
In the file SQLNET.ORA the search order is defined to access the Oracle database.
If there are firewalls between the DEV servers and the PROD DNS/LDAP servers, then this can happen if the LDAP is first in the list. The Oracle client need to time out before it will look into the TNSNAMES file on the server to find the Oracle database.

Solution:
Open the file C:\orarun\tnsadmin\sqlnet.ora on the Cognos servers
And change
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, HOSTNAME)
To
NAMES.DIRECTORY_PATH= ( TNSNAMES, EZCONNECT, HOSTNAME)
Save the file.
Test to use the deployment import again in Cognos Planning.
Then it should be faster.

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:

Cognos BI 10.2.1 fix pack 2

Windows 2008 R2 server

Problem:

The free hard disk space on the Cognos BI report server is low.

The Cognos folder under c:\program files\   take more than 50 GB space.

Cause:

When a BIBUS or REPORT crashes a dmp file is created in the bin folder.

They fill up the disc, and you should periodical erase these *.DMP files.

 Solution:

Change the cclWinSEHConfig.xml file in folder C:\Program Files\ibm\cognos\c10_64\configuration

Change value below from

<env_var name=”CCL_HWE_ABORT” value=”2:2″/>

To

<env_var name=”CCL_HWE_ABORT” value=”0:0″/>

Save the file.

Restart all the Cognos BI services in correct order.

 

Product:

Cognos BI 10.2.1 server

Windows 2008 R2 Server

Oracle database

Problem:

You have a report that take out all power of the database server, but you do not know that name of the report.

 Suggested Solution:

Add the name of the report to the SQL queries sent to the Oracle database, then the Database DBA can look into the trace of the queries and see what report give the issue.

On the Cognos BI server open the file CQEConfig.xml

Can be found in folder c:\Program Files\ibm\cognos\c10_64\configuration

Change to have this content;

 

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

<!–

Licensed Materials – Property of IBM

BI and PM: QECL

(C) Copyright IBM Corp. 2005, 2012

US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

–>

<configuration company=”Cognos” version=”0.1″ rendition=”cer2″>

<component name=”CQE”>

<section name=”DBConnectionPool”>

<!– Description: Database connection timeout. Default is 900 seconds (15 minutes) –>

<entry name=”Timeout” value=”900″/>

<!– –>

<!– Description: Database connection pool size. –>

<!– Maximum number of connections managed by the report server process. Default=40 –>

<entry name=”PoolSize” value=”40″/>

<!– –>

</section>

<section name=”QueryEngine”>

<!– Description: queryReuse feature –>

<!– value=”0″ means disable the feature –>

<!– default is value=”5″ which means cache up to 5 result sets per session –>

<entry name=”queryReuse” value=”5″/>

<!– –>

<!– Description: References to model query items may have 2-part names. (default(off)=0; choices=0,1) –>

<!– Off:  A parsing error is returned for a reference to a model query item using a 2-part name.  –>

<!– On:  The expression resolver will allow 2-part name references to model query items.    –>

<!– NOTE: Cognos 8.1 MR2 was the last release in which the default setting allowed 2-part names. This release (8.2) –>

<!– has the default set to disallow 2-part names. The next release (8.3) will no longer allow 2-part names. –>

<!– The use of 2-part names will generate the QE-DEF-496 warning message in the log file. –>

<!– entry name=”AllowModelQueryItem2PartNameReference” value=”0″/–>

<!– –>

<!– Generation of comments in native sql and cognos sql.–>

<entry name=”GenerateCommentInNativeSQL” value=”1″/>

<!– ( default(off)=0, on=1) –>

<entry name=”GenerateCommentInCognosSQL” value=”1″/>

<!– ( default(off)=0, on=1) –>

<!– The content of the comments is controlled with two entries, their defaults are specified in the value attribute –>

<entry name=”NativeCommentMacro” value=”#’ user=’ + $account.defaultName + ‘ report=’ + $report + ‘ reportPath=’ + $reportPath + ‘ queryName=’ + $queryName + ‘ start=’ + $startTime#”/>

<entry name=”CognosCommentMacro” value=”#’ user=’ + $account.defaultName + ‘ report=’ + $report + ‘ reportPath=’ + $reportPath + ‘ queryName=’ + $queryName + ‘ start=’ + $startTime#”/>

<!– –>

<!– Description: Include the preferred query subject into the join cache key –>

<!– ( default(off)=0, on=1) –>

<!–entry name=”IncludePreferredQuerySubjectsInJoinCacheKey” value=”1″/–>

<!– –>

<!– Description: Compute measure query items just once (off(default)=0, on=1+ –>

<!– entry name=”ComputeMeasureQueryItemsOnce” value=”0″ –>

<!– –>

</section>

<!– The following section is disabled by default.    –>

<!– The CQE logging is turned on when the existing section name (“_Logging”) is changed to “Logging”. –>

<section name=”_Logging”>

<entry name=”CQEXMLAPI” value=”3″/>

<entry name=”UseIPFLogging” value=”0″/>

<entry name=”QueryEngine” value=”11″/>

<entry name=”LogFileName” value=”..\logs\CQE.log”/>

<entry name=”QR” value=”3″/>

<entry name=”DBC” value=”11″/>

<entry name=”JoinPath” value=”11″/>

</section>

</component>

</configuration>

 

Will give that you have

–         Username

–         Report name

–         Report path

–         Query name

–         Start time

In the Query.

 

More Information:

http://www-01.ibm.com/support/knowledgecenter/#!/SSMR4U_10.1.0/com.ibm.swg.ba.cognos.ug_cra.10.1.1.doc/t_add_comments_native_cognossql.html%23Add_Comments_Native_CognosSQL

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=database-using-application-context-in-dynamic-sql

To use comments in SQL for dynamic query mode (for CA11.1.x) you can configure the xqe.config.xml file, located in install_location/configuration.

You edit the following elements in the <queryPlanning> element.

<generateCommentsInNativeSQL enabled="true"/>
<NativeCommentMacro value="#'user=' + $account.defaultName + ' reportPath='
 + $reportPath +' queryName=' + $queryName + ' REMOTE_ADDR=' + $REMOTE_ADDR 
 + ' SERVER_NAME=' + $SERVER_NAME + ' requestID=' + $requestID#"/>

Product:
Cognos BI 10.2.1
Windows 2008 R2 server
Outlook Mail program

Problem:
Mail sent is not coming forward to the end user from Cognos BI.
In some cases you get a message from the Exchange Mail server that the mail is
This is an automated message from the Extensible Content Security

A mail from you x to y was stopped and Quarantined because it contains one
or more forbidden attachments.

Summary of email contents:

Attachment: My personal report 1.mht
My personal report 1.mht forbidden file extension (.mht)
My personal report 1.mht forbidden file extension (.mht)
Attachment: html
Attachment: image

Because:
Cognos BI 10.2.1 send mail with Excel 2002 attachments as MHT files, that Excel can open but your mail system may have excluded that be allowed.

If you send a report as HTML and include a Body Text in the Schedule message you will get the same issue, please send a link instead of a HTML attachment to make it work.

Solution:
In Server Administration, add “RSVP.FILE.EXTENSION.XLS” parameter to ReportService and BatchReportService.
Steps:
1. Open Cognos Connection.
2.Click Tools menu in the portal and select Server Administration
3. Check Services for Type (All services appear)
4. Select Set Properties for ReportService
5. Select the Settings tab
6. Find the property named Advanced Settings, and click the Edit… link
7. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLSand set the value to TRUE
8. Press OK.

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

Product:
IBM Cognos Planning 10.1.1
Microsoft Windows 2008 R2 Server

Problem:
How change the TEMP variable for a service account, without logging in as the user on the Windows Server?

Solution:
Create the service account in the Domain.
Ensure the service account is part of the local administration group on the planning server.
Go to the Administration tools – services.
(you can start it by type services.msc in Run dialog)
Double Click on your IBM Cognos 10 Planning service and select Log On tab.
Select this account and browse to your service account, in our example named cogplan.
Enter Password and click OK to save the change.
Click OK on message that the account have been added to “log on as a service” function.
Right Click on the service IBM Cognos 10 Planning and select RESTART.
Ensure that Cognos planning service have started.

The planningerrorlog.csv file is created in folder \users\cogplan\appdata\local\temp

Start REGEDIT
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
Check the last number in list – it is possible your service account.
You should see it on the ProfileImagePath value who would be : C:\Users\cogplan
Note the number if the user down
Go to HKEY_USERS\S-1-5-21-2298123480-4089459362-31738xxxxx-1001\Environment
(the number should be the number of the user you found under ProfileList.)
Double click on TEMP to change the value from
%USERPROFILE%\APPDATA\LOCAL\TEMP
to
D:\TEMP
Click OK
Repeat the change for TMP
Close REGEDIT

Restart the Cognos Planning service.

Now the log file is in the D:\TEMP folder.

Product:
Cognos Controller 10.1 FAP
Microsoft Windows 2008 R2
Oracle Database

Error message:
** ERROR: java.sql.SQLException: IO Error: Invalid connection string format, a valid format is: “host:port:sid”

Problem:
When you setup the Cognos Controller FAP database, you need to populate it with tables by using the DBCONV program from Cognos Controller Configuration.
You enter the values for Database Connection and click Test – Connection Succeeded.
Then you click on the arrow to start DBCONV module, and click on CONNECT button to connect to the oracle database. Here you get above error.
If you get below error, it is because you have not entered domain.com value in the name in Cognos Configuration or in the TNSNAMES.ORA file.
** ERROR: java.sql.SQLException: IO Error: Unknown host specified
Only enter PT0572 in Cognos Controller data source will give that error.
Solution:
Inside Cognos Controller Configuration for the FAP database you must enter an EZCONNECT data source name. Like this;
oracleaixservername.domain.COM:1521/PT0572.domain.com
The important is that it is oracle host name (colon) port number (slash) tnsnames alias including domain.com
The TNSNAMES.ORA file should contain this;
PT0572.DOMAIN.COM=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=oracleaixservername.DOMAIN.COM)(PORT=1521))
(CONNECT_DATA=
(SID=PT0572)
)
)

And Cognos Controller Configuration should be like this:
Database type: Oracle
Name: FAP
Provider: ORAOLEDB.ORACLE.1
User ID: CCR_FAP_data_mart (the oracle schema name)
Password: *******
Data Source: oracleaixservername.domain.com:1521/PT0572.domain.com

You must exit Cognos Controller Configuration program between every change to the TNSNAMES.ORA file. The file is only read during start of the Controller Configuration program (ControllerConf.exe *32).

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

Product:
Cognos Planning 10.1.1. Fix pack 3 (version 10.1.6303.19-0)
Windows 2008 R2 Server
Oracle database

Symptom:
When you start Cognos Planning Administration Console on a client you get a error message.
When opening the CAC the following error occurs:
“An error has occurred while starting IBM Cognos Planning Administrator.
Main form failed to initialize.
Error Details:
Unable to determine if the Planning Tables exist in Content Manager. Please ensure the Planning Service is running.”

Unexpected: missing HRESULT parameter”

When opening Analyst the following error occurs:
“Analyst failed to communicate with the Content Manager database. This can happen if the Cognos 10 Planning service is not running. Please check that the service is running.”

Error was:

DISP_E_EXCEPTION
Failed HRESULT [0x80020009] Exception occurred.”
Cause:
The gateway url in Cognos Configuration is not the same as the gateway url on the Cognos BI server for authentication.

Solution:
Log on to the Cognos Planning BI server.
Start Cognos Configuration.
Copy the value for Gateway URI under environment section.
Go to the client computer where you have CAC and Cognos Planning Analyst installed.
Start Cognos Configuration
Paste the value for Gateway URI under Gateway settings.
Click on Save
Exit Cognos Configuration
Try to start the IBM Cognos Planning – Contributor Administrator Console.

Can also be other causes;
http://www-01.ibm.com/support/docview.wss?uid=swg21621002

Product:
Cognos Planning 10.1.1
Windows 2008 R2 server
Oracle database

Symptom:
When doing a GTP you get the PREPARE_ACCESS_BLOCKS to say QUEUING all the time. Why ?

Cause:
The Cognos Planning solution is setup with one JOB server and one ADMIN server.
The PREPARE ACCESS BLOCKS step is a change in the Cognos Planning application that is done from the job server. The other steps of a GTP is update of the Cognos Planning store database, that is accessed with the settings defined in Cognos Configuration. So Cognos Planning use different parts to access the databases.

Solution:
For access to oracle database to work you need to have a correct TNSNAMES.ORA file in your \oracle\client\network\admin folder on your Planning servers.

In this case the issue was solved by adding the tnsnames.ora file to the job server, there it was missing, the tnsnames.ora file was on the ADMIN server only, therefor some GTP task worked, that does not need a tnsnames.ora file.

Access defined in Cognos Configuration can be setup for oracle to direct define and access the server.