E-QR: Running PS Query With Prompts That Use The Edit Type Of 'Prompt Table' Or 'Translate Table' Crashes The Application Server
Last updated on OCTOBER 05, 2015
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.
*** Checked for relevance on 5 October, 2015 ***
When attempting to create a query with a run-time prompt and use the edit type of "Prompt Table" or "Translate Table", the following error occurs in application server log file:
“PSPAL: Abort: Unrecoverable exception received
PSPAL: Abort: Location: E:\pt85108b-retail\peopletools\src\pspal\exception_winunhandled.cpp:594: PSPAL::UnhandledExceptionFilter::UnrecoverableExceptionFilter
PSPAL: Abort: Generating process state report to” "
There is not an issue If the edit type is changed to 'No Table Edit', the query works fine. The issue also does not exist when using the 2-tier Query tool (via Application Designer) or using Query Manager and run the query via the 'Edit' link - Run tab.
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 PS Query by adding a field (e.g. 'TRANSACTION_GROUP' ) as a prompt for a record ( 'TRANSACTION_INV')
4. From Edit Prompt Properties page select the ‘Edit Type’ as Prompt Table or Translate Table
5. Run the query by hitting the hyperlinks HTML/XM/ XLS from Query Viewer/Query Manager pages
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