Are you running the Admin tool as a OS Admin user? May be it is a privilege issue.
I am launching AdminTool.cmd with a right-click then 'Run as Administrator'.
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.
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.
Have you tried this stuff discussed in the below blog ? Let me know
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)
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?
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
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?
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.
If the above recommendations fail, you could try to connect from a different machine.
Venkat, thank you for hanging in there on this thread.
* I deleted the ODBC System drivers associated with Oracle BI Server.
* I uninstalled the Admin tool.
* I reinstalled the Admin tool. No problems, all steps ran successfully, and it brought up the ODBC Data Source tool.
* I created an ODBC System DSN with the same characteristics as before.
* Then I launched the AdminTool from the new installation location.
BINGO! I can attach in online mode now.
Whatever the problem was, it was fixed by deleting the old stuff and reinstalling it.
Good thought, Sherry, That one had not occurred to me.