rmoff's random ramblings
about talks

sawserver

Jun 1, 2016
Jun 1, 2016

Presentation Services Logsources in OBIEE 12c

Presentation Services can provide some very detailed logs, useful for troubleshooting, performance tracing, and general poking around. See here for details. There’s no bi-init.sh in 12c, so need to set up the LD_LIBRARY_PATH ourselves: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/app/oracle/biee/bi/bifoundation/web/bin/:/app/oracle/biee/bi/lib/:/app/oracle/biee/lib/:/app/oracle/biee/bi/bifoundation/odbc/lib/ Run sawserver with flag to list all log sources /app/oracle/biee/bi/bifoundation/web/bin/sawserver -logsources > saw_logsources_12.2.1.txt Full list: https://gist.github.com/rmoff/e3be9009da6130839c71181cb58509a0
Dec 3, 2010
Dec 3, 2010

OBIEE 10g - javahost hang

Hot on the heels of one problem, another has just reared its head. Users started reporting an error with reports that included charts: [sourcecode] Chart server does not appear to be responding in a timely fashion. It may be under heavy load or unavailable. [/sourcecode] Set up is a OBIEE 10.1.3.4.1 two-server deployment with BI/PS/Javahost clustered and loadbalanced throughout. Diagnostics Javahost was running, and listening, on both servers: [sourcecode] $ps -ef|grep javahost obieeadm 14076 1 0 Nov 25 ?
Jun 14, 2010
Jun 14, 2010

Measuring real user response times for OBIEE

@alexgorbachev tweeted me recently after picking up my presentation on Performance Testing and OBIEE. His question got me thinking, and as ever the answer “It Depends” is appropriate here :-) Why is the measurement being done? Without knowing the context of the work Alex is doing, how to measure depends on whether the measurement needs to be of: - The actual response times that the users are getting, or The response times that the system is currently capable of delivering This may sound like splitting hairs or beard-scratching irrelevance, but it’s not.
Mar 5, 2010
Mar 5, 2010

Who’s been at the cookie jar? EBS-BI authentication and Load Balancers

We hit a very interesting problem in our Production environment recently. We’d made no changes for a long time to the configuration, but all of a sudden users were on the phone complaining. They could login to BI from EBS but after logging in the next link they clicked took them to the OBIEE “You are not logged in” screen. Our users login to EBS R12 and then using EBS authentication log in to OBIEE (10.
Dec 9, 2009
Dec 9, 2009

Troubleshooting Presentation Services / analytics connectivity

Short but sweet this one - a way of troubleshooting connectivity problems between analytics (the Presentation Services Plug-in, either j2ee servlet or ISAPI, a.k.a. SAWBridge) and sawserver (Presentation Services). For a recap on the services & flow please see the first few paragraphs of this post. Problems in connectivity between analytics and sawserver normally manifest themselves through this error message: 500 Internal Server Error Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response.
Nov 17, 2009
Nov 17, 2009

Resolved: sawserver : Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege

Whilst installing OBIA 7.9.6.1 I hit this problem when firing up Presentation Services (sawserver): Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege. A quick search on the forums threw up two posts suggesting a corrupted WebCat. Since I’d got this webcat fresh out of the box I was puzzled how it could be corrupted. I did a bit more tinkering (including nosying around in the sawserver log), before realising it was indeed corrupt, and that I was indeed a muppet.
Nov 6, 2009
Nov 6, 2009

OBIEE clustering - specifying multiple Presentation Services from Presentation Services Plug-in

Introduction Whilst the BI Cluster Controller takes care nicely of clustering and failover for BI Server (nqsserver), we have to do more to ensure further resilience of the stack. A diagram I come back to again and again when working out configuration or connectivity problems is the one on P16 of the Deployment Guide. With this you can work out most issues for yourself through simple reasoning. Print it out, pin it to your wall, and read it!
Sep 15, 2009
Sep 15, 2009

OBIEE cluster controller failover in action

Production cluster is 2x BI Server and 2x Presentation Services, with a BIG-IP F5 load balancer on the front. Symptoms Users started reporting slow login times to BI. Our monitoring tool (Openview) reported that “BIServer01 may be down. Failed to contact it using ping.”. BIServer01 cannot be reached by ping or ssh from Windows network. Diagnostics nqsserver and nqsclustercontroller on BIServer01 was logging these repeated errors: [nQSError: 12002] Socket communication error at call=send: (Number=9) Bad file number
Aug 25, 2009
Aug 25, 2009

Multiple RPDs on one server - Part 1 - the BI Server

Introduction In this article I plan to get samplesales 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”). Both samplesales and paint are shipped with 10.1.3.4 of OBIEE, you’ll find them in $OracleBI/OracleBI/server/Sample. This article assumes you’ve got the RPD of each into $OracleBI/OracleBI/server/Repository and unpacked the web cats for each into $OracleBIdata/web/catalog.
Aug 25, 2009
Aug 25, 2009

Multiple RPDs on one server - Part 2 - Presentation Services

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!

Robin Moffatt

Robin Moffatt works on the DevRel team at Confluent. He likes writing about himself in the third person, eating good breakfasts, and drinking good beer.

  • ««
  • «
  • 1
  • 2
  • 3
  • »
  • »»

Story logo

© 2025