Skip to main content
P
PP_84227511-Visitor
1-Visitor
March 3, 2026
Solved

windy.MiscLogEvents has 19M records; Not purging automatically

  • March 3, 2026
  • 3 replies
  • 61 views
I am using Windchill PDMLink Release 13.0 and Datecode with CPS 13.0.2.4

windy.MiscLogEvents has 19M records and DB has gown 100% in size in the last 3-4 months. CS178198 states to contact support if >10M records. Need assistance cleaning out the table and fixing maintenance routine to auto-purge.

Here are the errors that I faced
No errors; just table size issue.
    Best answer by mmeadows-3

    The MiscLogEvents table exists so we can see MS Log file errors through the Server Status > Monitoring Tools > Log Event Histogram page.

     

    This article covers MiscLogEvents fairly well.

    https://www.ptc.com/en/support/article/CS42494

    The content of this table is intended to be temporary, and it is OK if the records are deleted.  More will be generated...

     

    So, I would start with cleanup.

    https://www.ptc.com/en/support/article/CS178198

    • Probably need truncate this table before enabling the schedule; because Database SQL cannot delete 10 million table rows

    https://www.ptc.com/en/support/article/CS411345

    As DB user:

    truncate table MiscLogEvents

     

    Then I would try to understand and correct the cleanup failure.  It could be a queues issue or something was blocking the cleanup.  Sometimes cleanup starts working just because you truncated the table.

    3 replies

    A
    anursinghCommunity Manager
    Community Manager
    March 9, 2026

    Hi @PP_8422751,

    Thank you for your question. 

    Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

    Also, feel free to add any additional information you think might be relevant. It sometimes helps to have screenshots to better understand what you are trying to do. 

     

    Regards,

    Anurag 

      M
      mmeadows-316-PearlAnswer
      16-Pearl
      March 9, 2026

      The MiscLogEvents table exists so we can see MS Log file errors through the Server Status > Monitoring Tools > Log Event Histogram page.

       

      This article covers MiscLogEvents fairly well.

      https://www.ptc.com/en/support/article/CS42494

      The content of this table is intended to be temporary, and it is OK if the records are deleted.  More will be generated...

       

      So, I would start with cleanup.

      https://www.ptc.com/en/support/article/CS178198

      • Probably need truncate this table before enabling the schedule; because Database SQL cannot delete 10 million table rows

      https://www.ptc.com/en/support/article/CS411345

      As DB user:

      truncate table MiscLogEvents

       

      Then I would try to understand and correct the cleanup failure.  It could be a queues issue or something was blocking the cleanup.  Sometimes cleanup starts working just because you truncated the table.

        P
        PP_84227511-VisitorAuthor
        1-Visitor
        March 18, 2026

        CS42494 covered my issue with both TRUNCATE and PROPERTIES file change to stop from repeating.

         

        Thanks for the assistance!

        PP

        A
        anursinghCommunity Manager
        Community Manager
        March 18, 2026

        Hi @PP_8422751,

         

        I wanted to see if you got the help you needed.

        If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
        Of course, if you have more to share on your issue, please pursue the conversation. 

         

        Thanks,
        Anurag 

          P
          PP_84227511-VisitorAuthor
          1-Visitor
          March 18, 2026

          Yes, thanks!  Updated and marked as answered.

          Terms & ConditionsCookie settingsAccessibility statement