Skip to main content
ExLibris Dev

Manually Delete All Rosetta Ingested Data


  • Product: Rosetta
  • Product Version: 4.0 and up
  • Relevant for Installation Type: Dedicated-Direct,Direct,Local,Total Care



Desired Outcome Goal: Manually delete all Rosetta ingested data 

Procedure: Follow procedure in attached file to achieve required goal

  1. Delete ALL IEs from permanent 
  • IEs that are locked for editing will not be deleted, so all locked IEs, in all institutions should be unlocked (and changes either committed or rolled back) before deleting all IEs in this section
  • Clean the Repository TA area (Home > Data Management > Manage Technical Issues) from all IEs, in each institution


  1. For each institution create a set of all data (e.g. SIP ID > 0) 
  2. Go to Data Management > Manage Processes and create a process 
  1. Select Delete IE 
  2. Tag Delete Permanently 
  3. Select the correct set that was just created
  4. Select Schedule once
  5. Submit 


  1. Follow-up to see all IEs were deleted from monitor process history
  2. Go to Data Management > Recycle Bin, run Delete All Permanently 
  3. Repeat in all institutions 

  1. Delete ALL SIPs from staging 


  1. In each institution, go to TA workbench (Home > Submissions > Manage Issues in SIP Processing). 

a. Decline all SIPS in Technical Issues (Please note, if you have SIPs in To-Permanent or Enrichment List, you would need Rosetta support help to decline those SIPs) 
b. Decline all SIPS in Approval > Assessor SIPs List 
c. Decline all SIPS in Approval > Arranger SIPs List 
d. Decline all SIPS in Approval > to Approver SIPs List 

2. Repeat in all institutions 


  1. Delete ALL SIPs from deposit 

1. For each producer agent, sign in to the Deposit module 
    a. For each producer, delete all SIPS (under decline and approved) 

2. Repeat in all institutions, for all producer agents 


  1. Run the following searches to identify any remaining IEs: 

Data Management > Search and Manage Queries > Search (any records located are likely still locked): 
Status not equal to ACTIVE 
Status not equal to SUPPRESSED 
Status not equal to NONE 

Possible reasons IEs remain undeleted: 

1. IEs cannot be deleted if it's checked out in the Web Editor
    It must first be checked in before it is eligible for deletion (with any changes either committed or rolled back) 

2. JDBC execution complaints during the delete process; likely related to storage


  1. Clean storage 

1. Go to Rosetta administration > Repository > Storage Rules and Definitions 
    Enter each storage group, copy all Storage root directories 

2. Enter in the server to each directory and validate it is empty (Please note, Rosetta folder names are numbers, please check before deleting any other types of directories!) 


  1. Database 

Some data will still be kept in the permanent index tables, which will not affect the system. If you want to clean these tables, please contact Rosetta support


Additional Information

NOTE: It's possible that after all steps above have been completed that additional queries may still identify undeleted IEs.
This is likely due to cached indexing.
The recommendation is to wait a few hours to see if the remaining IEs eventually disappear from the cache.


Delete ALL Rosetta Data.pdf



  • Article last edited: 18-Aug-2015
// feedback widged