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.
When attempting to run a particular PS Query report with unions and drilling URL through Query Viewer, the system crashes with the following 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms