PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Pivot Grid export results give message Query Result Set too Large

edited Feb 19, 2025 4:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered ✓

I have a query that is to be exported from Pivot Grid results, but when the export is done, the message "Result of SQL Fetch is over the maximum result size specificed for the application server." When I schedule the query, the process scheduler shows that the file size is 3,504,075 bytes. This is equivalent to 3504 KB, which is within our app server settings of 5000 for PSAPPSRV and 10000 for PSQRYSRV. Am I mis-reading the file size? Or why would this file not export when it appears to be within the app server settings. I've read the DOC ID 617786.1, but all it tells me is what the app server settings should be, which I've confirmed to be the default.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center