How to find the Clip-ID for a SaveSet and then Extract the item from Centera

[Liam_Finn1]

 We all know what a black hole the Centera device can be when it comes to trying to manually extract items.

Everything is stored in C-Clips and BLOBS

In most cases when you are trying to extract an item it is because you get an error, maybe something shows up in your Event log or in a DTrace stating that there was a problem retrieving the item.

One way to validate if the issue is with one of the EV services or with the item it's self is to attempt a manual extraction of the item from the Centera.

 To extract a file direct from the Centera you need two items

The Item saveset ID and the Clip ID for that Saveset

Your Saveset ID you will get from your event log or from your DTrace

The Clip ID requires that you query SQL

The below Query will provide you with the Clip ID once you already have the Saveset IT
On the fourth line replace '<id transaction of saveset>' with the saveset ID ensuring you keep the single quotes (') at each end.

Once you have the Clip-ID you can proceed to extract the item from Centera


SELECT RelativeFileName
FROM Collection, Saveset
WHERE Collection.CollectionIdentity = Saveset.CollectionIdentity
AND Saveset.IdTransaction = '<id transaction of saveset>'
--Where <id transaction of saveset> is the formated version of the saveset. E.g. 853D0462-853E-4D79-9C38-E902F8A92A20
--IF successful, this query retruns the value for RelativeFileName (clipID)

OK Now that we have the Saveset we need to extract the item from Centera

How to Use EVCenteraChecker to Retrieve Saveset to a File

Tools needed to retrieve a Saveset to a file:
1) SQL Query above
2) Current version of EVCenteraChecker. This is a support tool available from Symantec.  Verify the tool is for the same version as EV.

Steps to follow to Retrieve a Saveset to a File:
1) Navigate to C:\Program Files\Enterprise Vault and execute EVCenteraChecker.exe
2) Choose the appropriate vault store from the Vault Store list
3) Choose the appropriate partition for the Centera Partition list
4) Choose option 7 – Retrieve Saveset to a File
5) Run the SQL above
6) If the query executes successfully it will return a value for the RElativeFileName (ClipID)
7) Copy this value and paste it into EVCenteraChecker when prompted for the Clip-ID
8) When Prompted for the SavesetID, enter the entire Saveset number. For example,
530000000000000~200804291600560000~0~853D0462853E4D799C38E902F8A92A2
9) When prompted for Saveset File Written to: enter the location where you wish to save the file and name it of type .dvs
10) to open the DVS file you need to use Outlook that has the client extentions for Enterprise Vault installed