PeopleSoft Query Limits

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

  • All PeopleSoft Databases
Print Article