Informatica Environmental Level Issues.

Issue 1:

Informatica client was getting exited with the error "impcpyobj.cpp:1081" while migrating the objects . Getting a pop up window and client is getting exited. This is a known issue.

• This issue comes up when there are invalid objects present in your XML.
• This issue comes up when there are corrupted source and targets present in target repository or source repository.
• This is issue also comes up when respective library file (impcpyobj.cpp) is missing in your Informatica client.

Solution :

• Delete the corresponding objects (mapping, session) in target repository.
• Delete the sources and targets too in target repository.
• Migrate the objects.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue 2 :

Problem statement:

One of the SFTP script was not working fine Occasionally . Occasionally it was getting/putting the file. Or getting failed with below error

$ more ftp_temp_log.txt

Connecting to twdc0098.cp.com...

ld.so.1: ssh: fatal: relocation error: file /usr/bin/ssh: symbol SUNWcry_installed: referenced symbol not found

Connection closed

Analysis :

infaad@twdc00681 # ldd /usr/bin/sftp

        libsocket.so.1 =>        /lib/libsocket.so.1

        libcrypto.so.0.9.7 =>    /app/informatica/Infa/server/bin/libcrypto.so.0.9.7

        libc.so.1 =>     /lib/libc.so.1

        libnsl.so.1 =>   /lib/libnsl.so.1

        libdl.so.1 =>    /lib/libdl.so.1

        libmp.so.2 =>    /lib/libmp.so.2

        libmd.so.1 =>    /lib/libmd.so.1

        libscf.so.1 =>   /lib/libscf.so.1

        libdoor.so.1 =>  /lib/libdoor.so.1

        libuutil.so.1 =>         /lib/libuutil.so.1

        libgen.so.1 =>   /lib/libgen.so.1

        libm.so.2 =>     /lib/libm.so.2

        /platform/SUNW,Sun-Fire-V490/lib/libc_psr.so.1

        /platform/SUNW,Sun-Fire-V490/lib/libmd_psr.so.1

Solution :

The following Binaries path has been added to script. So the script will have get access to binaries stored Bin directory

unset env LD_LIBRARY_PATH

export LD_LIBRARY_PATH

set env LD_LIBRARY_PATH/bin

export LD_LIBRARY_PATH

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue 3:

Informatica session was failing with the below error.

ORA-01461 : can not bind a LONG value only for insert into a LONG column

Solution :

• This issue is an environmental level issue.The NLS_LANG variable has to be reset to AMERICAN_AMERICA.UTF8
• Take the backup of the .profile file.
• Edit the .profile file change the NLS_LANG variable to AMERICAN_AMERICA.UTF8.
• Run/Execute the ..profile file.
• Bounce the Informatica environment completely.
• Now run the loads.

Previous NLS_LANG Variable :    AMERICAN_AMERICA.AL32UTF8

Reset NLS_LANG Variable :       AMERICAN_AMERICA.UTF8

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue 4:

Informatica Integration service was getting crashed.When checked on the node.log we found the below error.

“Exception in thread "pool-1-thread-135" [DTF_0001] An error occurred in the underlying transport layer: [Greeting exchange failed]

java.lang.OutOfMemoryError: Java heap space.”

Solution:

The primary node has gone with [java.lang.OutOfMemoryError] and you need to increase the java heap size in order to resolve the issue. Please follow the below steps

1. Go to the <PowerCenter_Home>/server/tomcat/bin directory.

2. Create a (backup) copy of the infaservice.sh file.

3. Open the infaservice.sh file.

4. Modify the INFA_JAVA_OPTS entry:

Default:

     INFA_JAVA_OPTS=-Xmx512m

     Set this to 1024 MB:

    INFA_JAVA_OPTS=-Xmx1024m

5. Restart the PowerCenter Services

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue 5:

Sessions were failing in Production Repository with error "session task terminated unexpectedly" sessions having source as Flat File, Target as Oracle and having Lookup Cache as Teradata.

Solution:

