After upgrading from v8 to v10, UC_* VARA objects are moved to <No Folder>

Document ID : KB000088606
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Symptoms
After upgrading from v8 to v10 UC_* VARA objects are moved to <No Folder> and it is not possible to move or delete them and error message is not displayed. Date of last modification of these variables is generally old (for example 31.1.2001). 
 

Cause
After upgrading from v8 to v10 some old VARA Objects (UC_* variables) are somehow moved to <No Folder>. 
.png

 

 
Resolution:

When upgraded to newer version, like in this case from v8 to v10, it can happen that old VARA Objects (UC_* variables) that are no longer needed by the system, are moved to <No Folder>.  These objects cannot do any harm to System if the user leaves them in <No Folder>. But if user wants to delete them, it cannot be done in the GUI. Deletion of variables is performed with following SQL Statements:
delete from ovw where ovw_oh_idnr in (4,9,20,21,22,23,25,26,30,83)
delete from ovd where ovd_oh_idnr in (4,9,20,21,22,23,25,26,30,83)
delete from odoc where odoc_oh_idnr in (4,9,20,21,22,23,25,26,30,83)
delete from ofs where ofs_oh_idnr_o in (4,9,20,21,22,23,25,26,30,83)
delete from ox where ox_oh_idnr in (4,9,20,21,22,23,25,26,30,83)
delete from ofs where ofs_oh_idnr_o in (4,9,20,21,22,23,25,26,30,83)
delete from oh where oh_idnr in (4,9,20,21,22,23,25,26,30,83)
After executing SQL statements it can happen that there are two VARA objects that are not deleted:
1. UC_HOST_HW
2. UC_EX_MIB_INFO
Deletion of these variables can be performed with following SQL statements:
delete from ovw where ovw_oh_idnr in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
delete from ovd where ovd_oh_idnr in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
delete from odoc where odoc_oh_idnr in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
delete from ofs where ofs_oh_idnr_o in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
delete from ox where ox_oh_idnr in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
delete from ofs where ofs_oh_idnr_o in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)
 
delete from oh where oh_idnr in (select oh_idnr from oh where oh_name in ('UC_HOST_HW','UC_EX_MIB_INFO') and oh_client=0 and oh_deleteflag=0)