Skip to main content
3-Newcomer
October 3, 2022
Question

The transaction log for the wtuser database gets filled

  • October 3, 2022
  • 2 replies
  • 915 views

I am using Creo Parametric Release 6.0 and Datecode6.0.6.0

We are getting the transaction log for the wtuser database filled up error.

This morning I tried to shrink the log file, and it helped for 5 minutes. Then I truncated the logs and it helped for a short period of time again. But it gets filled up pretty quickly and users can't use the app anymore.

A user's report:

I open PTC Creo, then click "Workspace" on the left. Then type in the search bar next to the "Quick Links" drop down menu. I search for "model*" to try and access our assembly. It then says:

An unexpected error has occurred while performing search. Please contact system administrator.

And that's when I click OK I get Windchill error.

Exception: wt.util.WTRuntimeException: A persistence error occurred. Nested exception is: A persistence error occurred

Here are the errors that I faced
MSSQLServer Event 9002: The transaction log for database 'wtuser11' is full due to 'LOG_BACKUP'.

2 replies

3-Newcomer
October 10, 2022

The provided links does not solve the issue. 

We could not find what caused the transaction log to fill up to its capacity so fast. Like in 5 or 10 minutes, when it would never do it before. 

We just switched to Simple backup mode for now. Will come back to this problem later.