Unable to modify or delete unit in GMS when special character used in the Unit name
Description
These symptoms have been observed in GMS 8.0 and below version.
In version 8.1 and above this issue has been addressed with better error handling mechanism which does not allow usages of any special character in Unit Name.
Resolution
1. Verify special character exists in the database. In this example an apostrophe(') used in the word can't.
- Connect to the database, either MsSQL or MySQL
- Select sgmsdb
- Run the following command
mysql> select ID, NODE_NAME, firewallID from params;
+------------------------------------+------------------------------------------------+-------------------------+
| ID | NODE_NAME | firewallID |
+----------------------------------------------+--------------------------------------+-------------------------+
| UT147093225084C2B | Firewall_80_2 can't be modified | C0EAE400008C |
+------------------------------------+------------------------------------------------+-------------------------+
1 rows in set (0.00 sec)
<br/>
2. To change unit name for one single firewall use the following command:
<br/>
mysql> update params set NODE_NAME='Firewall_80_2 cannot be modified' where serial='C0EAE400008C';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
<br/>
3. To change the unit name for multiple units, we can use the following command to update all node names:
mysql> update params set node_name = REPLACE (node_name, 'can't', 'cannot') where node_name like '%can't%';
Query OK, 1 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
<br/>
4. Verify the update has been taken place:
mysql> select ID, NODE_NAME, firewallID from params;
+------------------------------------+------------------------------------------------+-------------------------+
| ID | NODE_NAME | firewallID |
+----------------------------------------------+--------------------------------------+-------------------------+
| UT147093225084C2B | Firewall_80_2 cannot be modified | C0EAE400008C |
+------------------------------------+------------------------------------------------+-------------------------+
1 rows in set (0.00 sec)
<br/>
Now we should be able to modify or delete units as required.
Related Articles
Categories
not finding your answers?
