Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Troubleshooting the Siebel Data Warehouse > Running the Data Migration Workflow for Preconfigured Siebel Industry Applications Content >

UNIX Installation Issues with the Siebel Data Warehouse

---

Problem. When starting Informatica in pmserver.log, the following error messages appear:

FATAL ERROR: LM_36023 [Tue Mar 11 23:12:41 2003] : (9968|1) The IP address [172.0.129.141] for this machine did not match the IP address [172.20.94] in the repository for server [SIEBEL_DW_SERVER].

FATAL ERROR: SF_34014 [Tue Mar 11 23:13:41 2003] : (9968|1) Server initialization failed.
INFO: SF_34014 [Tue Mar 11 23:13:41 2003] : (9968|1) Server shut down.

Solution. Launch Workflow Manager, then right-click on SIEBEL_DW_REP and click More. Make sure the Host Name is the machine name where the Informatica Repository Server resides.

Problem. When connecting to the Informatica Repository Server from the Repository Administration Console, the following error messages:

• Oracle databases running on Solaris or HP:

  Database Connection Error: Database driver event...Error occurred loading library [Bad magic number for shared library: /export/home/oracle/9.0.1.3/lib/libclntsh.sl]Database driver event...Error occurred loading library [libpmora8.sl]

  Solution. Use Oracle 32-bit library.

  1. Set the environment variable as follows: LD_LIBRARY_PATH=/export/home/oracle/9.0.1.3/lib32
  2. Restart the Informatica Repository Server service.
• DB2 databases running on AIX:

  (17764|1) Database Connection Error : Database driver event...Error occurred loading library [No such file or directory]Database driver event...Error occurred loading library [libpmdb2.a]

  Solution. Set the environment variable as follows:

  • For DB2 v8:

  setenv LIBPATH ${LIBPATH}:/usr/opt/db2_08_01/lib

  • For DB2 v7

  setenv LIBPATH ${LIBPATH}:/usr/lpp/db2_07_01/lib

  Restart the Informatica Repository Server service, after setting the variable.

Problem. When restoring the Informatica repository, the following error message appears in the dwdb.log:

ERROR : OBJM_54543 [Tue Mar 25 17:47:16 2003] : (164|2484) DataBase error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Solution. The database is Unicode and the environment variable is needed.

• For Unicode UTF8, set the environment variable to
  American_America.UTF8.
• For Unicode AL32UTF8, set the environment variable to
  American_America.AL32UTF8.

Problem. When starting pmserver on UNIX, the following error message appears:

INFO : LM_36039 [Thu Mar 27 11:40:29 2003] : (6772|1) The maximum number of sessions that can run simultaneously is [10].
FATAL ERROR : CMN_1011 [Thu Mar 27 11:40:29 2003] : (6772|1) Error allocating system shared memory of [3000000] bytes for [Load Manager Shared Memory]. Error is [0]: []
FATAL ERROR : SF_34004 [Thu Mar 27 11:40:29 2003] : (6772|1) Server initialization failed.
INFO : SF_34014 [Thu Mar 27 11:40:29 2003] : (6772|1) Server shut down.

Solution. In the pmserver.cfg file, change MaxSessions to 15 and change LMSharedMem to 3000000.

NOTE:  For each 10 count increase of MaxSessions, increase the LMSharedMem by 2000000 bytes.

Problem. A session fails (any session), and the following error message appears:

TM_6227 Error: codepage incompatible in session [SDE_RecordExtractStart]. The source database DB2_OLTP and server SIEBEL_DW_SERVER do not have compatible code pages. (One way compatibility is required).

Solution. For Informatica servers running on UNIX, in the pmserver.cfg file, set ValidateDataCodePages to No.

For Informatica servers running on Windows, navigate to Informatica Server setup >  Configuration, and remove the check from the Validate Data CodePages check box.

Problem. When trying to start the Informatica Server, the following error message appears:

sdcb50a125{qauser7a}/> pmserver

exec(): 0509-036 Cannot load program pmserver because of the following errors:
0509-150 Dependent module libpmcef.a could not be loaded.
0509-022 Cannot load module libpmcef.a.
0509-026 System error: A file or directory in the path name does not exist.

Solution. Set the environment parameters as follows:

setenv PATH /export/home/informatica/pm:.:${PATH}
setenv LD_LIBRARY_PATH /export/home/informatica/ pm:${LD_LIBRARY_PATH}

Bookshelf Home | Contents | Index | Search | PDF