Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "FR_3085 ERROR: Row [18]: 58-th character is a null character, which is not allowed in a text input file D:\FlatFile\Test.csv" when reading data from a FlatFile in Data Synchronization Task in Informatica Cloud
Problem Description
In Informatica Cloud, when reading data from a FlatFile in Data Synchronization Task, the task fails with the following error: 
[DTM_10004] The DTM process terminated unexpectedly.  
In this case, the following error details are captured in the session log of the task:
FR_3085 ERROR: Row [18]: 58-th character is a null character, which is not allowed in a text input file D:\FlatFile\Test.csv"
Cause
​This issue occurs when the source file contains a NULL character. Such characters can be observed by opening the Flatfile in a text editor like Notepad++.
Solution

To resolve this issue, set the following custom flag at the secure agent level:

FileRdrTreatNullCharAs = \040 

To enable the flag using the Informatica Cloud UI, perform the following steps:

1. Login to Informatica Cloud.
2. Navigate to Administrator console
3. Edit the corresponding agent and add the custom property as follows:
   file_reader_null.png
 4. Then click on Ok and save the changes made
 5. A new version of Data integration server would come up picking up the chagnes made. Once the new version is up and running , try re running the task.
More Information
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Developer
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:10/9/2019 9:11 PMID:156743
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)