Oracle® Business Intelligence Applications Installation and Configuration Guide > Troubleshooting Oracle Business Intelligence Applications > Executing Oracle Business Analytics Warehouse Exception Reports >

Oracle Business Analytics Warehouse Installation and Initial Configuration Issues


Table 92 provides information about problems and solutions related to the installation and initial configuration of the Oracle Business Analytics Warehouse.

Table 92. Oracle Business Analytics Warehouse Installation and Configuration Issues
Symptom/Error Message
Probable Cause/Solution

Cannot connect to the Oracle Business Analytics Warehouse running on DB2.

Make sure that the DB2 configuration matches the requirements listed in IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse.

After installing Informatica's ODBC driver (V3.5) on a Windows computer, you cannot open the Query Analyzer, and the Enterprise Manager shows an error message.

The ODBC driver installation replaces the odbcbcp.dll file with an older version. The Informatica documentation contains the procedure for correcting this problem.

Cannot connect to transactional database from Informatica.

Make sure that the server running the Informatica Server software has an ODBC connection to the transactional database using a Siebel ODBC driver and an ODBC connection to the Oracle Business Analytics Warehouse using the Merant Closed 3.5 32-bit driver.

Error: ORA-12541: TNS:no listener.

Check the Compatibility tab in Informatica service configuration. It should be Oracle 8. If it is not set to Oracle 8, change it and restart the Informatica server.

Error 2140 (Informatica service failed to start).

The server may not be started or the Informatica Service may not be started. See Informatica's installation and configuration guide on Siebel eBusiness Third-Party Bookshelf for detailed information.

Informatica installation fails with an Unhandled Exception error and displays a message similar to this: "Error Number: 0x80040707. Description: Dll function call crashed: ISRT._DoInstall."

The computer is probably running out of virtual memory. Restart the computer and reinstall Informatica.

After selecting "Warehouse Default Amount (Yen)" as the currency symbol, the dollar sign ($) is still displayed.

The currencies.xml file must be edited. For instructions, see Changing the Default Currency in Analytics Applications.

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.