Issue
When naming User Groups with the Danish alphabet, the letters are not displayed through Web Application.
Instead of a letter, it will be displayed a code, for instance: å
_____________________________________________________________
Product Line
Power Monitoring Expert 2021
_____________________________________________________________
Environment
Web Application - User Manager - User Groups
_____________________________________________________________
Root Cause (Optional)
This is inserted into the database due to a localization issue in the code.
_____________________________________________________________
Solution
The current solution for this is to manually edit the table where this information is stored.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
1) In SSMS, run the following query to identify the ID of the User Group that needs to be modified
SELECT * FROM [ApplicationModules].[Security].[Teams]
2) Then run the query below to update the User Group with the correct letter, as for example:
UPDATE [ApplicationModules].[Security].[Teams]
SET Name = 'åtest'
WHERE Id = '<Enter the ID found in Step 1 here>' (keep the single quotes only)
3) Refresh Web Application to reflect the changes. Clear the browser cache may help if the changes do not take effect immediately.
發佈於: 施耐德電機Taiwan
