IBM Support

ETL hangs when delivering data to an Oracle data warehouse

Troubleshooting


Problem

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.

[{"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

UID

swg21638341