Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specifie
edited Jan 25, 2019 12:40PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
we are getting error while trying to execute query from one of our peoplesoft environment.
Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server
But we are encountering the error only when we are not connected office netweok or VPN, over VPN it's working fine.
Just want to know if there is any specific setting other than below parameters which are restricting the result of query, Or there is nay setting from security side which can restrict the values.
PSAPPSRV Max Fetch Size=100000
PSQRYSRV Max Fetch Size=100000
Above are the current values form appserver configuration file.
1