Error Rows Files
Informatica Cloud generates error rows files for Data Synchronization tasks. An error rows file shows rows that failed and the reason why each row failed.
For example, the following error appears in the error rows file when the task tries to insert two records with the same external ID into a Salesforce target:
Error loading into target [HouseholdProduct__c] : Error received from salesforce.com. Fields [ExternalId__c]. Status code [DUPLICATE_VALUE]. Message [Duplicate external id specified: 1.0].
The error rows file includes the first 50 fields of a source error row.
Previewing the Error Rows File
You can view the first 25 rows and first 50 columns of the error rows file through the Activity Log page and the Activity Log Details page.
1. Click Monitor > Activity Log.
2. In the Error Rows column, click the View Error Rows icon for to the job that you want view.
The icon displays only when an error rows file has been generated.
You can also preview the error rows file on the Activity Log Details page by clicking Preview Error Rows File.
Viewing the Error Rows File
You can view the entire error rows file for a job. Error row files are saved in the installation directory of the Secure Agent that runs the task. You can find error rows files in the following directory:
<SecureAgent_InstallDirectory>\main\rdtmDir\error
Use the start time of the job to identify the corresponding error rows file. The timestamp of the error rows file will be similar to the start time of the job.
If the error rows file contains Unicode data from the source, open the error rows file in an application that can display Unicode characters.