Endpoint Protection

 View Only

  • 1.  SEPM on MSSQL can't import client's packages

    Posted Feb 26, 2014 08:45 PM

     

     

    We installed a test version of SEPM 12.1.2 using MSSQL database 2012.

    The installation completed with errors (3) during the client's SEP packages import. Everyone platforms failed. with error like:

    "FAILED TO ADD SAV32 PACKAGE INTO THE DATABASE" 

     

    Trying to add those manually via SEPM as explined in

    http://www.symantec.com/business/support/index?page=content&id=TECH122824

    Same error.



    Upgraded to 12.1RU4a, same issue during the upgrade, and after manual importing attempt.

     

    How can we fix that?



  • 2.  RE: SEPM on MSSQL can't import client's packages

    Posted Feb 26, 2014 08:50 PM

    Have you tried running a repair on the SEPM?



  • 3.  RE: SEPM on MSSQL can't import client's packages

    Broadcom Employee
    Posted Feb 26, 2014 09:31 PM

    can you run the dbvalidator to check if everythings fine/

     



  • 4.  RE: SEPM on MSSQL can't import client's packages
    Best Answer

    Posted Feb 27, 2014 12:25 AM

    You need to run the upgrade.bat file .

    located in 'C:\Program Files\Symantec\Symantec Endpoint Protection Manager\bin\upgrade.bat'

    1. Run the Management Server Configuration Wizard again to complete the migration process.
    it should automatically add those packages


  • 5.  RE: SEPM on MSSQL can't import client's packages

    Posted Feb 27, 2014 12:48 AM

    DBvalidator log dump:

     

    2014-02-26 21:43:59.741 THREAD 1 INFO: logger initialized ...
    2014-02-26 21:43:59.741 THREAD 1 INFO: SEPM Server Home:[C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
    2014-02-26 21:44:01.286 THREAD 1 INFO: Initialized the database.
    2014-02-26 21:44:01.379 THREAD 1 INFO: Starting to travel the schema ...
    2014-02-26 21:44:02.518 THREAD 1 INFO: ... finished travelling schema.
    2014-02-26 21:44:02.518 THREAD 1 INFO: Total ids found >> TargetIds [113] PhysicalFileIds :[0]
    2014-02-26 21:44:02.518 THREAD 1 INFO: SELECT ID FROM BASIC_METADATA WHERE ID IN ('813D3E23AC121BF100A6F953AE86C307','995F63D0AC121BF10086B4B83FB47CAD','786E7F17AC121BF101298E5CAC841620','D28E853DAC121BF10024B8BB681B9222','4211A921AC121BF1015E7C521A2E069C','42E2E58DAC121BF1003C7BFC3D4E2A86','16E86983AC121BF101A48BEC3FFBDC6F','7D2A9916AC121BF10077D33DBC99F36B','094FE793AC121BF10087B91F669468AD','ED124AD6AC121BF1000CF7643423E0B4','AB528AADAC121BF100C8DE4068452175','24068BD0AC121BF10047972DA045A912','79355E2DAC121BF1018F9BA011E363FA','FC04731AAC121BF101989D68ADAC5D45','270763B7AC121BF100593E2C2D894852','E388BB86AC121BF101BA57C8EF252804','7BD9258EAC121BF10192A18FCC62F712','B17E10ABAC121BF101FB04E530D0682B','DD510317AC121BF1008CBEDBAA328C0B','637064D4AC121BF101317B408FC16503','8432F6A4AC121BF10171BC0681970E55','046EF743AC121BF10165B62F00173F7B','D098A057AC121BF101C3326A34E68BA5','FF1249F0AC121BF1004AAA6B66A50A1D','EE52489BAC121BF101BD21978BEE4373','9E9E7E27AC121BF1003E2338F8A0A20C','56AF2EF0AC121BF1003CDA91A7914037','50CF68D0AC121BF100694C5AB72F1228','9CB745D4AC121BF1017C90AFA0593A84','583FE53FAC121BF1015C2E43A72883FC','BF444CF4AC121BF100F45C82C1033A6F','0CC3F719AC121BF10161363B815689D3','FFF3A674AC121BF101CE24E16995A16C','C7D2AE93AC121BF1012D68E1B23C16C1','4084D600AC121BF1006BDB59EC849D90','A2A0A2F8AC121BF101096FCFBCE8352C','8ECBD5FDAC121BF101E56774F2ADB80D','AE21F8C8AC121BF1007D99BF796CE52E','76B33EE4AC121BF101B719196CCE0957','174D35C3AC121BF10145F8BC35FAF8E8','7D4E7EC9AC121BF1005EAF6A569ADEC7','F207BB7EAC121BF101DC5B58111A1B7A','E21028D2AC121BF101350B9B4C9B1076','77D6DD7DAC121BF10032C6AA0D6B1DD5','FB1F71C5AC121BF101C31456ACCB7001','59685699AC121BF10102F7E7CB6EBB66','AF233CECAC121BF1012BC56BCC2BB7C4','ED95EAD8AC121BF100B485061A9D360A','C2FC4850AC121BF101E76D1EE615AB32','2C6EC5CAAC121BF1007D1AE0361D56B6','41510561AC121BF101EA3C2CAA0284D0','09B6703DAC121BF101F2B5AB86F8C2EF','E9455583AC121BF100B029B5275089E9','6028C6E625754ECE4312D41CB963A039','64D92353AC121BF100731864B172DC7A','BB6B0EB6AC121BF100C4D218EAEA3D9B','8E9792B8AC121BF101F5C785B794140E','B988E904AC121BF101A48B6BC0CD1252','22A5C400AC121BF10091DB2676237BBA','96C48BD4AC121BF101C3522CC9464FDD','11ACF098AC121BF100401C4625A80E52','0B401C1BAC121BF101C9D250EE2F1DA4','161A1154AC121BF101A7A7AC4F242A04','F2286D7CAC121BF1003C5754D80D828D','1B358B8BAC121BF1002C85CC5F39B09F','67121182AC121BF1011FB76F38FF109F','BA7DE520AC121BF100D493537140D9E9','092D3E60AC121BF1010CF94DA022C85F','A12B9A77AC121BF1004970FB25EE5E68','13D10870AC121BF1007B643D5194D43D','AA0D690FAC121BF1017CA56DCAB5CE71','9C10B95AAC121BF100CC911594BD3442','3413ADC4AC121BF101BA00230B4D010B','DBDA5D7EAC121BF100164452821CAEB1','3BE0C7C3AC121BF100E29300EFB3DCEF','70CD00B3AC121BF100302EF9EAC7F4B1','9CA5DC6AAC121BF1000BF5AD9CB5F5E5','221512D0AC121BF100B7A28E4C564F04','8951D5FEAC121BF101A5F9B96A57613C','028686C8AC121BF10062B0BF6C74286F','AD4C5831AC121BF100C5E3974FD321C8','9E2B03C0AC121BF100582F096EDA2A04','C6A84587AC121BF100DF8C15995152D0','A23C4BFFAC121BF10065A0778EAF57BF','6F936278AC121BF10002E74EF13763B5','B655E64D0A320801000000E164041B79','9B077ED2AC121BF100AC523A0C3FD25F','26D26D22AC121BF10051FFA7843804CD','D8763D3DAC121BF101CE736289B9189E','17DAA4BBAC121BF101252682E8D8C347','6C171AA4AC121BF1017B03FF06752ACE','E15D32E1AC121BF100E980E58BD1F5F0','B20B6E870A980D7A00AF2A50862A396D','5DDA1F08AC121BF101B539C3BC95199D','588A8EBDAC121BF10049F60B24B228EB','F199830DAC121BF1000AB75BBC6B03AB','68DA0BF7AC121BF10172ACAC2CC28591','831AC192AC121BF101EA1FBAA90BC89F','D24C82CDAC121BF101518CE17D25CAF3','5F29B119AC121BF100792223E4BFA142','A5E6D3B0AC121BF101B6D1A0838B1783','3BB9D4A2AC121BF100EDA165898349EE','F6DC4766AC121BF100FF0F070E3231A9','3C146EEFAC121BF101BB222F82B4ACC3','6DC5BB6BAC121BF101B70EBBE9298A88','AC2F7011AC121BF10055D121758FB0F1','AADF1CCDAC121BF100FF7BE251362097','9E017222AC121BF1014B514893AE5771','C0842263AC121BF100C3282159954136','84BCB277AC121BF101AFAE52A7959C6B','0BFC9A4CAC121BF100112E72828DD30A','D75C0CE0AC121BF100F2F3B18E7CBE6E','87E2CBCCAC121BF1000389877EA6B384') AND DELETED=1
    2014-02-26 21:44:04.094 THREAD 1 INFO: *********************************************
    2014-02-26 21:44:04.094 THREAD 1 INFO: Following ids are not present in the database.
    2014-02-26 21:44:04.094 THREAD 1 INFO: *********************************************
    2014-02-26 21:44:04.094 THREAD 1 INFO: Link is broken for [0] target ids :
    2014-02-26 21:44:04.094 THREAD 1 INFO: *********************************************
    2014-02-26 21:44:04.094 THREAD 1 INFO: Link is broken for [0] physical file ids :
    2014-02-26 21:44:04.094 THREAD 1 INFO: *********************************************
    2014-02-26 21:44:04.094 THREAD 1 INFO: Database validation passed.
    2014-02-26 21:44:04.110 THREAD 1 INFO: Finished.
     
    The packages failed to be installed during the config wizard as you can see in the attachment screenshots.
    It was not possible to include those even manually.


  • 6.  RE: SEPM on MSSQL can't import client's packages

    Posted Feb 27, 2014 12:54 AM

    Did you try repair SEPM on ADD/remove program ?



  • 7.  RE: SEPM on MSSQL can't import client's packages

    Broadcom Employee
    Posted Feb 27, 2014 12:56 AM

    run the upgrade.bat and check if it works fine.



  • 8.  RE: SEPM on MSSQL can't import client's packages

    Posted Feb 27, 2014 01:16 AM

    it does happen sometimes due to various issues. ( Ex, disk space, lack of permisson to add package)

    Have you tried running Upgrade.bat, as I mentioned in previous post



  • 9.  RE: SEPM on MSSQL can't import client's packages
    Best Answer

    Posted Feb 27, 2014 12:28 PM

    upgrade.bat works. Thanks!

     

    It's very weird thoug that the issue came from an installation from scratch and at it was persistent after an upgrade (from 12.1.2 to 12.1.4a). I thought the upgrade.bat was sort of included in the whole upgrade process, but was not.