Unable To Delete SQR Job Output In EPM Workspace (Doc ID 1432703.1)

Last updated on MARCH 22, 2012

Applies to:

Hyperion BI+ - Version: 11.1.1.3.515 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


The Production Reporting SQR Job output is not being removed from Enterprise Performance Management (EPM) at the scheduled deletion time.

An example scenario from SQR 11.1.1.3.515:

The SQR job runs and generates an output collection with several hundred objects (800 PDF and 800 csv files each). These output collections are set to auto delete after 30 days.  After 30 days the objects are not deleted.
When the option of accessing the properties of the SQR job and deleting the output collection from the "Job Outputs" section also fails to delete the collection.

EXPECTED BEHAVIOR

  • Garbage Collector should delete all objects set for auto delete on the set date
  • Deleting the output collection from within the job properties should work as expected.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms