By default, queries that are submitted by SAS Web Report Studio run until completion regardless of the complexity and amount of time that is required for the process to complete. However, there are cases in which you might want to limit the time for these queries.

To set a time-out limit for queries, add the following argument to the Java Virtual Machine (JVM) arguments for your Web application server:

    -DSASQueryServices.sasSubmitTimeout=milliseconds

The time-out is in specified in milliseconds. For example, to limit all queries that are submitted by SAS Web Report Studio to 120 minutes, use this argument:

    -DSASQueryServices.sasSubmitTimeout=1200000

After you make this change, restart your Web application server.

If a query exceeds the time-out, a message similar to the following appears in the log:

As a general rule, set the value for sasSubmitTimeout to 75% of the value for the SAS Web Report Studio session time-out.

Operating System and Release Information