Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ODBC DataDirect Error After OOP Upgrade to OBIEE .9 from .7

Hi,
I recently upgraded OBIEE 11.1.1.7 on Linux to 11.1.1.9. After doing so, I'm getting ODBC DataDirect Driver error and can not connect to the SQL data source. My Oracle data sources work fine. This is a development environment so I took the production RPD so it is pointing to production databases that are currently populating in my .7 version. Below is what I've done so far.
Compared the ODBC and OPM files and saw that the .7 version was using Merant/5.3 drivers. I pointed my new environment to use 7.1.4 by updating both files to point to the 7.1.4 drivers (odbctrac and SEmsss23 which I copied to this location). However, I'm still getting this error.
I then tried to use the 5.3 drivers and am still having no luck. Any advice or info would be great. I used the 11.1.1.9 oracle documentation configuring DataDirect Drivers and followed those steps with no luck. Below is the document and section I used.
1.4.41.2 Configuring DataDirect Manually
(https://docs.oracle.com/middleware/11119/bisuite/BIERN/biee.htm#BIERN3042)
Error when clicking View Data in RPD
Error on the front in OBI
Thanks in advance.
Answers
-
This was an out of place upgrade. I wanted to make that clear, so we configured the data direct drivers manually and did not run the script that is referenced in the document.
0