Introduction ðŸ”—

In this article I plan to get sample and paint repositories hosted on a single server, using one BI Server instance and two Presentation Services instances. This is on both Unix (OEL 4) and Windows, and both OC4J (OBIEE’s “basic installation” option) and OAS (“Advanced Installation”).

Make sure you’ve read and followed part 1 - BI Server first.

Remember that multiple Presentation Services instances on a machine is UNSUPPORTED BY ORACLE!

OBIEE Components ðŸ”—

See the deployment guide p.11 for a thorough explanation of the components.

It’s important to understand the components of the OBIEE stack as what we’re doing is unsupported and undocumented in parts, so you need to be able to diagnose and reason through issues you may get:

What we do is deploy a second instance of the Presentation Services Plug-in (analytics) and configure it to talk to a second invocation of Presentation Services (sawserver) which is run with a new configuration.

NB contrary to other posts on this subject that I’ve seen, you don’t need to install a second instance of presentation services - you just fire up your existing one with a different configuration file.

Deploy a second instance of Presentation Services Plug-in (analytics) ðŸ”—

This is for OAS and OC4J, with another application server YMMV.

Setting up a second Presentation Services ðŸ”—

You need to create a second Presentation Services that will have its own web catalog and configuration to use the correct RPD. In this example I’ll create a new Presenttion Services which will be for samplesales whilst the original default installation will be for paint.

An important note is that we don’t need to install anything new, we simply use the existing installation with separate configurations (instanceconfig.xml) and web catalog. The next steps assume that you already have the web catalog for samplesales and just cover instanceconfig.xml

In $OracleBIData/web/config create a copy of instanceconfig.xml for your new instance, eg. instanceconfigRNM.xml. Edit it as follows:

Be aware that instanceconfig.xml is CaSe SENsiTIve. Thanks to Merlin128 for discovering this :-) This can lead to problems as you won’t always get an error. If you use catalogpath (instead of CatalogPath) you’ll get an error, but if you use Listener Port (capital P, should be lowercase) you won’t get an error but sawserver will ignore it and default to port 9710.

Your modified file should look something like this:

[sourcecode language=“xml”] AnalyticsWebSampleSales /data/web/catalog/samplesales […] [/sourcecode]

(NB: following the instructions in “Changing the BI Presentation Services Listener Port” in the deployment guide p.141, I got an error when I tried to embed the Listener tag within RPC: “The configuration entry ‘RPC/Listener’ is deprecated. Please refer to the admin guide for more information.” followed by an Assertion failure. Putting it just within ServerIntance worked fine)

Testing the second instance of Presentation Services (sawserver) ðŸ”—

sawserver can be started with command line parameters, one of which is to specify the config file (which defaults to $OracleBIdata/web/config/instanceconfig.xml). Ultimately we’ll package this up neatly, but to avoid complications it’s best to run it natively from the commandline first to make sure it’s working and not hide any output which may be helpful.

Windows ðŸ”—

From the commandline go to $OracleBI\web\bin (eg. C:\OracleBI\web\bin) and enter: sawserver.exe -c c:\OracleBIData\web\config\instanceconfigRNM.xml (amend c:\OracleBIData\web\config\instanceconfigRNM.xml as appropriate to point to the new instanceconfig.xml file you created above). Make sure you get a successful startup:

Type: Information […] Oracle BI Presentation Services 10.1.3.4.1 (Build 090414.1900) are starting up. ————————————— Type: Warning […] WARNING: The Oracle BI Presentation Server is running on a workstation class machine (Windows 2000 Workstation, Windows XP Professional, etc .). Number of concurrent users may be severely limited by the operating system. ————————————— Type: Information […] Oracle BI Presentation Services have started successfully.

Unix ðŸ”—

From the shell prompt go to $OracleBI/setup and run

[sourcecode language=“bash”] . ./sa-init.sh sawserver -c /data/web/config/instanceconfigRNM.xml [/sourcecode]

Points to note:

Make sure you get a successful startup:

Type: Information […] Oracle BI Presentation Services 10.1.3.4.1 (Build 090414.1900) are starting up. ————————————— Type: Information […] Oracle BI Presentation Services have started successfully.

Configuring the new Presentation Services plugin ðŸ”—

You need to configure the new Presentation Services plugin (eg analyticsRNM) so that it can communicate with the second instance of Presentation Services.

Testing the configuration ðŸ”—

For good measure, first bounce both BI Server and your web/application server (eg OC4J, OAS) if you haven’t already.

Then start both versions of Presentation Services (either manully or scripted, see below). Check that they’ve started up correctly by checking sawserver.out.log, and check they’re listening on the correct ports (eg 9710 and 9711):

tcp

Note about ports: don’t confuse these Presentation Services ports with your web server ports. You will always connect from your web browser to your web server on the same port, eg. 9704 or 7777. You would never enter the ports 9710 etc in your web browser address bar.

Start BI server if it’s not running, and then navigate to http://[web server]:[web server port]/analytics (eg http://localhost:7777/analytics) and login and ensure that you get paint (or whatever you’ve left your default instanceconfig.xml pointing to).

Now try http://[server]:[port]/[new analytics] eg. http://localhost:7777/analyticsRNM and login and hopefully you’ll get samplesales (or whatever your new instanceconfig.xml points to).

samplesales.rpd in one window, paint.rpd on the other, both running from one server

Problems you might encounter ðŸ”—

When doing this amount of configuration work it never does any harm to throw in cheeky service restart to see if it resolves an error. It’s probably good practice to try and work through an error first, if only for gathering understanding.

