When you run a large query/report, you may receive an error message stating that the query result set is too large:
This error results because the system times out before the query is complete. If you receive this error, follow the instructions to schedule the query and avoid the error.
From the Manager Self Service, click on the NavBar in the top right corner and then select the Menu icon. Scroll down and select Report Tools.
Select Query and then select Query Manager.
Input the name of the query you want to run. We will use Z_GS_EP_CRITELEMENTS in our example.
Click Search.
Search for query and then select Schedule.
On the Schedule Query page, select Search.
On the next page enter a description for your report, then OK. In the example below, EMAIL_REPORT_6_10 was entered.
On the next pop up page, if you want to have a reoccurring report of this scheduled query Select your Recurrence and the Starting Run Date and Time Zone. Update the type to Email. Update the format to XLS and then Click OK.
The query will run and be sent to your email. (If you don’t see it in your email , check your spam folder.) Use the following navigation to check the status of the query: NavBar - Navigtor - PeopleTools - Process Scheduler - Process Monitor.
U.S. General Services Administration
