Hi Bjørn,

If I understand you correctly, the item is in Deactivated status which means it is still owned by the company it was last installed.  It is not possible to remove the SA from the item as you cannot edit the item at this point.

Only thing I can think of is to activate the item again and it will then be an installed item once more and then from there, you can remove the SA on the item in the service info page.  Once the SA is removed, then you need to uninstall/remove the item again from the site with a service order normally.

Another possibility, though I don’t really advise it, is to disable the foreign key constraint via SQL for just the item_inst table, update the column and then reactivate the foreign key constraint.  Reason is this potentially can lead to data corruption as it would be removed for ALL installed items. I am only saying this in case you came up with this possible method elsewhere.

Thank you - I found out that somebody had actually Shipped this out instead of retiring it

Hi Bjørn,

Not that it will help in your particular case, there was improved functionality in 15.4 SU4 recently released:

However, you still probably have the item_person_xref table to deal with which is where the application is indicating the agent is assigned besides the pm_sa_person_id and of course if that agent’s activity is not fulfilled or cancelled, it still would not work.