Faqs

Faqs Informatica Salesforce dotcom Frequently Asked Questions and knowledgebase

Informatica SFDC SaaS

FileIO connector (2)

How to use the fileIO connector to upload attachments in batch to Salesforce

 How to use the fileIO connector to upload attachments in batch to Salesforce

 

An easier explanation of this doc with a real life example.

 

1.  Create a connection, with as type ‘FileIO (Informatica Cloud Labs)’

Informatica FileIO connection

2. Point the source object to, a directory on the Secure Agent connection being used, the directory which holds two things:

(a)  The attachments (i.e. pictures, PDF etc)

(b)  The CSV file, source file, which holds the attachmentnames as well as the corresponding SFDC ID’s.

contents of the file, example:

FILENAME,SFDC_PARENT_OBJECT_ID
xest.pdf,001J000000smoFMIAY
xest1.pdf,001J000000smoKTIAY
xest2.pdf,001J000000smoMNIAY

 

FileIO Job Wizard Source screen

3. In the target screen of the jobwizard, choose a connection to a SFDC environment (ie sandbox) and of course choose as target table the SFDC Attachment table. A preview of one record is shown.

FileIO job wizard target screen

4. In the next tab, setup a data filter to ensure only the attachments itself are processed.

FileIO job wizard datafilter screen

5. And now for the trickiest part, the Field Mapping. Check especially the parentID value carefully. See also the second screen, which you get to see if you change the expression/look up for this!

FileIO job wizard fieldmapping screen (1)

 

FileIO job wizard fieldmapping screen (2)

[notice]

Check also carefully that, the body field value, in this case Base64 is choosen, matches the value in the sourcefield!![/notice] 

 

These are the main ingredients to succesfully upload attachments, as notes, towards accounts in Salesforce. The only thing I still come accross is a 100KB upload size limitation, set by Informatica?

 

[warning]Update Sept 3 2013:[/warning]

Open C:\Program Files (x86)\Informatica Cloud Secure Agent\main\tomcat\saas-infaagentapp.bat and

add -DfileIO.maxFileSize=10485760  to the last line, with %JAVA_HOME%\bin\java on it, like this:

%JAVA_HOME%\bin\java %JRE_OPTS% %INFA_DEBUG% %INFA_MEMORY% %INFA_SSL% -DfileIO.maxFileSize=10485760 -Ddtm.path=..\bin\rdtm -Dsun.reflect.inflationThreshold=0 -cp %JAVA_LIBS% com.informatica.saas.tomcat.AppLoader ..\infaagent.ini tomcat.cfg

This sets the max filesize to 10MB.

See also https://community.informatica.com/docs/DOC-3140 about “Handling Large Files”

 

examples of files:

[pmrdtm.cfg]

JVMClassPath=pmserversdk.jar;
JVMOption1=-Xmx512m
JVMOption2=
UseLogService=No
ServerName=rDTM
PMUser=rDTMUser
PMUserNamespace=rDTMUserNamespace
PMPassword=rDTMPass
RepositoryName=XMLRepository
RepositoryDomain=rDTMDomain
OptimizeODBCRead=No
OptimizeODBCWrite=No
DataMovementMode=UNICODE
RecordSessStatInRepo=No
ValidateDataCodePages=No
__PMOV_FFW_ESCAPE_QUOTE=Yes
AgentConnectionTimeout=5
LogsInUTF8=Yes
SalesForceConnectionTimeout=300

JVMLibPath=..\..\..\jre\bin\server\jvm.dll
$PMLookupFileDir=..\..\rdtmDir
$PMRootDir=..\..\rdtmDir
$PMSessionLogDir=..\..\rdtmDir\logs
$PMBadFileDir=..\..\rdtmDir\error
$PMCacheDir=..\..\rdtmDir\cache
$PMStorageDir=..\..\rdtmDir
$PMTargetFileDir=..\..\rdtmDir
$PMSourceFileDir=..\..\rdtmDir
$PMExtProcDir=..\..\rdtmDir
$PMTempDir=..\..\rdtmDir\temp
$PMWorkflowLogDir=..\..\rdtmDir\logs
SfdcProxyFile=..\..\proxy.ini
MappingImportLogDir=..\..\rdtmDir\logs

 

[saas-infaagentapp.bat]

@echo off
set SCRIPT_DIR=%~dp0.

call “%SCRIPT_DIR%”\saas-infaagentapp_config.bat
set INFA_MEMORY=-Xms256m -Xmx512m -XX:MaxPermSize=128m
set JAVA_HOME=..\..\jre
REM set INFA_DEBUG=-Xdebug -Xrunjdwp:transport=dt_socket,address=7889,server=y,suspend=n -ea -esa
set INFA_DEBUG=-ea -esa
REM set INFA_SSL=-Djavax.net.ssl.keyStore=infaKeyStore -Djavax.net.ssl.keyStorePassword=infapass

