Ex: If we want to add below mentioned variable under the stack device
1.flow_emission
2.temperature_emission
Solution:
1.Stop Tomcat
2.Open MySQL
3.Take Database backup.
While doing any work on database first take backup of table.
parametermaster>>backup/export>>Backup Table As SQL Dump
first check in database
>>devicemaster table >>Table Data >> All rows
find "stack" in "DeviceName" & "DeviceTypeId" of stack (CEMS)
Second open "parametermaster" table
>> parametermaster >> Table Data >> All rows
Add ParameterCode>>ParameterName>>ParameterShortName>>DeviceTypeId
Save and refresh.
4. Delete work folder and rename log folder, in below mentioned path.
C:\Program Files\Apache Software Foundation\Tomcat 7.0
5.Start Tomcat.
Production server takes 5 to 8 mins to start server.
Note:
If in the case Tomcat goes under stopping mode, then kill the Tomcat service by CMD.
1.Open cmd as Run as administrator.
2.check pid number Tomcat service in Task manager>>services (if pid=3580)
3.put below mentioned command:
taskkill /pid 3580 /f
(3580 is a pid number Tomcat service.)