Issue with PST Locator

[Abhijit_Soman]

I am having EV 2007. I am trying to run PST locator Task and it is failing continiously. When I checked in Windows Event Log following event IDs are generating.

Event ID 8452

The EnterpriseVault.DirectoryConnection object reported an error.

The error code was 0x80040e14



Event ID 8453

The EnterpriseVault.DirectoryService object reported an error.

The error code was 0x80040e14


Event ID 13345

An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::AddRecord) [lines {392,393}] built Jan 2 11:39:44 2008), error code <0x80040e14>.

SQL Command:
INSERT INTO PstComputer (PstComputerEntryId,ComputerName,DomainName,ExchangeMailboxEntryId,LastHardDiskScan,LastRegistryScan,LastNetworkFailure,SearchThisComputer,HardDiskSearchInProgress,RegistrySearchInProgress,HardDiskFailureText,RegistryFailureText,ComputerType) VALUES (N'14E05A48BD3C8664AB09FAFA86A0850C91011700EVSITE',N'LLKL2S01',N'BALICIN',Null,Null,Null,Null,0,0,0,Null,Null,0)


Event ID 13360

An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1379,1381,1396,1428}] built Jan 2 11:39:44 2008):

Description:

[Microsoft][ODBC SQL Server Driver][SQL Server]Duplicate key was ignored.


SQL Command:
INSERT INTO PstComputer (PstComputerEntryId,ComputerName,DomainName,ExchangeMailboxEntryId,LastHardDiskScan,LastRegistryScan,LastNetworkFailure,SearchThisComputer,HardDiskSearchInProgress,RegistrySearchInProgress,HardDiskFailureText,RegistryFailureText,ComputerType) VALUES (N'14E05A48BD3C8664AB09FAFA86A0850C91011700EVSITE',N'LLKL2S01',N'BALICIN',Null,Null,Null,Null,0,0,0,Null,Null,0)



For the above errors I have already referred following article but no use

http://seer.entsupport.symantec.com/docs/290597.htm


Please help me to resolve this issue.

[MichelZ]

Hi

Just follow the Procedure in the Article mentioned....

Cheers
Michel

[Abhijit_Soman]

I have already did that.... but didn't worked

[AndrewB]

Is there any update on this issue?

[MichelZ]

Hi

Delete all PST's you seen in PST Files section of Personal Store Management
Then delete all Computers you see in the PST Computer section of Personal Store Management.

Then try again.

[Paul_Grimshaw]

From the error it is saying to me that the computer is already in the PSTComputer table and it is trying to add it again but it is not allowed as there is a primary key on the PstComputerEntryId. So if you run the command:-

select * from pstcomputer where PstComputerEntryId = '14E05A48BD3C8664AB09FAFA86A0850C91011700EVSITE'

If you get a row back then that is the issue and if you ran the command previously successfully then I do not really see how this can happen as that command will clear out all of the entries in that table. You cannot do this though if there are PST Files against that compter so you really need to run:-

delete from PSTFile where PstComputerEntryID = '14E05A48BD3C8664AB09FAFA86A0850C91011700EVSITE' 

then
delete from PSTComputer where PstComputerEntryID = '14E05A48BD3C8664AB09FAFA86A0850C91011700EVSITE' 

Run your locator task.