This page explains PeopleSoft Query Limits for each database.
Detailed Information
WARNING: When a query exceeds the above time limits and generates a "time out" message, please notify the DBA group to cancel the query. When a query times out, it is actually still running, using system resources, and therefore needs to be cancelled.
| CSPRD - Campus Solutions |
Run Time Limit
in Minutes |
Output Size Limit
in Megabytes |
Max Number of Queries That
Can Run Simultaneously |
| |
When run query in Edit Mode |
5 Minutes |
5 MB |
Variable1 |
| |
When Run to HTML or Run to Excel |
5 Minutes |
5 MB |
3 |
| |
When run as Scheduled query |
Unlimited |
Unlimited |
0 - 32 |
| 1 |
Variable depending on a number of circumstances |
| 2 |
Depends on the number of other processes running at the same time |
| CSRPT - Campus Solutions Reporting |
Run Time Limit
in Minutes |
Output Size Limit
in Megabytes |
Max Number of Queries That
Can Run Simultaneously |
| |
When run query in Edit Mode |
5 Minutes |
5 MB |
Variable1 |
| |
When Run to HTML or Run to Excel |
20 Minutes |
10 MB |
4 |
| |
When run as Scheduled query |
Unlimited |
Unlimited |
0 - 32 |
| 1 |
Variable depending on a number of circumstances |
| 2 |
Depends on the number of other processes running at the same time |
| FNPRD - Financials |
Run Time Limit
in Minutes |
Output Size Limit
in Megabytes |
Max Number of Queries That
Can Run Simultaneously |
| |
When run query in Edit Mode |
5 Minutes |
5 MB |
3 |
| |
When Run to HTML or Run to Excel |
20 Minutes |
10 MB |
3 |
| |
When run as Scheduled query |
Unlimited |
Unlimited |
0 - 51 |
| 1 |
Depends on the number of other processes running at the same time |
| HRPRD - Human Resources |
Run Time Limit
in Minutes |
Output Size Limit
in Megabytes |
Max Number of Queries That
Can Run Simultaneously |
| |
When run query in Edit Mode |
5 Minutes |
5 MB |
Variable1 |
| |
When Run to HTML or Run to Excel |
20 Minutes |
15 MB |
3 |
| |
When run as Scheduled query |
Unlimited |
Unlimited |
0 - 32 |
| 1 |
Variable depending on a number of circumstances |
| 2 |
Depends on the number of other processes running at the same time |
Environment