Truncated not imported properly

[Shaik Noorulla]

When ServiceNow creates a new import set table, it measures the length of the first 20 records to determine the length of fields. If the data values to be imported exceed the length of the fields in the import set tables, they will be truncated and not imported properly.

What are the steps I need to prevent truncating?

Thanks,

Noorulla

[Harish Kota · Accepted solution]

Hi @Shaik Noorulla 

To prevent truncating you can set the system property com.glide.loader.verify_target_field_size to "true"


com.glide.loader.verify_target_field_size

Enables dynamic resizing of import set fields. With the default setting of false, up to 20 records of the source data are sampled to determine the import set field length. If the field is empty in all the sampled records, the default length of 40 is used. Any data loaded that exceeds the import set table field length is truncated. Set this property to true to allow any import set field to increase the column size by 100 to match the length of the data. For example, if the incoming source data has a length of 60, the system sets the length of the column to 160. This is relevant to data source only.

• Type: true | false
• Default value: false
  
  Please check and accept as solution, if it works for you.
  
  Thanks,
  Harish Kota

[Shaik Noorulla]

Thank you Harish, after updating the property to true, the solution worked. And thanks for the detailed information.