When we analyzed from our end the sessions are getting succeeded when pointing the connections to Prod db in Qa server and the same sessions getting succeeded when used Flat file as target in Prod.

Below is ldd output from Qa server

inferp@tsgsq1742 # ldd /opt/oracle/product/9.2.0/lib32/libclntsh.so

        libwtc9.so =>    /opt/oracle/product/9.2.0/lib32/libwtc9.so

        libnsl.so.1 =>   /lib/libnsl.so.1

        libsocket.so.1 =>        /lib/libsocket.so.1

        libgen.so.1 =>   /lib/libgen.so.1

        libdl.so.1 =>    /lib/libdl.so.1

        libsched.so.1 =>         /usr/lib/libsched.so.1

Below is from Prod server

$ ldd /opt/oracle/product/9.2.0/lib32/libclntsh.so

warning: ldd: /opt/oracle/product/9.2.0/lib32/libclntsh.so: is not executable

        libwtc9.so =>    /opt/oracle/product/9.2.0/lib32/libwtc9.so

        libnsl.so.1 =>   /usr/lib/libnsl.so.1

        libsocket.so.1 =>        /usr/lib/libsocket.so.1

        libgen.so.1 =>   /usr/lib/libgen.so.1

When checked in Prod server /opt/oracle/product/9.2.0/lib32/  Library file "libclntsh.so" library file was not having execute permission  and it should be oracle  user and group name as dba but its showing user as 68303.

Below from Prod server.

$ pwd

/opt/oracle/product/9.2.0/lib32

$ ls -ltr *libclntsh.so*

-rwxrwxr-x   1 68303    5949     16427640 Apr 12  2007 libclntsh.so.9.0

lrwxrwxrwx   1 230      5949          16 Apr 12  2007 libclntsh.so -> libclntsh.so.9.0

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue 6 :

On Windows 7 Operating System newly installed Informatica Client (9.1/9.5) Workflow Monitor is getting hung and when logged in to repository it's throwing an error Unable to connect to Integration Service.

Soultion :

Step 1 :  Login to your local system with System Administrator User Account.

Step 2 :  Open The command prompt "cmd"

Step 3 :  Run the below DOS command.

reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters" /v DisabledComponents /t REG_DWORD /d 0 /f

Step 4 : Open The Workflow Monitor Now see the magic you can easily see the integration service with folders and worklows.

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue :

Informatica Sessions are failing with Inconsistent recovery cache.

CMN_1769 Inconsistent recovery cache.

Cause :

1)The Integration Service cannot run the session enabled for recovery because the recovery cache file does not contain valid data.

2)The session could not override the metadata file. This error may comes while rebooting the service or bouncing server or unexpectedly down the server or After bouncing the server.

Solution :

Delete all recovery cache files associated with the session and run the session with recovery disabled to create a new cache file.

To determine which recovery cache file is associated with the session, compare the time at which the file was last modified with

the time the session failed. If the times are the approximately the same, you can associate the cache file with the session.

You can also refer to the cache file names to determine which files are associated with the session.

Recovery cache file names use the following format :

pmgmd_metadata_<repository ID>_<workflow ID>_<folder ID>_<session ID>_<transformation ID>_<partition ID>_<group ID>_<checkpoint ID>_<sequence number>.dat

• For example, in the following file name, the session ID is 102:

pmgmd_metadata_7661f424_379f_11d7_947e_f63b53abfef7_103_2_102_0_0_0_1_1.dat

• The sessionstate file is like below

 pmgmd_sessionstate_aea92d56_5142_11da_885b_d32ec32e1b02_4921_59_4687_0_0_0_1_1.dat

Use the REP_LOAD_SESSIONS MX View on the repository database to determine the name of the session associated with the session ID. You can use REP_LOAD_SESSIONS to view information about reusable sessions.  

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Issue :

We received the below error in the Adminconsole when we were recycling the services for Integration service, The error was showing that the HTTP port was blocked by another process.

                                                                   

Solution : Go to the OS server machine, Check all the services which are running on the machine, Kill all the processes (Do a clean for all the processes) & start the services from the beginning.