Article - CS193197

Index reorganization is filling up Transaction.log on MS SQL Server in Windchill PDMLink

Modified: 19-Jun-2017   


Applies To

  • Windchill PDMLink 9.1 to 11.0

Description

  • Index reorganization is filling up Transaction.log on MS SQL Server
  • Scheduled Task "ALTER INDEX REORGANIZE" is filling up Transaction.log
  • MethodServer.log is reading:
com.microsoft.sqlserver.jdbc.SQLServerException: The transaction log for database '<Windchill database>' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
  • Monitoring disk space usage of Transaction.log (logspace) is leading to Index reorganization as the root cause: CS193193
This is a printer-friendly version of Article 193197 and may be out of date. For the latest version click CS193197