Product:

Cognos Planning 10.1.1

Windows 2008 R2 Server

Oracle Database

 

Symptom:

Have setup new servers, and try to from inside Cognos Planning Contributor Administration Console (CAC) add new JOB SERVERS to your job server cluster, you get a error.

 

Error message:

Errors occurred while trying to communicate with each of the following

servers:   xxxxx

 

Communication failure could result from:

-The server is not running

-Planning is not installed on the server

-The servers firewall is blocking requests

xxxxx

 

Error in planningerrorlog files:

{4904905A-9BAF-4B99-B054-E41891C9E36C} 2 2014-05-08 19:33:44.433 UTC +120 EAdminDB_10 10.1.4074.0 JobServer GetEnabledAndNameLocal 100 Factory_10 70 Unable to create the object with ProgID ‘epPlanningService_10.JobExecManager’ (request was for ‘epPlanningService_%v.JobExecManager’)~~~~Permission denied domain\serviceaccount domain\servername domain\serviceaccount domain\servername  1744 5020

 

Error in windows event log:

Log Name: System

Source: Microsoft-Windows-DistributedCOM

Date: 5/8/2014 6:46:16 PM

Event ID: 10016

Task Category: None

Level: Error

Keywords: Classic

User: domain\serviceaccount

Computer: servername

Description:

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID

{7B59D7CC-3FD8-41A4-9F2A-40D2D6B5590A}

and APPID

{324E655C-61EF-4500-85D1-2791358B531E}

to the user domain\serviceaccount SID (S-1-5-21-3598516276-3377520961-430964465-92766) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

Event Xml:

<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>;

<System>

<Provider Name=”Microsoft-Windows-DistributedCOM” Guid=”{1B562E86-B7AA-4131-BADC-B6F3A001407E}” EventSourceName=”DCOM” />

<EventID Qualifiers=”49152″>10016</EventID>

<Version>0</Version>

<Level>2</Level>

<Task>0</Task>

<Opcode>0</Opcode>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime=”2014-05-08T16:46:16.000000000Z” />

<EventRecordID>14320</EventRecordID>

<Correlation />

<Execution ProcessID=”0″ ThreadID=”0″ />

<Channel>System</Channel>

<Computer>servername</Computer>

<Security UserID=”S-1-5-21-3598516276-3377520961-430964465-92766″ />

</System>

<EventData>

<Data Name=”param1″>machine-default</Data>

<Data Name=”param2″>Local</Data>

<Data Name=”param3″>Activation</Data>

<Data Name=”param4″>{7B59D7CC-3FD8-41A4-9F2A-40D2D6B5590A}</Data>

<Data Name=”param5″>{324E655C-61EF-4500-85D1-2791358B531E}</Data>

<Data Name=”param6″>domain</Data>

<Data Name=”param7″>serviceaccount</Data>

<Data Name=”param8″>S-1-5-21-3598516276-3377520961-430964465-92766</Data>

<Data Name=”param9″>LocalHost (Using LRPC)</Data>

</EventData>

</Event>

Solution:

The service account set to run the IBM Cognos Planning service on the Microsoft Windows 2008 Server is not set to be local admin on the server.

Go to Manage – Configuration – Local user and groups – Groups

Click on Administrators

Click ADD to add the windows service account to this group on your Planning server.

Save and restart the Cognos Planning servers.

Then you can test again.

 

You can also test this with change back to local system to run the Cognos Planning service, if it works then to add as job server then it is the rights for the windows service account that is the case.

Product:
IBM Cognos TM1 10.2.2
Windows 2008 R2 server

Problem:
When user start Performance Modeller and after enter the TM1 server and logged on to the BI environment, they get a list of TM1 application that are made available in TM1 application web, after selecting APP1 they get error message:
Access Error
The user “username” does not have sufficient rights to use Performance Modeler.
Solution:
The “username” does not have access inside the TM1 application APP1, this he should not have because he is not part of that APPLICATION. The issue is that you can select from all TM1 applications that are published to TM1 Application Web, but that does not mean that you are listed as a Developer/Admin inside the TM1 application to be able to use Performance Modeler with that TM1 application.
Let the user try to login to some other TM1 application e.g. Planning Sample where you previous have made the “username” a admin in that TM1 application.

More Information:
To be able to work with a TM1 application in Performance Modeler it must first be added to the TM1 application web.
Surf to http://TM1applicationwebservername.domain.com:9510/pmpsvc/applications.jsp
Log in as Administrator in previous published TM1 application.
Click on icon for ”Administer IBM Cognos TM1 Applications”.
Click ADD for the Server Names, to add your TM1 application.
Enter the TM1 server name at Admin Host and select your application from dropdown list.
Click OK.
After it is added – it is not shown in the TM1 application portal, but you can select it when you start TM1 Performance Modeler.

Product:
Cognos Lifecycle manager
Microsoft Windows 2008 R2

Symptom:
Error when try to create a new project in Lifecycle Manager

Error message:
An error has occured in Lifecycle Manager.
Could not create a new project

HTTP Status 500 –

Cause:
Check that the tomcat service have started. In the DOS window there can be text like filenotfoundexception. … \logs\catalina,2014-02-25.log (the system cannot find the path…. show that the tomcat service never started correct.
If you check the logs folder under tomcat directory, this folder is empty. The Windows server is looked down – the normal user do not have rights to files under c:\program files folders.

Solution:
Uninstall Lifecycle Manager.
Install it to a different folder on your server – e.g. d:\ibm\cognos\Lifecyclemanager\
Where the user have more access rights and can create temp files.

Then start Lifecycle manager again and surf to http://localhost:4797/LifecycleManager

More Information
http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page579.html

Product:
Cognos TM1 10.2.2
TM1 Perspective
Windows 2008 R2 servers
Citrix servers
Problem:
When start TM1 perspective you get a message in Excel that say:
Insert Smart Card
Please insert a smart card.
And when you click cancel you get this message:
Microsoft Office Excel Security Notice
Microsoft Office has identified a potential security concern.
Warning: This digital signature is invalid and cannot be trusted. The macros will be disabled.
File Path: C:\Program Files (x86)\ibm\cognos\tm1_perspectives\bin\tm1p.xla
Only button is [Disable Macros]
Solution:
Go to Excel Options.
Click Trust Center.
Click Trust Center Settings.
Click Trusted Locations.
Click Add New Location.
Click Browse
Go to C:\Program Files (x86)\ibm\cognos\tm1_perspectives\bin
Click OK
Click OK
Restart Excel and Try again

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