LcsLog_Purge Job has been failing lately, should I be worried?


  • The following is what I found in the history logs:

    Executed as user: Domain\MyServiceAccount. The DELETE statement conflicted with the REFERENCE constraint "FK_FocusJoinsAndLeaves_4". The conflict occurred in database "LcsLog", table "dbo.FocusJoinsAndLeaves". [SQLSTATE 23000] (Error 547)  The statement has been terminated. [SQLSTATE 01000] (Error 3621)  Log purge successfully completed. [SQLSTATE 01000] (Message 0).  The step failed.

    Let me know if you need more details to assist in answering my question.

    There is always a way...

    • Modifié SeanPerkins mardi 16 février 2016 15:21 mispelling
    vendredi 12 février 2016 22:27

Toutes les réponses

  • Hi,

    From the description above, it seems that the database information delete policy confict with other policy.

    You may need to check if there is any SQL policy to affect Lync policy.

    Best Regards

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact

    Eason Huang
    TechNet Community Support

    mardi 16 février 2016 08:49
  • This error has persisted every day since the original post.

    We have no Policy Based Management running on these Lync servers.  I think the next step might be to contact our 3rd party support.

    There is always a way...

    • Modifié SeanPerkins mardi 16 février 2016 15:22 forgot additional information
    mardi 16 février 2016 15:20