ODBC DataDirect Error After OOP Upgrade to OBIEE .9 from .7 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODBC DataDirect Error After OOP Upgrade to OBIEE .9 from .7

Received Response
1
Views
1
Comments
803253
803253 Rank 3 - Community Apprentice

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

Screen Shot 2016-04-01 at 6.28.09 PM.png

Error on the front in OBI

Screen Shot 2016-04-01 at 6.28.34 PM.png

Thanks in advance.

Answers

  • 803253
    803253 Rank 3 - Community Apprentice

    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.