I’m working on a scripted load test for OBIEE using nqcmd to run reports multiple times. I hit this interesting issue. Cut and pasting the logical SQL that Presentation Services sends to BI Server from Manage Sessions -> Statement, I kept getting this error when I ran it through nqcmd: [10058][State: S1000] [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: “Natural Account (COA)”.“Account Parent1 Code”.

It’s possible to change the error pages served up by OAS/Apache by using the ErrorDocument directive. This is widely documented. However, to get this to take effect in an oc4j application (such as analytics) you need to change mod_oc4j.conf too. (I found this out from this post here) Take backups of httpd.conf and mod_oc4j.conf, and then edit them as follows: In httpd.conf add: ErrorDocument 500 /500.html where /500.html is a relative path to your custom document

New releases this week - 10.1.3.4.1 of OBIEE, and 7.9.6 of OBIA. After a bit of scrabbling around found: “The 10.1.3.4.1 release of the Oracle Business Intelligence Enterprise Edition introduces no new features.” Though there are some new bits and pieces for Publisher For 7.9.6 OBIA, there’s no New Features document :( By piecing together the “What’s New in This Release” for each document you can build up a picture (eg in the Upgrade Guide there’s reference to changes for the doc relating to a new version of Informatica), but it would be nice to have it all in one place:

We’ve got a setup of two OAS/Presentation Services boxes and two BI Server boxes, with load balancing/failover throughout. The Load Balancing of the web requests is being done through a separate bit of kit, an F5 BIG-IP load balancer. This directs the requests at the two OAS servers. The problem we have is that by default OAS serves HTTP on port 7777, but the F5 is using port 80. A request for our load balanced URL: http://bi.

Why does Google more often than not return the korean (kr) version of OTN forums for a match, but not english? If I search Google for “Send notification:” “oracle.ons.Notification” the top hit is for kr.forums.oracle.com/forums/thread.jspa?threadID=650662 If you strip the kr from the URL you get this, which makes more sense given the locality when doing the search in Google. Only mildly irritating, but odd behaviour nonetheless

I noticed that the j2ee server.log file was filling up with these entries: oracle.ons.Notification@afba5d 09/04/02 10:15:12.207 Send notification: oracle.ons.Notification@17ca0f5 09/04/02 10:15:42.217 Send notification: oracle.ons.Notification@1a28842 09/04/02 10:16:12.227 Send notification: oracle.ons.Notification@5144d5 09/04/02 10:16:42.237 Send notification: oracle.ons.Notification@19078ed 09/04/02 10:17:12.247 Send notification: oracle.ons.Notification@fcc268 09/04/02 10:17:42.257 Send notification: oracle.ons.Notification@16df388 A quick google turned up this page in which bug 7132128 (“OC4J EMITS “SEND NOTIFICATION” MESSAGES THAT FILL SERVER.LOG”) is identified. The server.log is currently only 6MB and given the size of the server it will be a while before it causes us problems, but it’s worth being aware of.

A very minor irritation, but an irritation nonetheless, is when I go to Application Server Control in OAS I have to login twice. Reading around I found this is an Apache feature, and is actually designed behaviour. For reasons I’ve not explored our servers have several different hostnames which resolve to the same IP, e.g.: myserver myserver-app myserver-data When you request a page from Apache using a hostname other than that configured as ServerName in Apache’s httpd.

(See here and here for history) I edited the shell script which is eventually called by run-saw.sh to start the sawserver, (OracleBI)/setup/sawserver.sh, to use trus: Comment out the final line: $SASAWSERVER and insert as a new line: tusc -fepan -o /tmp/sawserver_tusc.out $SASAWSERVER The output of trus ended with this: open("/app/oracle/product/10.2.0/lib/libstd_v2.so.1", O_RDONLY|0x800, 0) ……… ERR#2 ENOENT open("/app/oracle/product/obiee/server/Bin64/libstd_v2.so.1", O_RDONLY|0x800, 0) . ERR#2 ENOENT open("/app/oracle/product/obiee/web/bin64/libstd_v2.so.1", O_RDONLY|0x800, 0) …. ERR#2 ENOENT open("/app/oracle/product/obiee/odbc/lib64/libstd_v2.so.1", O_RDONLY|0x800, 0) … ERR#2 ENOENT

In investigating the problems with sawserver I was pointed towards a tool called tusc (which appears to be an HP version of truss). You can use it to invoke a program, and get out a bunch of debug information including system calls. You run it like this: $tusc -fep /app/oracle/product/obiee/web/bin64/sawserver64 As a beginner when it comes to hardcore *nix I can only look at this and take pot shots at what’s going on, but with Google by my side I’m interested in the last lines of the output:

Follow on from setting up Publisher in a clustered environment, I’ve found a nasty little bug in the scheduling element of Publisher, Quartz. Looking at the oc4j log file /opmn/logs/default_group~home~default_group~1.log I can see OC4J starting up, and then a whole load of repeated messages: 09/03/30 11:28:43 Oracle Containers for J2EE 10g (10.1.3.3.0) initialized - ClusterManager: detected 1 failed or restarted instances. - ClusterManager: Scanning for instance “myserver.fqdn.company.net1238408921404”’s failed in-progress jobs.