The topics in this section document performance problems you may encounter when running reports in IBM Cognos Connection.
When performing operations through your Web browser, you receive the following error message:
CGI Timeout, process will be deleted from server.
The error occurs when you use Windows Internet Information Services (IIS) as your Web server and the gateway is configured to use CGI. IIS has a default timeout for CGI applications.
To resolve this problem, you can configure the gateway to use ISAPI. IIS does not have a default timeout for ISAPI applications. Or, if you want to keep using a CGI gateway, you can increase the CGI timeout in IIS.
On the gateway computer, start IBM Cognos Configuration.
Under Environment, for the Gateway URI property, change the cognos.cgi portion of the URI to cognosisapi.dll.
In your Web browser, specify the ISAPI URI:
http://computer_name/cognos8/isapi
In the Windows administrative tools, open Internet Information Services.
Under the local computer node, right-click Websites and select Properties.
In the Home Directory tab, click Configuration.
In the Process Options tab, increase the CGI script timeout.
If your content store has many users and policies, clients reading schedule information for many users can slow down server performance for all users.
To correct this problem, administrators can remove the Entries I Own, Public Folders, and Any options from the Scope list on the Schedule Management page.
You can use a URL or edit the system.xml file to remove user interface elements for most users while showing the user interface elements to other users, such as the administrator.
The following table describes these user interface elements.
User interface element | Description |
SMT_SCOPE_any | ‘Any’ value from the Scope list in the Schedule Management tool. |
SMT_SCOPE_entries_i_own | ‘Entries I Own’ value from the Scope list in the Schedule Management tool. |
SMT_SCOPE_public_folders | ‘Public Folders’ value from the Scope list in the Schedule Management tool. |
For information about hiding user interface elements, see the IBM Cognos 8 Administration and Security Guide.
When using IBM Cognos 8 with an SAP BW data source, the following error message may appear:
BAP-ERR-0002 BAPI error occurred in function module BAPI_MDDATASET_CHECK_SYNTAX. Error occurred when starting the parser.
This error usually occurs because the SAP BW server is overloaded.
To resolve this problem, restart the IBM Cognos 8 server or close all open connections from the SAP BW Administrator Workbench.
In HP-UX, the default setting for the threads per process is too low for most Java applications.
To avoid out of memory errors, increase the value for the following kernel parameters:
nkthread.
Note: The nkthread parameter should be double the value of the max_thread_proc parameter.
For more information, see the HP Web site.
When using an SAP BW data source, and range filters are defined on non-ASCII text values, such as city names that contain accented characters, the query may take longer to run. This occurs because the filter must be performed on the application server and not on the SAP BW server because SAP BW 3.0B supports queries only if they use ASCII values.
To avoid this problem, do not filter non-ASCII values.
In IBM Cognos Connection, you click Run with Options and select the Save the report delivery option. This action returns all data, renders the report, and stores it in the content store, which can take a long time.
It is quicker to run the report manually, using the Run command, which generates the report a page at a time.