E-RD: Reports Do Not Post When Web Server Is Bounced/Restarted. Receive Error: Error getting report repository location (Doc ID 660253.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

Reports run from Process Scheduler do not post to the Report Repository when the Web Server is initially started.

Web Servers are started and stopped on a daily schedule.  The System Purge is scheduled to run shortly after system startup.  Almost without fail, these reports do not post initially.  When Resend Content is selected manually, reports successfully post.

The  SchedulerTransfer servlet is not properly authenticating to the Application Server, but once a connection is established via a signon and authentication takes place, all subsequent reports transfer.

After the Web Server is bounced and the Distribution Agent is the first process to attempt to login and post reports, the following error messages can be seen:

From the Message Log of the affected process, seen via Process Monitor - Process # - Message Log:
"Error getting report repository location"

From PIA_stdout.log:

"SchedulerTransfer, authentication failed"

From PIA_stderr.log:

"java.lang.NullPointerException
       at psft.pt8.util.PIAContext.log(PIAContext.java:150)
       at psft.pt8.auth.PSAuthenticator.setUserTimeouts(PSAuthenticator.java:880)
       at psft.pt8.auth.PSAuthenticator.authenticate(PSAuthenticator.java:702)
       at psft.pt8.SchedulerTransfer.getReportPath(SchedulerTransfer.java:715)
       at psft.pt8.SchedulerTransfer.doPost(SchedulerTransfer.java:311)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
       at psft.pt8.SchedulerTransfer.service(SchedulerTransfer.java:93)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)
       at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)"

From dstagnt_nnnn.log:

"PSDSTSRV.6300 [09/27/12 00:05:24 PostReport](1) (JNI): Java exception thrown: java.net.ConnectException: Connection refused: connect
PSDSTSRV.6300 (4841) [09/27/12 00:05:24 PostReport](3)     HTTP transfer error."

Cause

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