PME 2021 - Danish alphabet is not displayed in Web app when used in User Group name

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.

發佈於: 施耐德電機Taiwan