PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

65532 :Query Result Set too Large. (50,546)Result of 'SQL Fetch' is over the maximum result size spe

edited Jan 27, 2016 10:06AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

I have an app engine that runs on process scheduler and calls a query to create report in excel format. When I run it, I get above error. I have already set no limit "Max Fetch Size" parameter under PSAPPSRV section. We don't have PSQRYSRV setup. When I schedule that query on process scheduler, I still get same error.

1. Is there a setting in process scheduler that controls max row fetch for queries?

2. When App Engine is run on process scheduler, is query running on process scheduler or app server?

3. I have a feeling that issue is number of rows that Excel can handle and not the max fetch size. Is it possible? Reason I think this is, when I modify app engine to create output in CSV/Text format, I don't get this error and all rows are written in CSV

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