Category Archives: Deployment

OBIEE 10.1.3.4.2 does not work after installation on Windows 2008 Server R2 64-bit

Symptoms
The OBIEE 10.1.3.4.2 components (Presentation Server) do not work properly after a new installation.

The sawlog contained ODBC errors and it was found the Analytics Web System DSN did not exist. It is not possible to manually create this either.

Type: Information
Severity: 30
Time: Wed Sep 07 08:45:52 2011
File: project/sawserver/sawserver.cpp Line: 386
Properties: ThreadID-3392
Location:
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver

Oracle BI Presentation Services 10.1.3.4.2 (Build 110727.2045) are starting up.
—————————————
Type: Error
Severity: 20
Time: Wed Sep 07 08:45:52 2011
File: project/webodbcaccess/odbcenvironment.cpp Line: 98
Properties: ThreadID-3392
Location:
saw.webextensionbase.staticinit
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver

ODBC driver preload failed. ODBC library name: ‘nqsodbc.dll’
—————————————
Type: Error
Severity: 20
Time: Wed Sep 07 08:45:52 2011
File: project/webodbcaccess/odbcenvironment.cpp Line: 100
Properties: ThreadID-3392
Location:
saw.webextensionbase.staticinit
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver

Type: Error
Severity: 20
Time: Wed Sep 07 08:45:52 2011
File: project/sawserver/winmain.cpp Line: 74
Properties: ThreadID-3392
Location:
saw.sawserver.initializesawserver
saw.sawserver

Allocation of SQLEnvironment failed (SQLError: -1). Please ensure that the odbc driver is in your environment path.

oc4j started but JavaHosts did not as Java JDK was the 64-bit version.
Cause
Microsoft Windows x64 (64-bit) 2008 R2 is supported and R2 appears to be only available in 64-bit.

A downgrade of Java to 32-bit (JDK 1.6.0.20) took place as OBIEE 10.1.3.4.2 is a 32-bit native application.

Once this took place oc4j, Javahost and BI Server Services started correctly.

However, the BI Presentation Services still failed.

Windows Service Dialog

Windows could not start the Oracle BI Presentation server on Local Computer.

For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor and refer to service-specific error code -1.

Event Viewer
The Oracle BI Presentation Server service terminated with service-specific error %%-1

There is also no ‘Analytics Web’ installed under the System DSN.

Solution
This was confirmed to be a Bug with Development and the following Bug was logged.

Bug 13072296 – AFTER INSTALL THE PRESENTATION SERVER FAILS TO START ON WINDOWS 2008 R2 X64

The workaround to install the Visual C++ libraries from the installation software and this is as follows:

Run the ‘Oracle_Business_Intelligence_Open_Intelligence_Interface\VC80\vcredist_x86.exe’ executable from the downloaded client installer.

This can be performed before or after the installation process.

References
BUG:13072296 – AFTER INSTALL THE PRESENTATION SERVER FAILS TO START ON WINDOWS 2008 R2 X64
NOTE:1061233.1 – OBIEE STARTUP ISSUE.

Applies to:
Business Intelligence Suite Enterprise Edition – Version: 10.1.3.4.2 [2405] and later   [Release: 10g and later ]
Information in this document applies to any platform.

OBIEE 10g (10.1.3.4.2) And Microsoft IIS 7

Symptoms

The server OS is Microsoft Windows Server 2008 Enterprise Edition x86 32 bit and it has Microsoft IIS 7 on it.
The installation guide states that on selecting the Basic installation type, the installer should present an option to select either Oracle Containers for J2EE (OC4J) version 10.1.3.1 or Microsoft IIS, if IIS is installed on the server.
However, when you run the installer, you are not presented with this option.
Install guide says:

To deploy Oracle BI Presentation Services and Plug-in with Microsoft IIS 1 Choose Advanced or Basic installation type.
2 After you select the components to install, and if Presentation Services or Presentation Services
Plug-in are selected, you are prompted to select the application server.

Select Microsoft IIS.
The ISAPI plug-in is installed in IIS.
3 When the Basic installation type is selected, the installer installs a stand-alone version of OC4J and deploys Oracle BI Systems Management and Oracle BI Publisher in this container.