500 Internal Server Error ðŸ”—

Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details. This is a generic message meaning that the Presentation Services plugin (“analytics”) has thrown an error. To find details either get the log file from disc ($J2EE home/application-deployments//home_default_group_1/application.log) or from OC4J: homeOracle Enterprise Manager (oc4jadmin) - Log Files_1251205732988 From the log file you can get the real error message of what’s going on

Port 9710 is in use on the local system ðŸ”—

Check that you’re starting sawserver directly, and not using sawserver.sh. If you use sawserver.sh then your -c argument will be ignored because sawserver.sh calls the sawserver binary without any arguments.

Doublecheck your customised instanceconfig.xml file, because sawserver won’t necessarily flag an error if it’s invalid, it will just revert to default values including port (9710).

Your new analytics instance shows the same repository as the default one ðŸ”—

You analytics is probably connecting to the incorrect Presentation Services, or the Presentation Services it is connecting to is not running with the correct instanceconfig.xml file

java.io.EOFException at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocol.readInt ðŸ”—

09/08/25 14:04:50.46 analytics: Servlet error java.io.EOFException at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocol.readInt(SAWProtocol.java:167) at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolInputStreamImpl.readChunkHeader(SAWProtocolInputStreamImpl.java:232)

This means that the Presentation Services plugin (analytics) cannot communicate with Presentation Services (sawserver). Check:

[nQSError: 10058] A general error has occurred. [nQSError: 12008] Unable to connect to port 9703 on machine localhost. ðŸ”—

Whoops, you forgot to start your BI server…

Charts aren’t working, I just get a yellow triangle symbol ðŸ”—

Is the Javahost service running?

Starting both Presentation Services neatly ðŸ”—

Unix ðŸ”—

run-saw.sh is the script used in Unix to control Presentation Services. You can examine it in $OracleBI/setup/run-saw.sh and create your own hack based on your requirements (eg if you always want both started, or to control them individually).

Be aware that run-saw.sh checks for an running instance of “sawserver” so you’ll need to cater for that.

One method would be to create a new startup script like this:

[sourcecode language=“bash”] #!/bin/sh # # Hacky script to run two versions of Presentation Services # # http://rnm1978.wordpress.com/ # # ————————————————— # start your default Presentation Services echo ‘Starting default Presentation Services…’ echo ’ ’ run-saw.sh start # The above should be “start64” if you’re in 64 bit mode

# Now start the additional Presentation Services echo ‘—-’ echo ’ ’ echo ‘Starting additional Presentation Services…’ echo ’ ’ . ./common.sh . ./sa-init.sh logfile="${SADATADIR}/web/log/sawserverRNM.out.log" sawserver -c /data/web/config/instanceconfigRNM.xml » ${logfile} 2>&1 & # The above should be “sawserver64” if you’re in 64 bit mode echo ‘See ‘${logfile}’ for log’ [/sourcecode]

Stopping Presentation Services is easier, as run-saw.sh is ruthless in its approach and kills all instances of sawserver. If you don’t want this and want to target a specific instance you’ll need to use ps -ef|grep sawserver and kill the required process.

Windows ðŸ”—

To add your new Presentation Services as a service in its own right using Microsoft’s sc, follow these steps. This involves editing the registry! Do so at your own risk!

  1. From the commandline enter: [sourcecode language=“bash”] sc create sawsvc2 binpath= SEARCHFORMEPLEASE displayname= “Oracle BI Presentation Server 2” [/sourcecode]

    (note the spaces after the equals character)

  2. Run regedt32 and search for SEARCHFORMEPLEASE

  3. Hopefully you’ll find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\sawsvc2

  4. Edit the ImagePath Value to “C:\OracleBI\web\bin\sawserver.exe” /service /c c:\OracleBIData\web\config\instanceconfigRNM.xml (replacing paths where appropriate)reg

  5. Go to Services and you should see Oracle BI Presentation Server 2 which when started should bring up your new Presentation Services.services

(I couldn’t get sc to accept the full command hence the SEARCHFORME hack!)

If you don’t want to muck around with services something like this simple script should suffice. It uses PsExec (from the excellent PsTools suite of utilities) to start multiple sawserver instances in the background.

[sourcecode language=“bash”] REM runMultiplePS.bat REM REM REM Hacky script to run two versions of Presentation Services REM REM http://rnm1978.wordpress.com/ REM REM Uses psExec, download it from http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx REM and put it somewhere in your PATH like c:\windows\system32 REM ————————————————— REM Default instance. Comment this line out if you’re running it from Services instead. REM (you could include -c c:\OracleBIData\web\config\instanceconfig.xml if you wanted, same difference) psexec -d C:\OracleBI\web\bin\sawserver.exe REM Additional instance: psexec -d C:\OracleBI\web\bin\sawserver.exe -c c:\OracleBIData\web\config\instanceconfigRNM.xml REM ————————————————— REM paths will be something like C:\OracleBI\web\bin64\sawserver64.exe for 64-bit [/sourcecode]

Conclusion ðŸ”—

Hopefully this article demonstrates clearly and in enough detail how to set up multiple Presentation Services, without overwhelming the reader. It is actually easy to do, and is great practice for understanding the architecture behind the OBIEE stack. Things to consider after this are the other shared resources (like javahost and logconfig.xml) which may want isolating depending on the use.

Remember that multiple Presentation Services instances on a machine is UNSUPPORTED BY ORACLE!

As well as working on multiple RPDs & Web Cats, this method could be used for one RPD but multiple web cats, maybe at different development levels, or as a sandbox for certain users. In that case the instanceconfig for each Presentation Services would specify the same ODBC DSN.

References / sources ðŸ”—