Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Troubleshooting Siebel Data Warehouse >

Installation and Initial Configuration Issues


Problem. Cannot connect to the Siebel Data Warehouse running on DB2.

Possible cause. Make sure that the DB2 configuration matches the requirements listed in DB2-Specific Database Requirements

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

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

Problem. Cannot connect to Siebel Transaction Database from Informatica.

Possible cause. Make sure that the server running the Informatica Server software has an ODBC connection to the Siebel Transaction Database using a Siebel ODBC driver, and an ODBC connection to the Siebel Data Warehouse using the Merant Closed 3.5 32-bit driver.

Problem. Error: ORA-12541: TNS:no listener.

Possible cause. 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.

Problem. Error 2140 (Informatica service failed to start).

Possible causes. The server may not be started or the Informatica Service may not be started. Read the Informatica Installation and Configuration Guide for detailed information.

Problem. 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."

Possible causes. Most likely the computer is running out of virtual memory. Restart the computer and reinstall Informatica.


 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003