IBM Support

ETL hangs when delivering data to an Oracle data warehouse

Technote (troubleshooting)


Problem(Abstract)

The IBM Rational Insight 1.1 ETL (extract, transform, load) process hangs when delivering data to an Oracle data warehouse.

Symptom

There is no error message or new progress entry in the ETL logs and no communication with the Oracle database.

The point of the ETL process where the hang occurs seems to be random. Sometimes the ETL might even succeed.


Cause

You are using a version 10.1.0.x of the Oracle database client to connect to the data warehouse on a 11.2.0.x Oracle database server.

Resolving the problem

Procedure:

  1. Uninstall the Oracle database client version 10.1.0.x from the Rational Insight server.

  2. Install the Oracle database client version 11.2.0.3 or later.

Document information

More support for: Rational Insight
Cognos Data Manager

Software version: 1.1

Operating system(s): Windows

Reference #: 1638341

Modified date: 04 June 2013