SEPM dbvalidator failed
search cancel

SEPM dbvalidator failed

book

Article ID: 152648

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

The Symantec Endpoint Protection Manager (SEPM) utility, dbvalidator report shows links with install package are broken.

After running C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\dbvalidator.bat  the resulting report shows similar failures:

2010-08-03 14:24:44.040 INFO: logger initialized ...
2010-08-03 14:24:44.040 INFO: SEPM Server Home:[E:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
2010-08-03 14:24:48.055 INFO: Initialized the database.
2010-08-03 14:24:49.071 INFO: Starting to travel the schema ...
2010-08-03 14:24:55.710 INFO: ... finished travelling schema.
2010-08-03 14:24:55.726 INFO: Total ids found >> TargetIds [531] PhysicalFileIds :[106]
2010-08-03 14:24:55.726 INFO: SELECT ID FROM BASIC_METADATA WHERE ID IN (*unique table IDs*) AND DELETED=1
2010-08-03 14:24:56.226 INFO: SELECT ID FROM BASIC_METADATA WHERE ID IN (*unique table IDs*) AND DELETED=0
2010-08-03 14:24:56.460 INFO: *********************************************
2010-08-03 14:24:56.460 INFO: Following ids are not present in the database.
2010-08-03 14:24:56.460 INFO: *********************************************
2010-08-03 14:24:56.460 INFO: Link is broken for [0] target ids :
2010-08-03 14:24:56.460 INFO: *********************************************
2010-08-03 14:24:56.460 INFO: Link is broken for [4] physical file ids :
2010-08-03 14:24:56.476 INFO: TargetId:[598E37F2CF397E88CBEC99458213B30C] TargetType:[ExPhysicalFileStream] ObjectTypeName:[ObjReference] ParentObjectTypeName :[PhysicalFile] Parent's TopLevelObject's GUID:[8AD6F4A95BA222345D8ABF4D76AC797C]
2010-08-03 14:24:56.476 INFO: <?xml version="1.0" encoding="UTF-8"?>
<PhysicalFile CreationTime="1228167689828" Description="Symantec Endpoint Protection version 11.0.3001.2224 for WIN32BIT" FileChecksum="BE82774301FF5FAB9E708E535CCA0B7C" FileLastModifiedTime="1228167689828" FileName="E:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\Packages\SAV32.dat" FileSize="72829523" Id="8AD6F4A95BA222345D8ABF4D76AC797C" Name="ClientPackageFile" NameSpace="schema" _d="false" _i="1F1988730AB33D3B80F366AE4BE6486F" _t="1228167689843" _v="15">
  <ObjReference Name="LinkToFileContent" TargetId="598E37F2CF397E88CBEC99458213B30C" TargetType="ExPhysicalFileStream" _d="false" _i="55FD60670C6029F187DCC06B8770CEDA" _t="1228167689843" _v="7"/>
</PhysicalFile>

2010-08-03 14:24:56.476 INFO: TargetId:[145A767D68A4832BAD729BCEFA206BD1] TargetType:[ExPhysicalFileStream] ObjectTypeName:[ObjReference] ParentObjectTypeName :[PhysicalFile] Parent's TopLevelObject's GUID:[A6A052CCE453E3A2931A563BC68192D8]
2010-08-03 14:24:56.476 INFO: <?xml version="1.0" encoding="UTF-8"?>
<PhysicalFile CreationTime="1232433776675" Description="SESM AntiVirus Client Win64:11.0.4000:English" FileChecksum="12E12CC7E9151C0F4B4487DD2FCB34FF" FileLastModifiedTime="1232433776675" FileName="package.zip" FileSize="76459415" Id="A6A052CCE453E3A2931A563BC68192D8" Name="ClientPackageFile" NameSpace="schema" _d="false" _i="E511899417C3FA4CA152CA87B15D5A01" _t="1232433776675" _v="13">
  <ObjReference Name="LinkToFileContent" TargetId="145A767D68A4832BAD729BCEFA206BD1" TargetType="ExPhysicalFileStream" _d="false" _i="1883EB64F5005BFF902B33BC4B63B47A" _t="1232433776675" _v="6"/>
</PhysicalFile>

2010-08-03 14:24:56.476 INFO: TargetId:[5FD4C2B2C52AC7CB8591454F941A22F8] TargetType:[ExPhysicalFileStream] ObjectTypeName:[ObjReference] ParentObjectTypeName :[PhysicalFile] Parent's TopLevelObject's GUID:[170F16BD7F7C09E448967BCF346E04A7]
2010-08-03 14:24:56.476 INFO: <?xml version="1.0" encoding="UTF-8"?>
<PhysicalFile CreationTime="1232418911801" Description="SESM AntiVirus Client Win32:11.0.4000:English" FileChecksum="4FB7578B1F5DA48AD9AA135CC8A9ADD1" FileLastModifiedTime="1232418911801" FileName="package.zip" FileSize="73468564" Id="170F16BD7F7C09E448967BCF346E04A7" Name="ClientPackageFile" NameSpace="schema" _d="false" _i="020DE5EBDD55B89B3EB225429658E215" _t="1232418911801" _v="13">
  <ObjReference Name="LinkToFileContent" TargetId="5FD4C2B2C52AC7CB8591454F941A22F8" TargetType="ExPhysicalFileStream" _d="false" _i="2C541590FFFF23B7D85396AC4BB0504C" _t="1232418911801" _v="6"/>
</PhysicalFile>

2010-08-03 14:24:56.476 INFO: TargetId:[21660A1237C1E3C30B75C6F4B6364CDA] TargetType:[ExPhysicalFileStream] ObjectTypeName:[ObjReference] ParentObjectTypeName :[PhysicalFile] Parent's TopLevelObject's GUID:[3AB4A153ABCED47B0C0EFAEC471924F1]
2010-08-03 14:24:56.476 INFO: <?xml version="1.0" encoding="UTF-8"?>
<PhysicalFile CreationTime="1228167779687" Description="Symantec Endpoint Protection version 11.0.3001.2224 for WIN64BIT" FileChecksum="53D2B7676B98B09D51767ED6E3B8FEBC" FileLastModifiedTime="1228167779687" FileName="E:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\Packages\SAV64.dat" FileSize="75804842" Id="3AB4A153ABCED47B0C0EFAEC471924F1" Name="ClientPackageFile" NameSpace="schema" _d="false" _i="4FC4DCE7EB2A3304BDAC662792A1BE62" _t="1228167779687" _v="15">
  <ObjReference Name="LinkToFileContent" TargetId="21660A1237C1E3C30B75C6F4B6364CDA" TargetType="ExPhysicalFileStream" _d="false" _i="EB0409AC93BB4D86BEA472D14C5B21E1" _t="1228167779687" _v="7"/>
</PhysicalFile>

2010-08-03 14:24:56.476 INFO: *********************************************
2010-08-03 14:24:56.476 INFO: Database validation failed.
2010-08-03 14:24:56.492 INFO: Finished.
 

Cause

The SEPM database has links with client install packages that are broken.

Resolution

To work around this issue, delete old versions of client install packages through the SEPM console.  If the Dbvalidator results in failure please contact Support for assistance as some database errors can be fixed with additional tool(s).