Troubleshooting
Problem
Attempts to open a requirement from IBM Rational RequisitePro client results in the error "The project named "XXXX" could not be opened, because ODBC may not be configured properly."
Symptom
The full error message is as follows:
The project named "XXXX" could not be opened, because ODBC may not be configured properly.
ODBC Error:
[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019
Unable to connect to datasource
Cause
The ORACLE_HOME directory is not valid on the RequisitePro client machine.
Resolving The Problem
The following steps will help to correct the ORACLE_HOME directory on the client machine:
- Start Control Panel and open "System"
- Select "Advanced" tab and double-click on "Environment Variable" button
- Select the system variable "ORACLE_HOME" and click Edit
- Input the correct directory of ORACLE_HOME into "Variable value" field. e.g."C:\oracle\ora10.2"
- Click OK to save the changes
After the above changes are applied, you can open requirements successfully.
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: Oracle","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.0.6;7.0.0.7;7.0.0.8;7.0.0.9;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.0.1.6;7.0.1.7;7.0.1.8;7.0.1.9","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21441581