My Oracle Support Banner

Error: "The Transaction Log for Database 'PMDB' is Full. To Find Out Why Space in the Log Cannot be Reused, See the log_reuse_wait_desc Column in sys.databases" When Deleting Rows From JOBLOG table (Doc ID 1961432.1)

Last updated on MAY 26, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.2.2.0 version, P6 EPPM Performance issues

When attempting to delete data from jobsvc and joblog,
the following error occurs.

ERROR
-----------------------
In SQL Server:

Message
The transaction log for database 'PMDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run P6 services process
2. Wait to run:

(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 float)delete from joblog where job_id in (select job_id from jobsvc where last_run_date is not null and recur_type = @P0 and status_code in (@P1, @P2, @P3, @P4 ,@P5) and (getdate() - last_run_date) > @P6)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.