Browse FAQs

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

Published date: 12 November 2019

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 ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.