Tag Archives: IIS

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.

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′