A frequent question on the OTN OBIEE forum is how to fix this error: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. The error is simply OBIEE reporting that it tried to connect from the BI Server to an Oracle database and the Oracle client returned an error. Distilling it down gives us this error:

Continue Reading

October’s Oracle Critical Patch Update Advisory has been released. There are two vulnerabilities (CVE-2009-1999, CVE-2009-1990) listed under Oracle Application Server for “Component” Business Intelligence Enterprise Edition and one (CVE-2009-3407) for “component” Portal. CVE-2009-1999 is OBIEE and “Fixed in all supported versions. No patch provided in this Critical Patch Update.”. CVE-2009-3407 looks like only OAS (not OBIEE), up to versions 10.1.2.3 and 10.1.4.2. CVE-2009-1990 is OBIEE and is the main vuln of interest.

Continue Reading

Two new blogs of note : Shiv Bharti’s Blog Debashis’s OBIEE Blog Both are well worth a read & following.

Continue Reading

Watch out if you are using init blocks in your RPD. We hit a bug (#9019374) recently that caused BI Server (10.1.3.4) to hang. The init block in question should have returned a date to update a repository variable, but because of badly-written SQL and abnormal data in the source table actually returned a null value. BI Server evidently didn’t like this null being inserted somewhere where it shouldn’t have and understandably logged :

Continue Reading

The Critical Patch Update Pre-Release Announcement for October has been published. The pre-release is advance notice of the affected software prior to release of the quarterly Critical Patch Update. It is published on the Thursday prior to the patch releases (which was postponed by a week because of OOW). It looks like if you’re running OBIEE 10.1.3.4.0 or 10.1.3.4.1 through OAS 10.1.2.3.0/10.1.3.4.0/10.1.3.5.0 then you should check back next Tuesday 20th for details.

Continue Reading

A new OBIEE benchmark has been published by Oracle. It’s on the same hardware as August’s benchmark - Sun T5440s. Anyone would think that Oracle like Sun ;-) Details here Numbers added to my collation post here

Continue Reading

OBIEE comes with a very useful usage tracking feature. For information about it and how to set it up see these links: http://obiee101.blogspot.com/2008/08/obiee-setting-up-usage-tracking.html http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/usage_tracking/usage_tracking.htm http://108obiee.blogspot.com/2009/07/obiee-usage-tracking-setup-and-cloning.html Usage Tracking captures the logical SQL of queries in a column called QUERY_TEXT in the table S_NQ_ACCT. However, out of the box this column is defined as 1k (1024 bytes) long. In some situations this will limit its usefulness because the text will be truncated if necessary when it’s inserted.

Continue Reading

This is a supplemental post to this one describing how to set up a VUser in LoadRunner to test OBIEE. It’s various notes that I made during the development but which aren’t directly part of the step-by-step tutorial. They’re not necessarily vital for recording scripts, but observations and explanations that should be helpful when working with LoadRunner and OBIEE. Validation using sawserver logs It’s no use running a load test if the load you think you’re applying isn’t actually being applied.

Continue Reading

My two earlier posts (here and here) detail the difficulties I had with LoadRunner (now called HP Performance Center). After a bit of a break along with encouragement from knowing that it must be possible because it’s how Oracle generates their OBIEE benchmarks I’ve now got something working. I also got a useful doc from Oracle support which outlines pretty much what I’ve done here too. In essence what you do - and what the Metalink document 496417.

Continue Reading

(Updated 12th Oct 09) Here’s a list of the OBIEE benchmark documents published by Oracle: BenchmarkDateSource document1 - IBM System x3755Sep-07PDF2 - HP DL380 G4Sep-07PDF3 - Sun T2000Sep-07PDF4 - Sun SPARC Enterprise T5440Aug-09PDF5 - Sun SPARC Enterprise T5440Oct-09PDF Collecting the numbers into one table gives this: Based on the details in the documents I think these were all against OBIA’s Service Analytics schema & dashboards/reports. Interesting to note the side-by-side comparison in benchmark 3 (Sun T2000) of two servers, in one case both running BI and Presentation Services and in the other having the two components separate.

Continue Reading

Here’s a list of the OBIEE benchmark documents published by Oracle: 28,000 User Benchmark on Sun SPARC Enterprise T5440 Server running Solaris 10 [Aug 09] 10,000 User Benchmark on Sun T2000 [Sept 07] 5,800 User Benchmark on HP DL380 G4 [Sept 07] 4,000 User Benchmark on an IBM System x3755 Server running Red Hat Enterprise Linux

Continue Reading

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

Continue Reading

A new version of the web browser Opera was released recently. Several years ago I used Opera and may even have paid for it IIRC. Then Firefox came along, and the “it’s not IE” excuse was lost for Opera. Not that I mind IE too much nowadays but at the time it was atrocious. Since then I’ve revisited Opera each time a new release has come out, but nothing has impressed me enough to ditch Firefox (and nowadays Google Chrome).

Continue Reading

There’s an undocumented feature in AdminTool.exe that you can use the /command switch with a text file containing scripted commands to make changes to an RPD file (or create a new one). It’s undocumented and UNSUPPORTED so be careful using it. Some good details in these blog posts, especially Erik’s which has a good list of syntax. Venkat Erik Eckhardt (translated from Czech, original here) @lex Kumar Kambam I’m intrigued to know how the original posters figured out the commands available, if it’s undocumented… :)

Continue Reading

Another way of keeping up with what’s going on in the obiee world, add this RSS feed of del.icio.us obiee tags to your reader. It may be less “current” (because people might discover and bookmark ‘old’ pages), but it’s another tool in the armoury :) If you want an aggregated RSS feed of OBIEE / Oracle related blog postings try this one.

Continue Reading

Following the Oracle CAF tutorial here, I got to Cloning Answers Requests section and then got stuck. I’d set up my environment exactly the same as in the tutorial, down to the same paths etc. After firing up the CAF to clone requests from the SampleSales catalog: I clicked on Next and got the error “Exception occurred when while initializing repository!!!” By playing around with the passwords and path names I determined that both RPD files existed and that CAF could load them enough to validate the passwords.

Continue Reading

This weekend just gone Metalink3 went to the digital dustbin. In principle this is a Good Thing, as multiple support websites for a single company is confusing and frustrating. Metalink is now “My Oracle Support” and is a flash-based whizz-bang affair. Everyone has different tastes, but there’s a lot to be said for plain HTML for ease and speed of access. But then people probably grumbled to the Wright Brothers that there was nothing wrong with land-transport at the time…

Continue Reading

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.

Continue Reading

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!

Continue Reading

For some reason Oracle haven’t put out a 10.x version of the error & message codes reference guide for OBIEE, but the previous version for Siebel Analytics is still useful: PDF version: http://download.oracle.com/otndocs/products/bi/bi-ee/docs/784/AnyMsg.pdf HTML version: http://download.oracle.com/docs/cd/E12103_01/books/AnyMsg/AnyMsg_Messages.html#wp1007961

Continue Reading