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: &#229


_____________________________________________________________
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.

Publié pour:Schneider Electric Belgium