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.