My Oracle Support Banner

E-QR: Query With Default Value Prompt Crashes Appserv With 'PSPAL' Erros When Using Query Manager Or Viewer (Doc ID 2669578.1)

Last updated on AUGUST 18, 2022

Applies to:

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


A Query that has a default value in one of the prompts, when run to Excel or other forms of output, causes an appserver crash and disconnects/ends the user session. The Query will run successfully from the RUN tab, but then 'download to Excel' will trigger the crash or termination of the user session. Saving the Query and running it from Query Manager or Query Viewer will result the same.
The issue can be reproduced with the following steps:
1. Submit a query that has a prompt which contains a long default value, from Query Manager "Run" tab
2. Observe success and then try 'download to excel'
3. observe kicked out of session



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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