E-QR: Query With Unions And Drilling URL Crashes Appserver With 'PSPAL' Errors When Using Query Viewer

(Doc ID 2108431.1)

Last updated on JULY 04, 2016

Applies to:

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

Symptoms

When attempting to run a particular PS Query report with unions and drilling URL through Query Viewer, the system crashes with the following error:

Error:
--------
"PSPAL: Abort: Unrecoverable exception received
PSPAL: Abort: Location: E:\pt85413c-retail\peopletools\src\pspal\exception_winunhandled.cpp:577: PSPAL::UnhandledExceptionFilter::RecoverableExceptionFilter
PSPAL: Abort: Generating process state report to D:\psconfig\appserv\HCTEST\LOGS\PSAPPSRV.6368\process_state.txt"

The same PS Query does work fine from 2-tier and Query Manager.

Steps:
---------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new Query
   3.1. Add EMPLOYEES, SELECT EMPLID & NAME COLUMNS; then create Union, add EMPLOYEES, SELECT EMPLID & NAME columns
   3.2. Add expression, type = Drilling URL. Build using Component URL link, add to both unions
   3.3. Use the expression as a field, or link it to an existing field
   3.4. Save query
   3.5. Click Run tab – results are returned
4. Navigate to: Reporting Tools > Query > Query Viewer
5. Run the report with any format (e.g. HTML, Excel etc.)
6. The error occurs

 

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