IBM Support

ETL hangs when delivering data to an Oracle data warehouse



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


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.


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


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

  2. Install the Oracle database client version or later.

[{"Product":{"code":"SSRL5J","label":"Rational Insight"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"1.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
16 June 2018