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 Oracle Business Analytics 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 Informatica 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.

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.

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 Oracle Business Analytics 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 Oracle Business Analytics 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.

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.

[IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006 sqlstate = 07006 [IBM][CLI Driver][DB2/AIX64] SQL0303N A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatible. SQLSTATE=42806 sqlstate = 42806This issue comes up when you use 'Unicode' data movement in Informatica.

The target table that the mapping is inserting into is a non-unicode table. Make sure the table is created as an Unicode table.