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.
Column | Sample Values | Notes |
---|
Name | Guangzhou | The 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
- Login to FNMSCompliance database via Microsoft SQL Server Management Studio.
- 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....
- 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),
- Execute both ALTER PROCEDURE scripts