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

Question

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.

803253 · Answer

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.