Field truncated to 40 Charaters

Christophe
Tera Contributor

I imported data to a table using a transform map. The weird thing is that the data in 1 field is truncated to 40 characters.

I checked the transform table, and the field is set to a max of 4000 characters. The target table is also set to 4000 characters. 

I also tried to import my data directly to the table, but without success. Another weird thing is that the specific field on the target table says that there are 3960 characters left to type, but my text is truncated to 40 characters.

1 ACCEPTED SOLUTION

Its worth trying out tony.barratt approach, look at his comment in the below link https://community.servicenow.com/community?id=community_question&sys_id=5526cf61db1cdbc01dcaf3231f9619d8

View solution in original post

6 REPLIES 6

denis hoffmann
Kilo Guru

Hi Christophe,

To edit Max length for this field look into your 'Import set Table' who has been created with your first import.
You can find its "u_..." name in your Data Source.

go to "System Definition/Tables/..." 
filter on "Extends table=Import Set Row"
and look for your table in "Name"

also, what is the Type for this field ?

Regards,
Denis
edit : if you want to know why this field is set to 40 by default, look here : Import Sets properties

com.glide.loader.verify_target_field_size : 
 	
Enables dynamic resizing of import set fields. 
By default, 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.

Hello Dennis,

 

That I already checked. The Field Type is "String" and set to 6000, the same as the field in the Target Table.

ARG645
Tera Guru

Christophe,

This is most propably an issue with your import set table. To explain it bit by bit, when you import and transform the data, the data propogates from import set table to target table via transorm map.

In this process, at the time of importing the data from the datasource to the import set table, the default lenght of certain field types like String is 40.

So i suggest you to go to your importset and arrive at table configuration form. And change the max lenght to 4000 or whatever the desired value is. Hope this helps.

Hope this helps,

-Aman Gurram

Christophe
Tera Contributor

Hello Aman,

 

That is the weird thing I'm mentioning in my post. In the Transform Table as well as in the Target Table the field length is set to 4000. An Import doesn't work either, and this method loads directly to the Target Table.

 

Best regards,

 

Christophe