Exported emails not deleted from archive

[TRP]

Hi all.

I thought I had an issue with orphaned shortcut deletion but it turns out not to be the case.

To help a user delete several thousand emails from his archive I told him to copy them to a specific folder which I then "exported" with the option ticked to remove the exported items.

The export (.pst) has worked fine but the emails have not been removed from the archive.

What could be causing this?

thanks

Tracy

[JesusWept3 · Accepted solution]

Can you try this query?
My best guess is its just in the dumpster and AE is caching the items

SELECT REPLACE(CAST(AF.FolderPath as varchar(max)), '?', '\') "Folder Path"
       COUNT(JD.SavesetID) "Items Awaiting Deletion"
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.ArchiveFolder AF,
       EnterpriseVaultDirectory.dbo.Root R1,
       EnterpriseVaultDirectory.dbo.Root R2,
       EVVSYourVaultStore_01.dbo.JournalDelete JD
WHERE  JD.ArchivePointID = R1.VaultEntryID
  AND  R1.RootIdentity = A.RootIdentity
  AND  JD.VaultId = R2.VaultEntryId
  AND  R2.RootIdentity = AF.RootIdentity
  AND  A.ArchiveName = 'My User'
  AND  JD.DeletionStatus < 2

[TRP]

where do I run the query?

[JesusWept3]

in SQL Management Studio 
just replace EVVSYourVaultStore_01 database name with the name of the Vault Store that holds the users archive

[EV_Ajay]

Hi,

Are you using the DIscovery Accelerator in your environment. ? Because if those items which you tried to export is on hold then DA will not allowed to delete those emails.

If you are using DA then need to remove the hold from case level and try to delete or reexport with option to remove item.

[A_J1]

Hi,

What do we have set under  Site Properties -> "Number of days until items are permanently deleted SET to: "