Incomplete data migration for some of the String Fields because of Max length issue.

[ChuanYanF]

Dear experts,

I would like to know how to enable the system property for when importing data sets, it will allow the fields to import all the data values rather than a fix 40 length or I dont have to manually go to my source table and change the length for each fields. I already defined the length in my target table can it just follow the same as the target table?

[J Siva · Accepted solution]

Hi @ChuanYanF 
You need to increase the staging table field length. Please find below the link to the ServiceNow product documentation, which explains how to set or add a new system property to increase the column (field) length of the import set staging table.
As per the doc, you need to create/update the sytem propety "com.glide.loader.verify_target_field_size" with the value "True"

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/r...

Regards,
Siva

[J Siva · Accepted solution]

Hi @ChuanYanF 
You need to increase the staging table field length. Please find below the link to the ServiceNow product documentation, which explains how to set or add a new system property to increase the column (field) length of the import set staging table.
As per the doc, you need to create/update the sytem propety "com.glide.loader.verify_target_field_size" with the value "True"

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/r...

Regards,
Siva

[Ankur Bawiskar]

@ChuanYanF 

the staging field length is taken as max of any value which comes when you import.

You can set the property mentioned by @J Siva as true if it's set to false.

If that property is not there then create it with true value

If my response helped please mark it correct and close the thread so that it benefits future readers.

[ChuanYanF]

Where can i check that if I or I have not this property in my system? Do I go to System Properties > System?

[J Siva · Accepted solution]

@ChuanYanF Type sys_properties.LIST in the filter navigator and enter.

Prod doc:
https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/reference-pa...