OBIEE 12c - Unable to connect to repository in online mode - no ODBC Driver found — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12c - Unable to connect to repository in online mode - no ODBC Driver found

Received Response
501
Views
13
Comments
Mark.Thompson
Mark.Thompson Rank 6 - Analytics Lead
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

When I attempt to open my 12c repository in online mode, I get this error message immediately after clicking the blue folder:

pic4.jpg

So let's check the ODBC System Data Sources.

pic0.jpgpic1.jpg

pic2.jpgpic3.jpg

So it appears that I do indeed have an ODBC System Data Source for BI Server that can connect to my OBIEE repository.  It behaves just like it did in 11g.

So, what else might be wrong?  I found this blog, which mentions that obis1 is probably listening on port 9514, but that NQSConfig.ini might still have a bad RPC_SERVICE_OR_PORT pointing to 9703.

https://myobieespace.wordpress.com/tag/create-obiee-12c-system-dsn/

In my system, I do indeed see that obis1 is using port 9514:

pic5.jpg

...and I also see in nqsconfig.ini that the RPC_SERVICE_OR_PORT parameter is still set to the old default 11g value of 9703:

RPC_SERVICE_OR_PORT = "9703";  # default is 0.0.0.0:9703 - This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

LISTEN_ADDRESS = "0.0.0.0";  # default is 0.0.0.0

LISTEN_PORT = 9703;  # default is 9703

However, that blog is not clear as to whether that parameter and/or the LISTEN_PORT parameter actually need to be changed, nor does it specify where in FMC to make the change.

So, I just took a guess.  I manually changed nqsconfig.ini to refer to the 9514 port, both for the RPC_SERVICE_OR_PORT and the LISTEN_PORT parameters, replacing the original 9703 for each.  After doing that, I restarted the BI Server service.  The system seems to be working fine, thank goodness.

But I still cannot connect to the repository in online mode.  The NQSConfig.ini file is good - it still refers to port 9514.  But I get exactly the same result as shown in the first screenshot above.

BTW, "Disallow RPD Updates" is not ticked on the Configuration...Performance screen in FMC.  Also, I know that online mode is not the preferred method of changing a repository.  I'm not attaching in online mode to change anything.  I just need to be able to 'Manage...Cache' to see what is happening in the data cache.

Thoughts?  What am I missing?

«1

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Are you running the Admin tool as a OS Admin user? May be it is a privilege issue.

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    I am launching AdminTool.cmd with a right-click then 'Run as Administrator'. 

  • 3309099
    3309099 Rank 2 - Community Beginner

    Hi,

    What ever the changes you did to nqs config please revert it back. Hopefully you took backup of nqsconfig

    It can be that OBIEE is using 32 bit odbc.  go  to the following location SysWoW64  and see odbc32.exe has bi server conencion if not create it and try again. While creating just use port 9514.

    • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

    • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

    Thanks

    Venkat

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Thank you, Venkat.  Class begins in 15 minutes, so I will give these ideas a try later this evening (including switching the NQSConfig.ini back to its original configuration!) and report back to you.

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Venkat, I found the file odbcad32.exe in both of the locations that you noted.  When I double-clicked the 32-bit version, it tells me that the Oracle BI Server is using a 64-bit driver.  So I'm pretty sure it is 64-bit.  Screenshots below.

    pic5.jpg

    pic0.jpg

  • 3309099
    3309099 Rank 2 - Community Beginner

    Hi Mark,

    Have you tried this stuff discussed in the below blog ? Let me know

    OBIEE 11g/12c and ODI12c: OBIEE12c Error : No ODBC system data source is defined for Oracle BI Serves

    Also, I found this Article on oracle support. If you have support account then please refer to this below doc.

    Error While Trying To Open The Repository Online: "No ODBC system Data Source is defined for Oracle BI Server. Please set it up first." (Doc ID 2162700.1)

    Thanks

    Venkat

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Thank you for the ideas, Venkat.

    I compared my settings with the information in the blog - they match.

    I also tried the suggestion in Doc ID 2162700.1.  In that Doc, it mentions an error related to two non-existent system variables, so I defined those variables.  Unfortunately, that didn't fix things.

    Question: What happens if I just delete the AnalyticsWeb ODBC System DSN and recreate it from scratch?  Is there any harm in trying that?  Or, what about uninstalling the Admin client tool, removing the DSN associated with it, and then reinstalling the tool?  Would there be any harm there?

  • 3309099
    3309099 Rank 2 - Community Beginner

    No harm. try the two things and make sure you see subject areas  when you create.

    Also, any information from Admin tools logs will be really helpful  to trouble shoot further.

    Log Location Ex ; oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication\Administrator_NQSAdminTool.log

    Paste the log details

    Thanks

    Venkat

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Is it a migrated environment setup from 11g generated export bundle JAR file?

    If your OBIEE 12c installation and configuration is done on an Windows OS then check DSN name within defined in your instanceconfig.xml file located at following location <DOMAIN_HOME>\config\fmwconfig\biconfig\OBIPS1, check what is the value mentioned under tag <DSN> is it AnalyticsWeb?

    I have not read the thread completly but have you tried creating a new ODBC System DSN and tried to open RPD in online mode?

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Thank you for the ideas, Syed.  To your first question, the answer is no.  It is a fresh installation of 12c from scratch on a machine that has never seen OBIEE.

    2nd question: Yes, the <DSN> tag shows AnalyticsWeb

    3rd question: I'm about to try that now.