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:
- Uninstall the Oracle database client version 10.1.0.x from the Rational Insight server.
- 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":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21638341