When using web service import sets, the table cleaner shortens columns from mediumtext to varchar(40) without adjusting the dictionary max size, regardless of the actual data. The property com.glide.loader.verify_target_field_size is ignored when using web service import sets.

Steps to Reproduce


  1. Create a web services import set to import into the incident table. Use the wizard to create all fields. Leave all fields at the default length of 40.
  2. On the system properties table, add the property com.glide.loader.verify_target_field_size with a type of true|false and a value of true.
  3. Using the SOAP UI or another SOAP web service test tool, insert data into the staging table. For the comments and the short description, enter data that is longer than 40 characters.
  4. Check the inserted content in the staging table. Note tthat he long values are truncated to 40 characters.


Manually increase the column length on the import staging table.

Related Problem: PRB639271

Seen In

Eureka Patch 10
Eureka Patch 7
Geneva Patch 7
Helsinki Patch 1

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-09-15 09:54:28