Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Failed or Incomplete Oracle OBIEE Client Install
I am very new to OBIEE, so my apologies for these newbie questions which likely have very obvious answers (just not to me), but I did spend hours googling madly for answers, yet still I struggle.
I am attempting to follow the tutorial "Creating Analyses and Dashboards" here: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/cad/cad12c.html#overview
The OTN page referenced there ( OBIEE Samples ) has been very helpful, and in particular the "Step by Step Demo and How to Deploy" video tutorial here: https://youtu.be/djlj227d8NI
I have managed so far to set up the Oracle Linux guest VM with the BI Server, and add the ODBC DSN to the host Windows 10 VM.
I then downloaded Oracle Business Intelligence Developer Client (12.2.1.0.0) from here: https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html
I followed the default install steps as carefully as I could, and now I am trying to connect to the online repository, but when I attempt to open the online repository as instructed in the video, the Oracle BI Administration Tool crashes with the following log output:
[2018-08-20T12:56:03.943-06:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 307c] LCMAPIsUtil.GetSDD-> C:\Oracle\Middleware\Oracle_Home\domains\bi\bitools\bin\..\..\bidata
[2018-08-20T12:56:03.950-06:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ] [tid: 307c] [nQSError: 28031] Error: Cannot open the file: C:\Oracle\Middleware\Oracle_Home\domains\bi\bitools\bin\..\..\bidata\components\OBIS\instance_mapping\obis1\mapping.xml. [[
file: server\Utility\Server\Config\SUSystemConfig.cpp; line: 731
I found that the entire directory tree starting with components is missing from my Host Windows OBIEE Developer Client install. I then looked at trying to upload an sample .rpd again per the tutorial instructions. However, I am finding that again a fair amount of the distro appears to be missing - in this case, the user_projects directory tree, which would include the data-model-cmd.cmd utility used to do the upload.
Can someone point me to the installation steps or config steps that I missed or suggest things I can do differently?
Greatly appreciate any help!
Answers
-
I decided to try to create a new repository from scratch in order to see if that would cause the BI Admin tool to create the missing directory paths. I followed this tutorial: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html#section1
At the very least, I figured I'd learn something.
It wasn't long before I hit another wall. Getting the data source right:
I tried playing with ODBC config, which by itself was establishing connection properly, and tnsnames.ora, which was verified via testing with other clients such as SQL Plus and SQL Developer. Nothing seemed to get me past this ORA-12154 TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach.
Finally I came across this. https://gerardnico.com/dat/obiee/oci#support
It then dawned on me that the BI tools by default create their own "home" tree separate from that of other Oracle products, and that's where it looks for tnsnames.ora. It also looks at the TNS_ADMIN environment variable, which I had not set up. So I went ahead and did that, but could not get it to work. Too bad - I had to go to plan b: copying the tnsnames.ora to the right place under ORACLE_BI_HOME, at the cost of now having two tnsnames files to maintain. But at least I got past the above challenge. On to the next one...which did not take long to come upon. At the Select Metadata Objects step, after selecting the tables to import into the new repository, and starting the import, I got this:
Any suggestions? What would be a good way to troubleshoot this and find out if it's a lock, a slow query, or something else?
Update: Looking at the logfile (<username>_NQSAdminTool.log), it appears the import is plodding along ever so slowly, occasionally raising these errors:
[2018-08-21T08:54:46.612-06:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 35e8] [nQSError: 17003] Oracle gateway error: Unsupported data type 10. [[
file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8Utils.cpp; line: 238
Update: I deleted the BISAMPLE.rpd created earlier and started over. This time, instead of ctl-clicking on all the tables to import, I imported them one at a time. That worked better. I was able to import all the tables very quickly without the above error. The bad news is I am still seeing this:
[2018-08-21T09:09:03.929-06:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: eac] LCMAPIsUtil.GetSDD-> C:\Oracle\Middleware\Oracle_Home\domains\bi\bitools\bin\..\..\bidata
[2018-08-21T09:09:03.935-06:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ] [tid: eac] [nQSError: 28031] Error: Cannot open the file: C:\Oracle\Middleware\Oracle_Home\domains\bi\bitools\bin\..\..\bidata\components\OBIS\instance_mapping\obis1\mapping.xml. [[
file: server\Utility\Server\Config\SUSystemConfig.cpp; line: 731
0 -
Update: I decided to install the 12.2.1.3.0 client. That resolved the issue. I can finally proceed with the tutorial.
As for the uploadrpd issue, I was using an outdated call. Apparently, data-model-cmd.cmd is no longer available in the client distribution; datamodel.cmd, however, does work, as you can see below.
Apparently, 12.2.1.0.0 was a typical 1.0 release with some issues. I hope this saves others their valuable time.
One lesson learned - it's ok not to follow tutorials to the letter. Things change, versions become incompatible, any number of things can happen to make tutorials stale. However, those changes that do happen can create solvable problems, which, by working through them, allow you to learn a lot more than you otherwise would, had you followed a "perfect" tutorial.
0