E-QR: Queries With Drilling URLs Run To Error When Scheduled (Doc ID 2023366.1)

Last updated on JULY 13, 2015

Applies to:

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

Symptoms

Queries will Drilling URLs end in 'Error' status when scheduled. The same query will run fine when executed online (via Query Manager or Query Viewer). The PSAESRV service on the Process Scheduler machine will also become non responsive (hang) or it will crash.

The Process Log in Process Monitor may show the following message:

 

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