As well as tinkering with the sawserver (Presentation Services) logging level and format, we can specific which bits of the log we’re interested in. This is useful for two reasons: We can enable detailed logging for a specific area, without impacting performance as much as detailed logging throughout would cause By only logging in detail the area of interest we can more easily read the log output and not have to wade through pages of irrelevant information Chapter 9 (“Using the Oracle BI Presentation Services Logging Facility”) of the Presentation Services Administration Guide details the log configuration.

UPDATED: See a HOWTO for OBIEE and LoadRunner here Introduction LoadRunner is a tool from HP (bought from Mercury) that can be used to simulate user activity. It supports a whole host of protocols but for OBIEE I’m obviously using the Web one. There are two flavours, “Web (Click and Script)” and “Web (HTTP/HTML)”. The latter simply shoves HTTP requests at the server, whereas “Click and Script” simulates mouse and keyboard entry and thus is more appropriate for this user-based application.

I posted a while ago about the sawserver (Presentation Services) log configuration file. Today I’m doing some work digging around why sawserver’s throwing an error and so increased the log detail. This parameter is really helpful to use: fmtName=“short” Consider in these two screenshots, the first is with the default log format and shows about six entries. The second is short log format and is about ten times as much data.

I have a couple of OTN forums bookmarked, and found that generally every few hours I get signed out and end up viewing them as Guest. I then have to click on sign in, enter password, etc. (Signing out this frequently is ridiculous, IMHO). I found that instead of using the direct URL of a forum, eg: http://forums.oracle.com/forums/forum.jspa?forumID=378 if I use this form: http://forums.oracle.com/forums/adfAuthentication?success_url=/forum.jspa?forumID=378 then I end up signed in more often, and if I’ve been signed out then it goes straight to the login page and then through to the forum.

Here’s a set of scripts that I use on our servers as a quick way to check if the various BI components are up and running. Because we split the stack across servers, there are different scripts called in combination. On our dev boxes we have everything and so the script calls all three sub-scripts, whereas on Production each server will run one of: BI Server Presentation Server & OAS Informatica & DAC The scripts source another script called process_check.

We’re upgrading from OBIA 7.9.5 (Financials - GL) to OBIA 7.9.6. Our reasons are for support (7.9.5 does not support Oracle 11g) and minor functionality additions. Our architecture is: HP-UX 64 bit Itanium (11.31), Oracle 11g (11.1.0.7), separate ETL server, 4x OBIEE servers (2x BI, 2xPS). We have no customisations in the ETL except something for budgets, which is superseded in 7.9.6. This post is a semi-formed articulation of my frustrations encountered during an initial run through of the upgrade in a sandbox.

I keep hitting this error when setting up OBIA. I suppose it’s what it says on the tin, but Googling it didn’t match so I’m posting this so next time I hit it I remember :-) Repository Error ([REP_51821] Failed to connect from Integration Service (pmserver) to repository Oracle_BI_DW_Base running in exclusive mode.) The cause is the Repository Service having OperatingMode set to Exclusive. This is necessary for some of the setup operations like restoring the pre-built Repository, but if you forget to switch it back the Integration Service will suddenly stop working.

I successfully installed OAS 10.1.3.3 and patched to 10.1.3.4. http://localhost:7777 gave the OAS welcome page, but going to http://localhost:7777/em gave 404 Not Found. In [OASHome]/j2ee/home/config/servers.xml search for ascontrol, you should get: change the start attribute to true Restart OAS ([OAShome]/opmn/bin/opmnctl restartproc) and Enterprise Manager should now be available

There’s been a bit of hype about Bing recently, so I thought I’d try it out in trying to get to the bottom of this question on the OBIEE forum. The question was around the nqschangepassword utility and the error it’s reporting: nQSError: 46090 The odbc.ini file could not found or could not be accessed. I did a google for the error to see what other issues could cause the error.

I’m starting on an upgrade from OBIA 7.9.5 to 7.9.6 and wading through the two main docs: 7.9.6 Upgrade guide 7.9.6 Installation guide It would be nice if Oracle could come up with some less confusing terminology. It seems that not only is the whole product of OBIA referred to as OBIA (see @lex’s posting for a good explanation), but that the sub-components which are not-OBIEE-or-DAC-or-Informatica is also OBIA, c.f. page 6-1 of the Upgrade guide “[…]upgrade your Oracle BI Applications environment to the current version.