The transaction log for database 'wcadmin' is full. To find out why space in the log can

The PLM system prompts an error and the workflow cannot be edited.

 

Log Path D: \ PTC \ windchill_10.1 \ windchill \ logs \

Methodserver. Log: the following error message is displayed.

Java. SQL. batchupdateexception: The transaction log for database 'wcadmin' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in SYS. Databases

 

Cause:The log file is full.

Check:QuerySYS. DatabasesInLog_reuse_wait_descColumn. Use the following SQL statement

Select log_reuse_wait_desc from SYS. databases where [name] = 'wcadmin ';

The value is as follows:Log_backup,This problem must be solved by running log backup. Therefore, perform a log backup for the database:

Continue to execute the following statement,Execution takes about 10 minutes

Backup log wcadmin to disk = 'd: \ log_bakcup \ wcadminackup. trn ';

 

After the backup is complete, the problem is solved, and then checkLog_reuse_wait_descThe value is as follows:Nothing (There are one or more reusable virtual log files.)