Removing inaccessible LUNA Commons collections

Introduction

As we advance the LUNA 7 software forward, Collection Sharing is a feature that’s on our list for a future release. To replace the current method for distributing collections, that’s now tied to the LUNA Commons, we’re developing a process that will allow you to easily share your collections with one or more institutions or individuals in LUNA. The simplified process will no longer require our involvement and will be available as a new feature in the LUNA Administrator tool.

In the meantime, more clients are upgrading to LUNA 7 and you may be noticing that some collections in the LUNA Commons are no longer working. If you are one of the institutions making the LUNA Commons collections available in your own instance of the LUNA Viewer, you’ll need to follow the steps below to remove the collections that are no longer working.

Steps to remove inaccessible collections

Backup your LUNA database.
Run the delete queries.
Restart LUNA's Tomcat.

Special note to University of Cincinnati (univcincin) and Pomona college (Pomona%). DO NOT RUN the delete queries with your institutionID or collectionid contained in them.

The same queries can be used on both v6 and v7 LUNA databases.

DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%';


DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'univcincin%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'Pomona%';


DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%';



DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%';


DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'univcincin%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'Pomona%';


DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%';
 
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'univcincin%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'Pomona%';
 
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'CORNELL%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'univcincin%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'JCBBOOKS%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'CUL_KAR%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'BIRKBECKBCM%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'Pomona%';

DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'CORNELL%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'univcincin%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'JCBBOOKS%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'CUL_KAR%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'BIRKBECKBCM%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'Pomona%';