Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Location names being truncated at 64 characters if data is imported via one-off upload

Location names being truncated at 64 characters if data is imported via one-off upload

Summary

Location names being truncated at 64 characters if data is imported via one-off upload

Symptoms

Help page in FlexNet Manager Suite Help > System Menu > Data Inputs > Business Data Tab > Enterprise Group Upload describes template of import data as the below.

ColumnSample ValuesNotes
NameGuangzhouThe name of the location, cost center, or corporate unit.Maximum 256 alphanumeric characters. Spaces and simple punctuation are also supported, but the foward slash character 9/) must not be used in a group name.
After import, visible in the Name column of the appropriate list, once the tree of corporate structure has been sufficiently expanded.
However, imported data being truncated at 64 characters. It is possible to create location names longer than 64 characters directly in the web UI.


Cause

This issue has been identified a bug #FNMS-48611.

Workaround

  1. Login to FNMSCompliance database via Microsoft SQL Server Management Studio.
  2. Backup dbo.GroupExImport and dbo.GroupExImport_MT stored procedures, right click on the stored procedure in the Object Explorer, and then select Script Stored Procedure as > CREATE to > File....
  3. Alter stored procedures, right click on the stored procedure in the Object Explorer, and then select Script Stored Procedure as > ALTER to > New Query Editor Window, then change the following line.
Before:
@GroupName nvarchar(64),
After:
@GroupName nvarchar(256),
  1. Execute both ALTER PROCEDURE scripts
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jan 31, 2019 11:10 PM
Updated by: