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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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

<Please see attached file for image>

 

---

 

Environment

Release: AUTWAB99000-10.0-Automic Workload Automation-Base Edition
Component:

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)