Endpoint Protection

 View Only
  • 1.  replication Fail

    Posted Oct 11, 2012 02:37 AM

    Hi Team,

    SEPM version 11.0.4 ,SQL Database,server 2003 ent, SQL 2005 database

    15,000 client, GUP ,Replication+Loadbalance.

    Note:In Primary server instaaled SEPM as well as SQL database on same Machine

     This scanario is same sa secondary server.

    during replication between 2 SEPM We had got error .SQL server transion Log is full  and on primary server most of client going to default group.

    we have move client in perticular group and block but restart the server again client goes to default group.

    Now Replication is fail,



  • 2.  RE: replication Fail

    Posted Oct 11, 2012 02:45 AM

    HI,

    Kindly check database transaction log file (sem5.log ) size ?

    Symantec Endpoint Protection Manager (SEPM) symptoms that may occur when the SQL transaction logs fill up

    Solution :

    Clear out the transaction logs in the SQL database. See Microsoft Technote at the following URL: http://support.microsoft.com/kb/110139 and/or http://support.microsoft.com/kb/317375
     

    Reference

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

    Check this thread also

    https://www-secure.symantec.com/connect/forums/sepm-unable-communicate-reporting-component-sql-database



  • 3.  RE: replication Fail

    Broadcom Employee
    Posted Oct 11, 2012 03:23 AM

    Hi Anil,

    SQL Database maintenance is working as per scheduled or not ?

    At this point you should seriously consider to upgrade SEPM to the latest version

    What are the Symantec Endpoint Protection (SEP) versions released officially?

    --> http://bit.ly/m0vOJp

    However to troubleshoot mentioned issue please go through following article

    Clear out the transaction logs in the SQL database. See Microsoft Technote at the following URL: http://support.microsoft.com/kb/110139 and/or http://support.microsoft.com/kb/317375

    Reference:http://www.symantec.com/docs/TECH90931 

     



  • 4.  RE: replication Fail

    Posted Oct 11, 2012 04:22 PM

    +1 !

    So many replication issue with previous SEP version earlier than 11.0 RU7 so as Chetan said, I strongly recommend you to migrate to higher version.

    But for sure, you need to fix that issue first.

    Check in your SQL Server with the help of SQL Server Management Studio (if you installed it) the table named sem5_log or sem5_logs the table has probably reached the file size limit allowed for this table.

    If so, try to activate the truncate directly on your MS SQL. If it's not possible then simply increase the file size limit allowed of this table.

    At the same occasion, check if you do not have any other sem5 tables nearly full, increase them a litle bit it's still better to anticipate any future issue :-P

    The tables that you need to increase more than any others if they're very close to be full are: sem5_db & sem5_content

    Then try again your replication.

    However, we should remind you that it's strongly recommended to keep your servers updated and to use same SQL Database version. From one you're using 2003 and another 2005, that's somewhat risky even if it has worked without any probleme before.

    Keep us updated ;-)

     

    Kind Regards,

    A. Wesker



  • 5.  RE: replication Fail

    Posted Oct 16, 2012 09:39 AM

    HI Anil,

    Did you received solution ?