{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
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


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

Schneider Electric Singapore

Explore more
Product:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Product: