cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

FSAutility -t Bulk Recall issues

I am attempting to recall placeholders from one server to another using FSAutility –t –s \\myserver1\folder -d \\myserver2\folder.

I know there are over 900k placeholders on the source but it only recalls 300k.  As I’m not specifying and file types I would assume it would recall everything. 

There are only 1048 failures in the FSAutility log so it doesn’t match up.  Am I doing something wrong?

 

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

yobole,  We would need to see

yobole, 

We would need to see what the orphaned report shows.  When you moved them from D to F did you run the task on F after the move?  This should have updated the paths in the DB so that they were shown as being on F.  

 

You could also run the following query against the vault store DB to determine the number of items in each folder of that archive.  Would have to replace the SET @ArchivePointID value with the ArchiveID of from the Archive Properties Advanced tab.  You could then take the result and put into Excel to perform a sum on the items.

 

DECLARE @ArchivePointID Nvarchar(55)
SET @ArchivePointID = '1ACBC1EF4F328D7428E8664409FB5BC981110000EV8'

SELECT
    r1.VaultEntryId as ArchiveID,
    Archive.ArchiveName,     
    CAST(folderpath as varchar(200)) as folder_path,
    COUNT(*) NumberofitemsperFolder
FROM 
    EnterpriseVaultDirectory.dbo.Root r1
    JOIN EnterpriseVaultDirectory.dbo.Root r2 on r1.RootIdentity = r2.ContainerRootIdentity
    JOIN EnterpriseVaultDirectory.dbo.Archive on r1.rootidentity = Archive.rootidentity
    JOIN EnterpriseVaultDirectory.dbo.Archivefolder on r2.rootidentity = Archivefolder.rootidentity
    left  JOIN Vault on r2.Vaultentryid = Vaultid
    JOIN Saveset on Vault.Vaultidentity = Saveset.Vaultidentity
WHERE 
    r1.VaultEntryId = @ArchivePointID
GROUP BY 
    r1.VaultEntryId,
    Archive.Archivename,
    CAST(FolderPath as varchar(200))

View solution in original post

3 Replies
Highlighted

Hi yobole, Is it possible

Hi yobole, Is it possible that there are items that are orphaned on the source folder?  Would need to run FSAUtility -o against that source in report mode to determine any orphans?  

Or, if PH files were moved from another location to this one? They would not necessarily be in the DB in the location that they appear on the file system.  

Highlighted

Hi Plaudone, many thanks for

Hi Plaudone, many thanks for the reply.  We are now running an orphaned placeholder report and will await the results.  Your 2nd point is interesting as we did move all the placeholders last month from D: - F: using FSAUtility –PM and have since deleted D: as a target in EV.  Is there any way of getting all the files we need without running a bulk recall on the same server?

 

Many thanks,

Highlighted
Accepted Solution!

yobole,  We would need to see

yobole, 

We would need to see what the orphaned report shows.  When you moved them from D to F did you run the task on F after the move?  This should have updated the paths in the DB so that they were shown as being on F.  

 

You could also run the following query against the vault store DB to determine the number of items in each folder of that archive.  Would have to replace the SET @ArchivePointID value with the ArchiveID of from the Archive Properties Advanced tab.  You could then take the result and put into Excel to perform a sum on the items.

 

DECLARE @ArchivePointID Nvarchar(55)
SET @ArchivePointID = '1ACBC1EF4F328D7428E8664409FB5BC981110000EV8'

SELECT
    r1.VaultEntryId as ArchiveID,
    Archive.ArchiveName,     
    CAST(folderpath as varchar(200)) as folder_path,
    COUNT(*) NumberofitemsperFolder
FROM 
    EnterpriseVaultDirectory.dbo.Root r1
    JOIN EnterpriseVaultDirectory.dbo.Root r2 on r1.RootIdentity = r2.ContainerRootIdentity
    JOIN EnterpriseVaultDirectory.dbo.Archive on r1.rootidentity = Archive.rootidentity
    JOIN EnterpriseVaultDirectory.dbo.Archivefolder on r2.rootidentity = Archivefolder.rootidentity
    left  JOIN Vault on r2.Vaultentryid = Vaultid
    JOIN Saveset on Vault.Vaultidentity = Saveset.Vaultidentity
WHERE 
    r1.VaultEntryId = @ArchivePointID
GROUP BY 
    r1.VaultEntryId,
    Archive.Archivename,
    CAST(FolderPath as varchar(200))

View solution in original post