My Oracle Support Banner

Academic Advisement Purge Report Results Error - The Transaction Log For Database xxx is Full Due To 'ACTIVE_TRANSACTION'.(SQLSTATE 42000) 9002 Failed SQL stmt: DELETER FROM PS.SAA.RPT_ERROR (Doc ID 2996558.1)

Last updated on JANUARY 11, 2024

Applies to:

PeopleSoft Enterprise CS Academic Advisement - Version 9.2 and later
Information in this document applies to any platform.


When attempting to purge Advising Reports and logs for larger reports the following error occurs:

The transaction log for database xxx is full due to 'ACTIVE_TRANSACTION'.(SQLSTATE 42000) 9002 failed SQL stmt: DELETER FROM PS.SAA.RPT_ERROR WHERE EMPLID='xxx' AND ANALYSIS_DB_SEQ=8

The issue can be reproduced at will with the following steps:

  1. Navigate to Academic Advising ->Advisement Processes-> Purge Report Results and run the report. 
  2. In Process Monitor, note the process ends in 'No Success'. 
  3. Click 'Details' then 'View/Log Trace', then the log file in the file list to review the error message. 


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

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