Technical FAQs

Ask a Question

How to correct the spelling of the Measurement StandardName in EEM through SQL Database Edits

Issue
User has a spelling mistake in a measurement name and wants to correct the name beyond just updating the display name.

Product
ION EEM 3.95 Sp1, 4.0, 4.0R2, 5.0

Environment
SQL Server Management Studio (SSMS)

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

1) Open SSMS and connect to the EEM database
2) Expand Databases --> ION_EEMData -->Tables
3) Right click on dbo.TS_Resources and select "Edit top 200 rows"
4) Click the "Show SQL Pane" Icon and add the filter "Where Name like '[name of incorrect measurement]' " (without double quotes)
5) Click execute
6) Modify the name to the correct spelling
7) Click on a new line to commit the changes
8) Repeat steps 3 through 7 on tables dbo.RPT_Measurement and dbo.MM_MeasurementMap updating DisplayName, FullName and StandardName
Was this helpful?
What can we do to improve the information ?