{}

Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
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

aa 
_____________________________________________________________ 
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 Nigeria

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:
move-arrow-top
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.