If a collection is deleted using Insight Studio but the references to the deleted collection still exists in Luna, your Luna site can start to hang or become unresponsive when it can't find those deleted collections. In the worse case, it could cause your Luna site to take minutes to load or becomes unresponsive when attempting to log on.
There is a new version of the Insight AdminTools, version 6.2, that has the option to delete a collection from Luna. If you connect to your Luna manager and right-click on an entry in the Media Collections container, you'll see the delete option.
If you can't install Insight Admin Tools 6.2 or need to know how to delete the collection from Luna without using Admin Tools 6.2, run the following sql against your Luna database (not the Luna publisher database) after a collection has been deleted using Insight Studio. The following is just an example sql, see notes below.
-- only run the sql if you can't install Insight Admin Tools 6.2
DELETE FROM MEDIACOLLECTIONS WHERE (ID = 'LUNACCM~1~1');
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE (COLLECTIONID ='LUNACCM~1~1');
DELETE FROM MEDIAFIELDS WHERE (INSTITUTIONID ='LUNACCM') AND (COLLECTIONID = 1) AND (UNIQUECOLLECTIONID=1);
-- Enter the appopriate LUNA collection ID information in the form LUNACCM~1~1 for the first two queries
-- Enter each portion of the original collectionID in the third MEDIAFIELDS delete query
-- This info can be obtained from Admin Tools-> Luna Manager-> Media Collections
Restart the Luna service.
