can you run this against your DA customer databases and see if it returns any results?

SELECT COUNT(*) FROM tblSearchResults

also look at the table in your vault store DB called "HoldSaveset"

This will show you all of the savesets on hold, and also the ArchivePointIdentity associated with each saveset.

The query executes successfully but produces 0 results.

If you do a select * from holdsaveset against the vault store database do you get results there? (That is the second question Andy was asking about.)

You might have to delete the entries from there.  It could be when the case was deleted the hold wasn't lifted.  I seem to remember an issue in the older versions that when that happened it didn't clean up holdsaveset correctly.

Tony - I executed the query and the results are zero.

AndrewB - here is the output from HoldSaveSet...although I'm not sure what to do with the info :)

HoldIdentity 9

SavesetIdentity 123385

HoldDataIdentity 2

HoldGroupIdentity 2

ArchivePointIdentity 1

This is the exact error from the Event Viewer Enterprise Vault log...

So how did you get results

HoldIdentity 9

SavesetIdentity 123385

HoldDataIdentity 2

HoldGroupIdentity 2

ArchivePointIdentity 1

if select * from holdsaveset had no results??

Tony - my error the results you're asking about came from the query to HoldSaveSets. Prior to that Andrew asked for the results from a query to SearchResults which came back 0.

I confused the two as I was typing my response.