Resolving Common Informatica Integration Errors
|
Issue/Error |
Resolution |
|---|---|
| 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. Here are the steps to fix the issue. 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: 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. Note: JVMOption is a configurable value. In this case you can configure -Xmx1024m |
| I installed/updated a new agent and 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. 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 |