However the screen does not appear in order to select IIS.

Cause

IIS 7 not properly installed
Solution

You need to check that IIS7 is properly installed in that the following services are present and enabled:
WAS
W3SVC
IISADMIN
WMSVC
The installer checks that IIS is installed by checking that IISADMIN and W3SVC services are present and enabled.
IISADMIN service is only available if you have IIS 6 Management Compatibility options installed.
So install IIS6 Management Compatibility options for IIS7 and try again.

References

BUG:13599500

Applies to:

Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.2 [2405] and later   [Release: 10g and later ]
Information in this document applies to any platform.

OBIEE Software Configuration Management

[ad#banner]

There’re some very interesting blog posts about handling OBIEE’s SCM process, however, the difficulty is that each project is different. For example, there’re so many environmental factors involved – everything depends on location. In some enterprises, they use corporate-wide version-control systems (such as TFS). In some places, they don’t. Some companies have a rigid DEV to SIT to UAT to PROD process, in some companies – such development is done ad-hoc.

Sometimes, webcat is copied manually. Sometimes, it’s merged online. Sometimes it’s archived and extracted.

Myriad options and almost endless number of possibilities.

Sometimes, the RPD is merged locally, sometimes it’s imported, sometimes, it’s done via MUDE projects. Everyone is different and each situation is different. And here’s when experience and expertise come into play – an experienced consultant can provide the best way of handling OBIEE’s deployment process.

Interesting discussion about IIS and OC4J

There’s an interesting discussion about IIS and OC4J on OTN- OC4J discussion

I think there’s a lot of confusion as to what is a difference between web server and web application server (apparently web server just serves static HTML (it can also server PHP/ASP pages), however, doesn’t run applications — on the other side – it’s tough to distinguish between dynamic web applications written in script languages and Java container OC4J). If you

I think that it’s clear from the discussion that OBIEE requires IIS (in Windows server) and OC4J is an quasi-optional module for BI Publisher and Scheduler.

Another thing -check your connection pool settings. According to Oracle, BI Server might crash if there’re “Several Connection Pools in the custom RPD had ‘Execute Queries Asynchronously’ enabled. This is no longer recommended in OBI 10g as it can cause the OBI EE (NQServer) Server to crash.”

This is addressed in Bug No.BUG 7634602 – ‘OBI SERVER CRASH – 3-818156441′

Strange Presentation Services behavior

While auditing our OBIEE security model We’ve stumbled into behavior that we think is a bug. If it’s not, then I hope it’s a feature that would be removed in the future. Here’s a description of how we get this particular Presentation services behavior:

1. Summary – Our goal is to be able to add new users in RPD in online mode, assign them to their respective repository security groups ( based on data-level and row-level security), and during their first login  have them automatically assigned to one of 2 appopriate Presentation catalog group (that is used for presentation security, such as prohibiting overwriting of shared reports). We use OS authentication model with Impersonator (OBIEE picks up and strips users’ OS username). However, the problem doesn’t seem to be SSO-related or OS-related.

These’re steps to reproduce:

a) create new user “test_user1″ in RPD “Business Intelligence” group (for Presentation group “Business Intelligence”). Check-in RPD and save it.

b)  login with the “test_user1″ first time to OBIEE

c) go to My Account. You can clearly see that “test_user1″ is a member of Presentation group “Business Intelligence” (which is good for us and correct at the same time)

d) log-out. close browser. clean cookies. log-in as an administrator (member of Presentation Services Admin). Go to Settings –> “Oracle BI Presentation Services Administration”–>”Manage Presentation Catalog Groups and Users”
Select Edit for the “Business Intelligence” group

as you can see – “test_user1″ isn’t there

e) If we click on “Add New Member”-> “Show Users and Groups” – there’ll be a red-stop symbol (padlock image)

We’ve filed an SR with Oracle Support, and still waiting for an answer. I personally think that in future OBIEE releases – the Presentation Services should be tied closer with BI server – maybe going as far as consolidating those 2 modules.

And have a nice work week!