This error caught me out today. I was building a Linux VM to do some work on, and for the life of me couldn’t get the OBIEE Admin Tool to connect to the BI Server on the VM. The error I got when trying to define a DSN on the Windows box was: [nQSError: 12008] Unable to connect to port 9703 on machine 10.3.105.132 [nQSError: 12010] Communication error connecting to remote end point: address = 10.

Continue Reading

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.

Continue Reading

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.

Continue Reading

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.

Continue Reading

The configuration of how Presentation Services (sawserver) does its logging is in the file web/config/logconfig.xml (same directory as instanceconfig.xml). It’s all nice and XML’d: Logging Detail Change the numerical values in the FilterRecord entries to alter the detail level of the logging. Lower means less detail, higher means more. Be aware that your log files can grow very rapidly if you set the logging too high, and unless you’re troubleshooting then leave them at the defaults.

Continue Reading