My Oracle Support Banner

E-REN: When Using Oracle Multi-Node RAC Database, Running Report to Window Gets Stuck at Status 'Queued' or 'Success'. Report is Never Displayed or else it Displays to Another Window (Doc ID 662983.1)

Last updated on DECEMBER 23, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.44 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201071951




Symptoms

When running a report to window, the status page hangs at either 'Queued' or 'Success' page.
In some cases, the report is never displayed.   In other cases, the report is displayed to another window.

The process monitor shows that the report successfully posted and it can be viewed from process monitor.

There are no errors posted in process scheduler log (DSTAGT_MMDD.LOG) or in the REN server log (PSRENSRV_MMDD.LOG). 

However, the REN server access log, located in <PS_CFG_HOME>/appserv/<DOMAIN_NAME/logs/access.log will show the POST to 2 different directories.  Example:

123.44.55.44 - - [11/Jun/2011 18:35:43 -0400] "POST /psren HTTP/1.1" 204 128
123.45.777.33 - - [11/Jun/2011 18:35:51 -0400] "POST /psren/psreports/PSFASUA/413422 HTTP/1.1" 200 492
123.45.678.890 - - [11/Jun/2011 18:35:52 -0400] "POST /psren/psreports/PSFA1SUA/413422 HTTP/1.1" 200 492
123.45.678.890 - - [11/Jun/2011 18:35:54 -0400] "POST /psren/psreports/PSFA1SUA/413422 HTTP/1.1" 200 492

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

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