set JAVA_LIBS=.;saas-apploader.jar
set JAVA_LIBS=%JAVA_LIBS%;lib\tomcat-embed-core.jar
set JAVA_LIBS=%JAVA_LIBS%;lib\tomcat-embed-jasper.jar
set JAVA_LIBS=%JAVA_LIBS%;lib\tomcat-embed-logging-juli.jar
set JAVA_LIBS=%JAVA_LIBS%;lib\log4j-1.2.16.jar
set JAVA_LIBS=%JAVA_LIBS%;..\agentcore
set JAVA_LIBS=%JAVA_LIBS%;..\agentcore\saas-agentcore.jar
rem set JAVA_LIBS=%JAVA_LIBS%;..\agentcore\saas-common.jar
set JAVA_LIBS=%JAVA_LIBS%;..\agentcore\commons-httpclient-3.1.jar
set JAVA_LIBS=%JAVA_LIBS%;..\agentcore\commons-codec-1.5.jar
set JAVA_LIBS=%JAVA_LIBS%;..\agentcore\commons-logging-1.1.1.jar
set JAVA_LIBS=%JAVA_LIBS%;..\database\saas-connection-db.jar
set JAVA_LIBS=%JAVA_LIBS%;..\database\derby.jar
set JAVA_LIBS=%JAVA_LIBS%;..\bin\rdtm\javalib\adapter-common.jar
set JAVA_LIBS=%JAVA_LIBS%;..\bin\rdtm\javalib\adapter-interface.jar
set JAVA_LIBS=%JAVA_LIBS%;..\bin\rdtm\javalib\adapter-interface-pvt.jar
set JAVA_LIBS=%JAVA_LIBS%;..\bin\rdtm\javalib\webservices-rt.jar

%JAVA_HOME%\bin\java %JRE_OPTS% %INFA_DEBUG% %INFA_MEMORY% %INFA_SSL% -DfileIO.maxFileSize=10485760 -Ddtm.path=..\bin\rdtm -Dsun.reflect.inflationThreshold=0 -cp %JAVA_LIBS% com.informatica.saas.tomcat.AppLoader ..\infaagent.ini tomcat.cfg

 

 

 

 

Permalink.

Secure Agent errors with: Failed to load the JVM library: ..\..\..\jre\bin\server\jvm.dll

When you run a task that includes an Informatica Cloud Connector with a Secure Agent on Windows

2003 or Windows XP (32-bit), the task can fail with the following error:

 Failed to load the JVM library: <..\..\..\jre\bin\server\jvm.dll

Workaround: Install the Visual Studio 2010 redistributable on the Secure Agent machine. You can

download the redistributable from the following location:

http://download.microsoft.com/download/5/B/C/5BC5DBB3-652D-4DCE-B14A-

475AB85EEF6E/vcredist_x86.exe

 

See also https://community.informatica.com/servlet/JiveServlet/download/3691-3-33447/ICloud_ReleaseNotes_Winter2014.pdf

Permalink.

General (1)

Why this FAQ?

informatica faq

Why did you create this FAQ?  Well, easy, because I’ve found little information on certain issues to be found on the Internet, even on the official site(s).

 

[important]Come back soon for updates :)[/important]

Permalink.

Informatica jobs (5)

Job error: Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent.

Job error: Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent.

Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent.

 

The job errors with this message because on the server, where this Secure Agent is running doesn’t  have the necessary C++ runtime installed.  Pls. check: http://www.microsoft.com/download/en/details.aspx?id=29

Also, ensure:  it is the x86 redistributable because the Secure Agent is a x86 (32bit) application and needs the compatible VC++ components.

 

 

See also: https://community.informatica.com/thread/34562

 

Permalink.

Job error:TE_7002 Transformation stopped due to a fatal error in the mapping. The expression [XXXXX] contains the following errors [<> [XXXXX]: invalid symbol reference … >>>>ID<<<<].

Job error:TE_7002 Transformation stopped due to a fatal error in the mapping. The expression [XXXXX] contains the following errors [<<PM Parse Error>> [XXXXX]: invalid symbol reference … >>>>XXXXX<<<<].

 

This error happens where you have an existing update/insert job where either the source or the target destination has changed (i.e. columns/fields have been added/changed/removed).  The XXXXX value represents one of the source and targetfields.

 

Before rerunning the job, open it, go to tab 5. (field-mapping) and click the refresh button.. This refreshes the loading of the source and target definition. Then restart the job

 

 

Permalink.

[DTM_10004] The DTM process terminated unexpectedly.

[DTM_10004] The DTM process terminated unexpectedly.

While this error could have many different causes I noticed it is usually related to security. ie tomcat cannot be started in the background. First check if the secure agent service is actually being started under the LOCAL SYSTEM account!

https://community.informatica.com/docs/DOC-1761

 

 

Permalink.

Using custom source only the first column values are being transferred

This happens if you use a custom source and have there supplied a ‘select * from’  statement.  This is I find one of the weirdest things in Informatica. It allows you to input this in the job, it is correctly validated and even the example “all columns preview” actually shows the values of all columns but when you run the job (without an error!) only the first column is filled.

Solution is to actually specify all the column values in the select.

 

Permalink.

Wrongly translated(Missing!) characters from Source DB towards SF

KB-151727Although you ensured you’ve set the Secure Agent connection to set to the correct code page, for example Eastern European characters set, some characters are simply missing in names in Salesforce.

 

Solution is to set all related columns, in the job to NVARCHAR

Pim_ 2014-12-22 11.04.58

Permalink.

Informatica updates (1)

Oracle tips regarding data integration (1)

Wrongly translated(Missing!) characters from Source DB towards SF

KB-151727Although you ensured you’ve set the Secure Agent connection to set to the correct code page, for example Eastern European characters set, some characters are simply missing in names in Salesforce.

 

Solution is to set all related columns, in the job to NVARCHAR

Pim_ 2014-12-22 11.04.58

Permalink.

Secure Agent (5)

The Secure Agent encountered connection error

Error: The Secure Agent is starting up and then stops

The Secure Agent encoutered connection error

 

If you come accross these errors it usually means a permission problem on that local machine. It is probably Tomcat related. The best starting point is to check the logging locally, probably in C:\Program Files (x86)\Informatica Cloud Secure Agent\mainX\tomcat  (where X is probably a number, depening on upgrades of the secure agent).   It usually means, the service starts, but encounters permission errors when starting Tomcat. Better to use local domain administrator to install and run the server, when it’s working, fix it from there by restricting the user. (the folder permissions are important!)

 

 

Permalink.

[DTM_10004] The DTM process terminated unexpectedly.

[DTM_10004] The DTM process terminated unexpectedly.

While this error could have many different causes I noticed it is usually related to security. ie tomcat cannot be started in the background. First check if the secure agent service is actually being started under the LOCAL SYSTEM account!

https://community.informatica.com/docs/DOC-1761

 

 

Permalink.

Secure Agent connection (ODBC) works but doesnt update DB/2 400 AS/400 rows

 

This is a problem by design. The Secure Agent requires DB/2  9.5 or higher. Source: Informatica

Update 3/3/2014. If it still not works the workaround might be:

1. Create a ‘real’ SQL file (use DDL opposed to DDS) You can use Client Access Navigator GUI for this is well.

2. Use cpyf to copy contents from original file to the DDL file (use MBROPT(*ADD))

3. Use this newly created DDL file (SQL script created file) as target for the integration job.

Permalink.

Secure Agent errors with: Failed to load the JVM library: ..\..\..\jre\bin\server\jvm.dll

When you run a task that includes an Informatica Cloud Connector with a Secure Agent on Windows

2003 or Windows XP (32-bit), the task can fail with the following error:

 Failed to load the JVM library: <..\..\..\jre\bin\server\jvm.dll

Workaround: Install the Visual Studio 2010 redistributable on the Secure Agent machine. You can

download the redistributable from the following location:

http://download.microsoft.com/download/5/B/C/5BC5DBB3-652D-4DCE-B14A-

475AB85EEF6E/vcredist_x86.exe

 

See also https://community.informatica.com/servlet/JiveServlet/download/3691-3-33447/ICloud_ReleaseNotes_Winter2014.pdf

Permalink.

Wrongly translated(Missing!) characters from Source DB towards SF

KB-151727Although you ensured you’ve set the Secure Agent connection to set to the correct code page, for example Eastern European characters set, some characters are simply missing in names in Salesforce.

 

Solution is to set all related columns, in the job to NVARCHAR

Pim_ 2014-12-22 11.04.58

Permalink.

 

[important]

This site and it’s content is copyright © 2013 by P.I.M. Uijttewaal.
http://pimuijttewaal.nl

Warranties and Disclaimers:

The views expressed are that of the author alone and do not constitute any opinions of that of either Salesforce or Informatica.

Trademark Information
Informatica and Informatica Cloud are the registered trademarks of Informatica Corporation.

Salesforce is the registered trademark of Salesforce Corporation.
I am NOT connected to Salesforce nor to Informatica.

ALL WEBSITE INFORMATION IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, AND INFORMATICA SPECIFICALLY DISCLAIMS ALL WARRANTIES, CONDITIONS OR OTHER TERMS, EXPRESS OR IMPLIED (IN FACT OR IN LAW), INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTIES, CONDITIONS OR OTHER TERMS OF MERCHANTABILITY, SATISFACTORY QUALITY OR FITNESS FOR A PARTICULAR PURPOSE. ADDITIONALLY, IN NO EVENT WILL P.I.M. UIJTTEWAAL BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE, DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION IN CONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THIS WEBSITE OR ANY OTHER HYPERLINKED WEB SITE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. THESE LIMITATIONS WILL APPLY NOTWITHSTANDING THE FAILURE OF THE ESSENTIAL PURPOSE OF ANY REMEDY. I RESERVE THE RIGHT TO MAKE CHANGES OR UPDATES TO THIS WEBSITE OR THE PRODUCTS OR PROGRAMS DESCRIBED IN THIS WEBSITE AT ANY TIME WITHOUT NOTICE

[/important]