This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Knowledge Base
- :
- Location names being truncated at 64 characters if data is imported via one-off upload
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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 uploadSymptoms
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.
|
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
No ratings