Resolving Common Informatica Integration Errors
Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent
This error occurs because the x86 VC++ libraries are not installed on the system hosting the Secure Agent.
List of supported Microsoft Visual C++ Redistributables.
The user name or Salesforce user name is already in use. Enter a different value
This error message means that the user you are trying to set up has already clicked the Single Sign On button in Informatica in any Salesforce organization including Development, Sandbox or Test orgs. What happens is that Informatica creates a secondary Org. You need to have the user remove their information from the incorrect Informatica Org before you can set them up as a user in your (correct) Org.
Resolution:
Step 1: Create a New User in the errant Informatica Org (usually the one without an Agent)
Example: Name+secondary@yourschool.edu
Step 2: Log into Informatica Cloud directly (http://www.informaticacloud.com/) using the New User from Step #1
Step 3: Edit the “Organization” and change the “Job Execution Profile:” to the New User created in Step #1 – otherwise will receive the following error message in the next step:
Cannot delete user Name@yourschool.edu as it is being used as the Job Execution Profile. Edit the Organization to change Job Execution Profile, then try to delete the user again.
Step 4: Copy the information for the Admin and then Delete the Admin User from the errant Informatica Org – so it can be recreated in the correct Informatica Org (with the same name – otherwise Informatica will say it’s in a duplicate User)
Step 5: Recreate the Admin User in the correct Informatica Org
Error message java.lang.OutOfMemoryError
Error: Error message java.lang.OutOfMemoryError: Java heap space; nested exception is: java.lang.OutOfMemoryError: Java heap space
You will see this error message due to the default memory allocated by your server.
You will need to make a change to your Secure Agent to correct this issue.
Navigate to Configure and search for Secure Agents Click the pencil icon to Edit your secure agent Select "DTM" from the Type drop down under the System Configuration Details section Enter "-Xmx1024m" in the JVM Option 1 field Save Restart the Secure Agent
Note: JVMOption is a configurable value. In this case you can configure -Xmx1024m
where in the four digit 1024 can be changed to a higher value.
https://kb.informatica.com/howto/6/Pages/17/336913.aspx
Failed to run job because of missing VC++ libraries
When user installed/updated a new agent they got the following error: "Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent"
If you receive this error, you should download the correct libraries for Windows64 agent from the URL below:
Microsoft Visual C++ Redistributable latest supported downloads
Connection error [FATAL] Login failed
Error: Connection error [FATAL] Login failed. User [XXX]. Fault code [SOAP-ENV:Client]. Reason [Timeout]? Or "GetServerTimestamp Failed.
If your server environment enforces strict firewall configuration and you are connecting to Salesforce in your Data Synchronization Task, you may have to add the following
Salesforce IP ranges:
204.14.232.0/23 East Coast Data Center (set one)
204.14.237.0/24 East Coast Data Center (set two)
96.43.144.0/22 MidWest Data Centers
96.43.148.0/22 MidWest Data Centers
204.14.234.0/23 West Coast Data Center (set one)
204.14.238.0/23 West Coast Data Center (set two)