DX NetOps

Spec KB: Spectrum Report Manager fails with "The total number of locks exceeds the lock table size" in the tomcat log

  • 1.  Spec KB: Spectrum Report Manager fails with "The total number of locks exceeds the lock table size" in the tomcat log

    Posted 02-18-2016 07:58 AM

    Spec KB: Spectrum Report Manager fails with "The total number of locks exceeds the lock table size" in the tomcat log

    Document ID:  TEC1442413

    ShowHide Technical Document Details

    • Products
      • CA Spectrum
    • Releases
      • CA Spectrum:Release:10.x
      • CA Spectrum:Release:9.3.x
      • CA Spectrum:Release:9.4.x
    • Components
      • REPORTING
      • ONECLICK
      • APPLICATIONS

    Problem:

    Spectrum Report Manager (SRM) fails during schema changes, or during event processing.

    Error seen in the tomcat log file:

    "Caused by: java.sql.SQLException: The total number of locks exceeds the lock table size"

    Log locations:

    Windows - $SPECROOT/tomcat/logs/stdout.log

    Solaris/Linux - $SPECROOT/tomcat/logs/catalina.out

    Please select the following link for more information on this subject:

     

    Knowledge Document Link:

     

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1442413.aspx