You have a need to delete a Metalogix StoragePoint profile that was setup for a site that was long ago removed, and your just doing some clean up.  After you’ve click into the profile you want to delete and delete it, StoragePoint goes through the recall job and you move on to the next item in your daily tasks because you’re a busy Admin. 

Days later you stop by and adjust the setting for one of your profiles and gosh, there it is, the profile you thought you deleted.  Being a smart person you figure its not been removed and you try it again.  This time you watch as the profile says ‘deleting’….

You even watch the StoragePoint Jobs conduct the bulk recall action.

But it doesn’t delete, as a matter of fact it switches back to the original where its Active.  How frustrating is that!  Quite I say.. But there is a way out of the darkness.  After doing much research on the meager Metalogix forms, and searching the web for any documentation I learned that during the proceessing of this job a lock I created an that its not cleared preventing a table from being updated. 

The FIX is simple a simple query on the StoragePoint Database that is in SQL. 

The query is

UPDATE dbo.Profiles SET State=0 WHERE [Name] = ‘profilename’ – in my case the profile name is ‘Hosting_Fish_staging’

Ahhh, happy SharePoint! err, StoragePoint