After uninstalling Arellia unable to edit assets

Products

• IT Management Suite

Issue/Introduction

After upgrading to 7.5 and successfully uninstalling Arellia, the computer asset edit window will open to display the following error : "An error occurs when loading the page, please check log for detail"

 Error in the Altiris Log Viewer:

Exception encountered: Altiris.NS.Exceptions.AeXException: Failed to perform bind for ResourceAssociationTypeEdit control for GUID = '4aafad02-4ef3-48ef-82e6-6822a82f8da5'. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Altiris.AssetContractCommon.Controls.MetaAssociationControl.DataBindTable(DataTable tableToBind) at Altiris.AssetContractCommon.Controls.MetaAssociationControl.DataBind() at Altiris.AssetContractCommon.Controls.ResourceDetailsEditCtrl.BindControls(IDictionary controlDictionary) --- End of inner exception stack trace --- at Altiris.AssetContractCommon.Controls.ResourceDetailsEditCtrl.BindControls(IDictionary controlDictionary) at Altiris.AssetContractCommon.Controls.ResourceDetailsEditCtrl.DataBind() at Altiris.AssetContractCommon.Web.Manager.EditCreateResource.Page_Load(Object sender, EventArgs e)

Environment

ITMS 7.x, 8.x

Cause

Remnants of Arellia associations are still in the database and were not removed by the uninstaller

Resolution

Open the SQL Management Studio

Run the following query against the CMDB:

insert into ItemToDelete(Guid)

select rat.Guid

from ResourceAssociationType rat 

join Item i on rat.Guid = i.Guid where ProductGuid in (

'7656E95B-C4E9-473C-9A69-BB7270F1F9B0',

'D050842D-51C4-4B3F-BD07-DD7AED205AE0',

'A7D32F79-5AC0-4A9C-A980-046752703AC6',

'783A2A86-B1A2-4FAE-9C92-96175D743DEC',

'27BEDB8A-DB37-4D53-B748-BC6651461FE4',

'399CD56F-E683-430E-A39C-DD59C7693313',

'B409B2EA-D875-4888-9083-EF3C6A26EA52',

'2331A7ED-6915-4F82-AABD-7B38B544FB26',

'75AFC25F-C518-491C-A60D-ECD6B7DBC7AD',

'EF1FD5E6-3DEC-4338-AD79-F84B7CDF8834',

'740BA61D-66FE-405D-B3B8-EDF33B1215D1',

'617973BF-EBEB-435B-A40B-A1C5D8453393',

'C59AF73E-C943-4730-9C05-9523C0AD4B1A',

'12D56812-E935-47C6-96E4-9006D38E9D3F',

'C32EE7E9-7239-44D1-BB01-59DAA69BD17C',

'71BA19E1-08D9-4F53-B185-35BEF385805E')

Open the Windows Task Scheduler on the Symantec Management Platform server and run the task 'NS. Quarter-Hour task '

 

Open a new CMD window with administrator rights and run iisreset