Repair fields that truncate during Transform

[Community Alums]

Issue

Field truncates to a default max length during transform resulting in lost characters. For example, the Name is incomplete. The cause is the column default max length setting on the Import Set table. This is the table created from the Transform Map to migrate the information into ServiceNow.

Role Required

Admin or some type of Transform Scheduler role.

Repair Process

This process excludes screen shots because I am prohibited from posting details from the instance.

1. Navigate to the table created for the import through System Import Sets > Import Set Tables.

Best Practice: Put part of the target import set table name into the navigation pane. This filters the list of import set tables down to a manageable number.

2. Select the table by name from the list in the Navigation Pane
3. The table opens in List View
4. Navigate to Configure>Table

Configure> Table is a sub-menu accessed by placing the cursor in the white area between the column names and right clicking.

5. Select ”Table” and the CI Definition view of the table opens

The max length edit must be applied on the current application table. If there is a message about the table at the top of the view – click as directed in the message to go to the actual source table. If there is no message, then you are on the source table.

Example Message

This record is in the Global application, but [import set table name] is in the current application. To edit this record click here.

6. From the CI Definition view of the source table > select “Application Access” tab. Verify that “Allow configuration” is checked.
7. Remain on the CI Definition view of the source table and select “Columns” tab.
8. Scroll down the columns list to the Column Label for the truncating field.
9. Left click on the Max Length entry to open the edit box.
10. Set the length as appropriate to the content.

Note that 255 is the max length which is not appropriate for most attributes.

11. Scroll back to the header and select the Back arrow. Selecting Back activates the automatic save.
12. Verify the edit by returning to the CI Definition view of the table. (From the Import Set table open the submenu Configure > Table). The edit should appear on the Global CI Definition view and on the source CI Definition view.

Issues and Causes

Issue	Cause
Unable to view list of Import Set Tables	This is probably a roles or access issue. The user who completed the transform should have the roles necessary for this repair.
Import Set Table does not appear on list	This may be a data entry error in that the name used in the search does not match the actual name. Navigate to System Import Sets> Admin >Transform Maps to locate the transform map and the source table name.
Max Width edit is not retained on the table after selecting “Back”.	(1) You are not on the true source table. Watch for the warning message detailed in step 4. (2) On the true source table under the Application Access tab the  “Allow Configuration” is not checked. See step 5.

[Scott Halverso1]

It is import to troubleshoot where the truncation is occuring.  It can occur not only in the temporary import set table, but also in the target table.

To avoid the import set table from ever being the source of the issue, this system property can be set to true where the system will automatically grow the column sizes for the import set table.

com.glide.loader.verify_target_field_size

 Details can be found here:https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0538123