Technical FAQs

Ask a Question

ENM 8.3.2 - Unable to place tags in Maintenance mode: error saving tags

Issue
In the Event Notification Module (ENM) 8.3.2, when an attempt to place tags in maintenance mode, it prompts the user with the following error: Error Saving Tags: "The error description is 'An invalid character was found in text content.'



Product Line
StruxureWare Power Monitoring Expert

Environment
Event Notification Module 8.3.2

Cause
The issue occurs as a result of an invalid or non-English character in any of the tag/device names.

Resolution
*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.*  

The following workaround applies to ENM 8.3.2 only as future releases of ENM will incorporate this resolution.
 
Modify the following stored procedures in SQL Server Management Studio:
[PLES_APM].[dbo].[usp_xml_UpdateNodeSet]
[PLES_APM].[dbo].[usp_MM_xml_UpdateNodeSet]
 
1. In SQL Server Management Studio, connect to the 'ION' instance (default) or the instance used by PME/ENM.
2. Expand the 'PLES_APM' database, 'Programmability' folder and 'Stored Procedures'. 



3. Right-click in each of the scripts below and navigate to 'Select the script stored procedure as > ALTER To > New Query Editor Window'.
[PLES_APM].[dbo].[usp_xml_UpdateNodeSet]
[PLES_APM].[dbo].[usp_MM_xml_UpdateNodeSet]
 


4. Once the query window is open, modify the SQL script as follows:

-change the line from:
@Data text
 
-to:
@Data nvarchar(max)    
 
5. Execute the statement and repeat steps 3-5 to modify other stored procedures.
Was this helpful?
What can we do to improve the information ?