Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Issue with PST Locator

Updated: 21 May 2010 | 5 comments
Abhijit Soman's picture
0 0 Votes
Login to vote

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.

Comments

MichelZ's picture
10
Jul
2009
0 Votes 0
Login to vote

Hi Just follow the Procedure

Hi

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

Cheers
Michel

www.quadrotech-it.com - All your EV Tools | www.techfreak.ch

Abhijit Soman's picture
10
Jul
2009
0 Votes 0
Login to vote

I have already did that....

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

Please check and confirm. If this remedy worked for you Kindly mark it as a SOLUTION

Regards, Abhijit
AndrewB's picture
17
Sep
2009
0 Votes 0
Login to vote

Is there any update on this

Is there any update on this issue?

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec Platinum Partner | www.trace3.com

MichelZ's picture
17
Sep
2009
0 Votes 0
Login to vote

Hi Delete all PST's you seen

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.

www.quadrotech-it.com - All your EV Tools | www.techfreak.ch

Paul Grimshaw's picture
17
Sep
2009
0 Votes 0
Login to vote

From the error it is saying

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.

EV Backline Technical Support Engineer APJ Region