Getting: Item attributes (NoDelete) do not include deletion

Products

• IT Management Suite

Issue/Introduction

Unable to delete an item after adding it directly to the ItemToDelete table. Using a similar query:

  insert into ItemToDelete 
  select  guid, GETDATE() 
  from item where guid = '777f5c01-add9-467e-91c4-b8ba0c671f94'  --<Item Guid To Delete>

The following error occurred:

Item attributes (NoDelete) do not include deletion for: 'DESK03_TEST' (777f5c01-add9-467e-91c4-b8ba0c671f94)

Error in the application.

   [Altiris.NS.Exceptions.ItemSecurityException @ ]

Exception logged from:

   at Altiris.NS.ItemManagement.Item.Delete()

   at Altiris.NS.ItemManagement.Item+<>c__DisplayClass395_0.<DeleteItem>b__0(Altiris.Database.IDatabaseContext)

   at Altiris.NS.ContextManagement.<>c__DisplayClass31_0<T>.<PerformWithDeadlockRetry>b__0(Altiris.Database.IDatabaseContext)

   ....

 -----------------------------------------------------------------------------------------------------

Date: 6/23/2020 3:38:37 PM, Tick Count: 1857999468 (21.12:06:39.4680000), Size: 6.63 KB

Process: AeXSvc (33944), Thread ID: 87, Module: Altiris.NS.dll

Priority: 1, Source: Item.Delete

 

Environment

ITMS 8.0 and later

Cause

The actual attribute for this item was set to "16", which means "NoDelete".

Resolution

1. Check what is the actual Item Attribute for this Item:
   
   select Guid, Name, Attributes from Item
where GUID = '<Item Guid To Delete>'
   
   
2. It is most likely that is set to '16'. You will need to update the Attribute to '0', which means "Normal" and it should let you delete the item:
   
   Update Item
set Attributes = 0
where Guid = '<Item Guid To Delete>'
   
   
3. Check if the item is still in the ItemToDelete table:
   
   select * ItemToDelete 
where guid = '<Item Guid To Delete>' 
   
   If not, add it back again:
   
     insert into ItemToDelete 
  select  guid, GETDATE() 
  from item where guid = '<Item Guid To Delete>' 
   
   
4. Run NS.Quarter Hour schedule (under Task Scheduler on your SMP server), the item will be removed from the database.