Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server
One of the users reported that she was getting the above error when she runs a private query.
I found out that this query is bringing back around 100,000 rows back and which is taking a lot of memory and the size.
To overcome the issue I asked her to adjust the query to bring the less no of rows, but unfortunately she wants to have all those rows.
The only solution for this is to increase the fetch size on PSQRYSRV and/or PSAPPSRV.
PeopleSoft Queries that are run through the web through the ‘Run’ option have the ability to utilize the PSQRYSRV if it’s been configured and started. PeopleSoft Queries that are run from the ‘Preview’ tab (8.4x onwards) can only use the PSAPPSRV. If users need to run the long running queries from the Preview tab, the PSAPPSRV max fetch size will need to be increased, for an unlimited size set this value to 0 (Zero).
[PSQRYSRV]
Max Fetch Size = change it to a higher number
[PSAPPSRV]
Max Fetch Size = change it to a higher number