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]
- 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:
setenv LIBPATH ${LIBPATH}:/usr/opt/db2_08_01/lib
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 columnSolution. The database is Unicode and the environment variable is needed.
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 to3000000
.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 |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |