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 IBM DB2 UDB-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 transactional database from Informatica.

Possible cause. Make sure that the server running the Informatica Server software has an ODBC connection to the Siebel transactional 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. See Informatica's 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
 Published: 09 September 2004