Table 57. UNIX Installation Issues with Siebel Data Warehouse
|
|
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. |
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. |
When connecting to the Informatica Repository Server from the Repository Administration Console, the following error messages appear:
- 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]
|
Use Oracle 32-bit library.
- Set the environment variable as follows: LD_LIBRARY_PATH=/export/home/oracle/9.0.1.3/lib32
- 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]
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.
|
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 |
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 .
|
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. |
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.
|
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). |
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. |
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. |
Set the environment parameters as follows: setenv PATH /export/home/informatica/pm:.:${PATH} setenv LD_LIBRARY_PATH /export/home/informatica/ pm:${LD_LIBRARY_PATH}
|