IBM Business Analytics Diagnostics: Use Case : Tracking Down an HTTP 500 Gateway Issue

Product(s): IBM Cognos BI; Area of Interest: Infrastructure

In this particular scenario, a support analyst is presented with a situation where any user that attempts to access the IBM Cognos portal receives an HTTP 500 error.

Share:

Business Analytics Proven Practices Team, Business Analytics Proven Practices Team, IBM

Business Analytics Proven Practices Team



14 November 2012

Introduction

Purpose

This document is intended to provide a troubleshooting methodology which incorporates publicly available utilities to diagnose and resolve an issue identified within a specific use case. The use case will be presented as a scenario where an IBM Cognos Support Analyst is working with a client to diagnose and solve a particular issue.

The utilities mentioned in this document can be found at http://www.ibm.com/software/analytics/support/cognos_diagnostictools.html.

Applicability

Although the troubleshooting approach outlined is not IBM Cognos BI version specific, some of the diagnostic utilities used are. The version of the utility to be downloaded will be specific to the IBM Cognos Business Intelligence (BI) version that is experiencing the issue.


Use Case Description

In this particular scenario, the Support Analyst is presented with a situation where any user that attempts to access the IBM Cognos Connection portal receives an HTTP 500 error.


Troubleshooting the Use Case

As with troubleshooting any use case, a set of basic information needs to be collected in order to further clarify the environment and the issue at hand. In this particular case the client’s IBM Cognos BI administrator who did the server migration is able to provide the Support Analyst with the following details within the PMR.

The original environment consisted of a single server install with the following details:

  • IBM Cognos BI version: 10.2
  • Operating System: Windows 2008 R2 64-bit
  • Microsoft IIS 7

During further conversations with the client’s IBM Cognos BI administrator it is discovered that this is a new install and even though the services are started, no one has been successful in accessing the IBM Cognos Connection portal.

Further Clarifying the IBM Cognos Gateway Error

Since the Support Analyst does not have the actual error message, the client’s IBM Cognos BI administrator is guided through an attempt to access the portal. Each attempt results in the following error message:

HTTP 500 - Internal server error

Analyzing the cogserver.log File

By itself, the above error is not very helpful but the client’s IBM Cognos BI administrator has access to physical logs directory on the IBM Cognos Report Server.

The Support Analyst decides to use the IBM Cognos From Log Errors to Technotes Utility located at the following URL,

http://www.ibm.com/support/docview.wss?uid=swg24028415

This tool automatically loads the cogserver.log file and displays all the errors within a given date range. The client is then able to double-click any of the error messages to automatically search the online IBM TechNotes for a solution.

The Support Analyst steps the client through the loading and filtering of the cogserver.log file. After loading the log within the utility, the Support Analyst discovers that the cogserver.log does not contain any reference of the error message. Based on this finding, the Support Analyst knows to focus on the IBM Cognos gateway as the request does not make it to the application server tier.

The Support Analyst and the IBM Cognos BI administrator go through the web server settings and discover that the application pool is running in 64-bit mode. However, the IBM Cognos BI administrator cannot determine whether his IBM Cognos BI gateway is set up in 32-bit or 64-bit mode.

The Support Analyst steps the IBM Cognos BI administrator through the download of the IBM Cognos 10.2 Gateway Bit Depth Utility located at:

http://www.ibm.com/support/docview.wss?uid=swg24033766

This utility has the ability to determine the bit depth of the currently configured IBM Cognos BI gateway. The Support Analyst steps the client though the use of this utility and determines the configured IBM Cognos gateway bit depth is set to 32-bit, hence causing the error. The Support Analyst steps the IBM Cognos BI administrator through the steps required to switch the IBM Cognos BI gateway from 32-bit to 64-bit. After the change, the IBM Cognos BI administrator and the users can now successfully access the IBM Cognos Connection portal page.

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Big data and analytics
ArticleID=845612
ArticleTitle=IBM Business Analytics Diagnostics: Use Case : Tracking Down an HTTP 500 Gateway Issue
publish-date=11142012