EV9SP2 - 13360 - DeleteArchiveFolders issue

[GertjanA]

Hello all,

I am having the same issue as described here: (EV9SP2)

https://www-secure.symantec.com/connect/forums/ev-901-events-8453-13360

The error is event 13360:

An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1442}], built Mar 14 10:54:54 2011):

Description:

The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_ArchiveFolder_ArchiveFolder". The conflict occurred in database "EnterpriseVaultDirectory", table "dbo.ArchiveFolder", column 'ParentFolderRootIdentity'.

SQL Command:

DeleteArchiveFolders

When I run the query as listed in the mentioned forum entry, I get 2 rows returned:

use enterprisevaultdirectory
select * from  archivefolder
where deleted='0' and rootidentity in(
select rootidentity from dbo.archivefolder where ParentFolderRootIdentity  In (Select RootIdentity
From ArchiveFolderViewWithDeletedFolders
Where Deleted = '1'))

rows returned
1117795 Sent Items �Sent Items 1029879 9 NULL NULL 0
1117794 Inbox � Inbox  1029879 1 NULL NULL 0

Can I fix this in anyway? Can I figure out from which archive these folders are?

[RahulG]

I had seen similar issue long back where in one of  folder in a users archived was marked for deletion in ArchiveFolderView WithDeletedFolders but was parentroot folder for anther folder in table archive folder, unmarkerd that folder for deletion which resolved the issue

[TonySterling]

This should tell you:

Edited to remove wrong query, see below:

[GertjanA]

The query Tony advised returns no rows..

This means (imho) that the archive no longer exists right?

does this mean I can remove those two rows from the table archivefolder? Or is that too simplistic.

[TonySterling]

Can you run this query first?

Select * from ArchiveFolder where RootIdentity = 1029879

what does that return?

[GertjanA]

Hi Tony,

This returns 1 row:

1029879 Top of Information Store   NULL 0 NULL NULL 1

[TonySterling]

Ok, I skipped a step earlier.  :)

Run this Select * from archive where RootIdentity IN (Select ContainerRootIdentity from root where RootIdentity = 1029879)

[GertjanA]

That returns:

1029878 121B7DB6E30F6724A8DD4760A03E0B4501210000EV001 

(removed C3611323) Gonzales Zamora, M. (Maria Felisa) Default for Gonzales Zamora, M. (Maria Felisa) NULL 1 0 2 0 0 0 1 0 1 0 1 NULL 0 0 0 0 0

That archive does exist

[TonySterling]

That is your archive the folders above are from.

[GertjanA]

I opened that archive (by granting myself access).

There are NO subfolders in there. There are 139 items shown when I click on the archive name.

As the subfolders are gone, should I delete that archive? Export it to PST, then delete?

[RahulG]

Was the archive in questions deleted before ? As there are no sub-folder in the archive it might be that some had tried deleting the archive but the deletion did not complete properly.

[GertjanA · Accepted solution]

Hello Rahul,

That might be, but that is not traceable anymore.

I'm leaning to exporting the archive to PST, then try to remove it in the VAC