[Almost] Complete OBIEE timeline [so far]


Update 29 November 2016 Added dates of end of error correction support. Update 12 December 2016 Added dates of end of error correction support for 12.2. Update 09 May 2017 All versions and patches are up to date. Recently I started to spend significantly more time at OTN forums. And what I have realised that often people don't understand how old versions of the software they use are. It's pretty typical to use OBIEE 11.1.1.6.x or even 11.1.1.5. Well, I knew this before, but when you can see tens of questions it makes the situation more obvious. I'm going to maintain a list of OBIEE versions with release dates in this post,…

Continue Reading

OBIEE and BI Publisher web service


Today's post is inspired by this question from OTN forums: https://community.oracle.com/thread/3943615. The topic starter tried to invoke a BI Publisher (XML Publisher) web service from OBIEE using an Action, and something went wrong. But the same web service worked fine when he invoked it with the same parameters using a third party tool. I'm not sure that this use case is important, but it was very interesting to me to find out what causes this behaviour and is it possible to change it. I've started from the very beginning and confirmed that everything works (or should I say doesn't work?) exactly as the topic starter said. Works perfectly with Altova XMLSpy: Request Response Gives java.…

Continue Reading

OBIEE 12c and OSM. MapViewer setup.


The previous post in the OSM/Spatial series was finished on a simple map of Germany. And it's time to use this map in OBIEE. This post describes how to setup the MapViewer, and the next one how to tweak the map and setup OBIEE. So, let's start. Login to the MapViewer Administration console. The address is http://yourhost:9502/mapviewer (9502 - default port). The first thing we need to configure is a connection to a database which stores a spatial data. It is done by editing MapViewer config file. Select the Configuration tab and then Mapviewer. Locate the Predefined Data Sources section. There is a template for a connection in the config file. It is commnted out by…

Continue Reading

OBIEE 12c Linux installation


A couple of days ago Oracle released a highly anticipated Oracle Business Intelligence 12c (12.2.1.0.0). I've spent a couple of days installing it on an Oracle Linux 7 server. I can't say that it was flawless. An installation process was terminated few times without clear description what was wrong. I don't know yet all of tricks and pitfalls and this guide is only the first version. I've managed to do it, but I don't sure I can repeat it anytime. This post is about a Linux installation procedure only. You can read about Windows 7 installation here OBIEE - Installing OBIEE 12c on my Windows box. From my point of view, there is no significant difference.…

Continue Reading

OBIEE 12c is available


OBIEE 12c is available for download at OTN. You can read a great posts about new features by Boris Dahav here and Shiva Molabanti here, while cat Sherlock and I are writing an installation guide (with pictures but without conversation).…

Continue Reading

OBIEE Windows 10 installation tips


Warning Windows 10 is not a supported platform for any OBIEE installation. Following this guide is on your own responsibility. For testing or educational purposes only. While Windows 10 is not an officially supported platform for OBIEE 11g it's currently most advanced Microsoft OS. Free one-year migration from Windows 7 and 8.1 prompts suggestion that many developers will have to install OBIEE 11g server on their workstations. I hope Oracle will support Windows 10 in the future releases. There are a couple of tricks needed for installing OBIEE on Windows 10 right now. I believe that general installation path is well known for you. If not you may see my post Oracle Business Intelligence 11g installation guide (Linux). Windows…

Continue Reading

OBIEE on Windows 10: not a guide


Attention! Achtung! Внимание! This post does not describe how to install OBIEE on Windows 10. TL;DR: Proceed to the OBIEE Windows 10 installation tips post for the installation guide. Windows 10 was released by Microsoft a couple of weeks ago. OBIEE is not certified to work on Windows 10, but I believe it will get a significant share of the OS market very soon. It was interesting for me is it easy or not to install OBIEE 11.1.1.9.0 on Windows 10, and what problems I need to solve. This post was conceived as a collection of clear, simple, and wrong solutions. Something I should try now, not when I come to a customer. I've tried…

Continue Reading

Windows: no buffer space available


The problem Today one of an OBIEE servers installed on MS Windows Server 2008 R2 started to show an HTTP error 500 and to throw the following messages to the Windows event log every 12 seconds: Message #1 The description for Event ID 33 from source Oracle BI Utility cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An…

Continue Reading

OBIEE: HTML5 charts instead of flash charts


A few days ago many people have faced problems with playing flash content in their browsers. OBIEE [by default] uses flash for showing charts so your dashboards have started to look like this: Senior Firefox Support Lead Mark Schmidt wrote in Twitter: BIG NEWS!! All versions of Flash are blocked by default in Firefox as of now. https://t.co/4SjVoqKPrR #tech #infosec pic.twitter.com/VRws3L0CBW— Mark Schmidt (@MarkSchmidty) 14 июля 2015 The same happened in Chrome and Opera. Right now there are new versions of flash available for most (possibly all) browsers so you can simply update the flash plugin and continue to use everything as usual. But you never know when the same will happen again.…

Continue Reading

OBIEE 11.1.1.7 to 11.1.1.9 upgrade


OBIEE 11.1.1.9 was released on May 15, 2015 and has a few interesting new features. It is the first (and possibly the last) major release in the last couple of years. From my point of view, it isn't a revolution but evolution of the 11.1.1.7.x branch. It's very easy to upgrade existing 11.1.1.7.x instance to 11.1.1.9.0 and involves the following steps: Download OBIEE 11.1.1.9.0 distributive Determine currently used Weblogic server release Download Weblogic 10.3.6 upgrade installer [optional] Upgrade Weblogic to 10.3.6 [optional] Upgrade OBIEE software Upgrade database repository (MDS and BIPLATFORM) Upgrade various system components Download OBIEE…

Continue Reading