Informatica and Loading Issues

Table 61. Informatica and Loading Issues
Symptom/Error Message	Probable Cause/Solution
Double-clicking the workflow yields a Workflow Manager error message: "The system cannot find the file specified."	The session log files are not set up properly. You also may need to change the text editor.
Using Oracle, some mappings hang while running when performance statistics are switched on.	When running some Informatica mappings for loading the Siebel Data Warehouse, turning on the Performance Statistics can cause the mapping to hang. The only workaround is to increase the values of the LMSharedMemory and MaxSessions variables in Informatica. The risk of increasing the LMSharedMemory too much is that it may start to have a serious effect on overall performance of the machine that the Informatica server is running on.
When you execute a workflow on the Informatica Workflow Manager, Informatica returns the following error message: "Request to start workflow (workflow name) on server (server name) not successful."	This can happen due to a server time-out property that is usually set to 20 or 40 seconds. When you try to run a large workflow, every session in that workflow is fetched into the server's memory. If this takes longer than the server time-out property, the server returns a message that the workflow was unable to run. However, the workflow is running, but the server just needs time to complete fetching the sessions into memory. Double-click the workflow to view the log file details.
When running Full_Extract_Siebel_DW or Refresh_Extract_Siebel_DW, Informatica returns errors similar to: TE_7007 Transformation Evaluation Error; current row skipped... TE_7007 [<<Transformation Error>> [to_date]: Date function error to_date('19010101', 'DD-MON-YYYY')	Incorrect date entry in the SME Date Format field in the System Preferences. The format is YYYYMMDD.
When running Full_Load_Siebel_DW, Informatica returns errors similar to: CMN_1014 Error creating semaphore... TM_6006 Error initializing DTM for session... TM_6006 [s_CR18a1. Load W_PROG_DM_TMP - Program Records]	Insufficient semaphores allocated. Allocate more semaphores on the Data Warehouse Server. The change becomes effective when you reboot.
Informatica (RDBMS is DB2) gives the following error message: Error occurred unlocking [SDE_ServiceRequestDimension1]. An error occurred while accessing the repository[[IBM][CLI Driver][DB2/6000] SQL0955C Sort memory cannot be allocated to process the statement. Reason code = "". SQLSTATE=57011] DB2 Fatal Error[FnName: ExecuteDirect -- SQLSTATE=57011 [IBM][CLI Driver][DB2/6000]	The DB2 parameter "SHEAPTHRES" is too small.
Informatica produces the error "Unable to connect to the server" when running a full load of the Siebel Data Warehouse (Full_Load_Siebel_DW_Dimensions).	The last Designer session was not validated. Part of the development process of working with Designer is to always validate any changes to Informatica mappings definitions and sessions after the change is saved in repository.
When loading the data warehouse, Informatica reports a lock problem.	Either someone has a session open or there is a dead session. Make sure no one has any open sessions. If no sessions are open, then follow the Informatica documentation on removing locks caused by dead sessions.
After changing an Informatica mapping, you may get an error message when trying to execute "Full_Load_Siebel_DW_Facts." The error message is "Unable to connect to the server."	This is due to Informatica mapping objects that have been modified and this does not automatically validate the session objects. You must validate all changes to any existing mappings in the Informatica repository.
Session SDE_RecordLoadStart fails due to unique constraint error while executing Full_Load_Siebel_DW_Dimensions or Full_Load_Siebel_DW_Facts.	This could be because the previous full load did not complete successfully. Fix the problem that caused the previous load session to fail. Make sure you start the process from the last entry of Load_RestartNextWorkflow # before the failed session, and restart the workflow process from that point. If you have to re-extract the data from the Siebel transactional database because something had to be fixed in the source database to resolve the load error, then you must restart the ETL process. Truncate S_ETL_INC_STAT in the Siebel transactional database, then enable the Extract and Load workflows and rerun them.
Session SDEINC_RecordExtractStart fails due to unique constraint error while executing a Refresh workflow.	This could be because the previous load or refresh did not complete successfully. Fix the problem that caused the previous refresh session to fail. Make sure you start the process from last entry of %RestartNextWorkflow # before the failed session, and restart the workflow process from that point.
The session fails and you receive the following error code: Error "TE_7042 Aggregate Error: File Operation Error	This is due to a disk space limitation. Check the /Informatica/PowerMart/Cache/Check directory for available disk space, also check the limits (ulimit) of the account used to start PowerMart.
Informatica sessions get deadlocked and eventually fail when they try to do a "select" from the repository table OPB_OBJECT_LOCKS. This problem sometimes occurs on MSSQL server databases.	This is possibly caused by a limited number of resources on the MSSQL Database Server. The workaround is to execute the following MSSQL specific SQL command on the Siebel Data Warehouse: DROP INDEX OPB_OBJECT_LOCKS.OPB_OBJ_LOCKS_IDX DROP INDEX OPB_OBJECT_LOCKS.OPB_OBJ_LOCKS_IDX2 DROP INDEX OPB_OBJECT_LOCKS.OPB_OBJ_LOCKS_IDX3 Upon completion of executing these commands, continue executing the workflow processes to load the Siebel Data Warehouse.
An error may occur when trying to send a post session email notification using MS Outlook 2000. Refer to Informatica release notes for further information.	After installing Informatica Server on Windows, copy the file mapi32.dll from winnt\\system32 to the bin folder where the Informatica Server is installed, overwriting the existing mapi32.dll in that directory. Start the Informatica Server so that the Informatica Server can use the new mapi32.dll. The Extended MAPI Error. MAPILogonEx failed[2147746065] error indicates that the logon is not configured correctly. Check the following: 1.             Under Services > Informatica> Logon, make sure the login (domain\username) and password are correct. 2.             Under Control Panel > Mail (it may also be called Mail and Fax or Exchange) > Services > Show Profiles, make sure the mail profile is correct. 3.             Under Programs> Informatica Server > Informatica Server Setup> Miscellaneous, make sure the MS Exchange profile is correct.
While creating a custom session, bulk load mode does not work properly with SQL Server.	Change the mode to "normal" in Informatica repository for the session. The "normal" mode must be used everywhere for SQL Server in all of your custom sessions.
When running IMR, you may receive an error message box which states "The evaluation period for this Oracle ODBC driver has expired. Please call Merant to obtain a production version of this Oracle ODBC driver."	This is caused by a down-level ODBC driver license key. Rename or move ivodbc.lic, lvodbc.lic (if it exists), and lvdw.lic (if it exists). Make sure you have only one license file named ivdw.lic in winnt\system32. This eliminates the problem.
Outlook closes when sending out a notification of finishing the ETL process.	Informatica is closing Outlook. This issue is known to Informatica and is scheduled to be resolved in an upcoming release. Until then, create a second profile in Outlook and add that profile name to the Informatica server setup.
Oracle 8i sessions running in bulk mode fail and return an error message similar to: WRITER_1_1_1> CMN_1022 Database driver error... CMN_1022 [ ORA-00600: internal error code, arguments: [kpodpmop_01], [2], [], [], [], [],[], [] Or MAPPING> TE_7022 TShmWriter: Initialized MAPPING> Sat Jan 26 13:54:45 2002 MAPPING> TE_7001 Internal error: Failed to allocate a target slot. Sat  MAPPING> Jan 26 13:54:45 2002 TE_7017 Failed to Initialize Server MAPPING> Transformation BLK_ALL_DATATYPES1 Sat Jan 26 13:54:45 2002MAPPING> TM_6006 Error initializing DTM for session...MAPPING> TM_6020 Session [s_BULK_LONG] completed at [Sat Jan 26 13:54:45 2002]	This problem is an Oracle 8i defect. It has been resolved in Oracle 9i. The workaround is to run the session in Normal mode. To do so, in Workflow Manager navigate to the Targets window, and change the Target Load type to Normal.
During an ETL execution, when Informatica and DAC servers use DB2 Connect version 7 to talk to DB2/390 version 7 OLTP and data warehouse databases, you receive an error message similar to the following: SEVERE: [IBM][CLI Driver][DB2] SQL0191N Error occurred because of a fragmented MBCS character. SQLSTATE=22504 103 SEVERE Tue May 11 21:37:29 CDT 2004 [IBM][CLI Driver][DB2] SQL0191N Error occurred because of a fragmented MBCS character. SQLSTATE=22504	This problem is a DB2 Connect version 7 (IBM) defect related to code page conversion. The problem has been resolved in DB2 Connect version 8. To correct the problem, do the following: 1.             Download the file IBM01140.ucs from ftp://ftp.software.ibm.com/ps/products/db2/fixes/english/siebel/siebel7/Conversion_Files to the /sqllib/conv directory. 2.             Make a copy of the file and rename it to IMB05348.ucs.
When an ETL process is running and tasks fail, Informatica returns an error similar to the following Error while running Workflow Description: ERROR : TM_6292 : (3040|4868) Session task instance REP_12400 [Repository Error ([REP_51055] Repository agent connection failed. [System Error (errno = 121): The semaphore timeout period has expired. . (Cannot read message. Read 5824 bytes.)])]	This issue is related to the network. The workaround is to increase the Timeout parameter values in the Informatica Repository Server Administration Console. 1.             In the left pane of the Repository Server Administration Console window, right click your repository and select Edit Connection. 2.             In the Network tab, enter 9 as the value for the parameters MessageReceiveTimeout and MessageSendTimeout. 3.             Stop and start the Informatica Repository Server. 4.             Start the Informatica Server.