In SAS Forecast Studio, stored-process reports might time out after ten minutes, generating the following error:

The time-out occurs because the SAS_JES_TASK_LOGS table in the SAS^® Shared Services database contains a large number of SAS Forecast Studio log entries.

To work around this problem, delete the SAS Forecast Studio log entries from the SAS_JES_TASK_LOGS table, as follows:

1. Log on to the SAS Shared Services database with these commands:
   POSTGRESQL_HOME={path-to}/SASWebInfrastructurePlatformDataServer/9.4
   
   export PATH=${POSTGRES_HOME}/bin:$PATH
   
   export LD_LIBRARY_PATH=${POSTGRES_HOME}/lib:$LD_LIBRARY_PATH
   
   psql -h localhost -U SharedServices -p 9432
   
   Password for user SharedServices:
2. Verify the size of SAS Forecast Studio report log entries in the SAS_JES_TASK_LOGS table by submitting the command that is shown in the following example:
   Shared-Services-prompt > select count(*) from sas_jes_task_logs where task_id in (select task_id from sas_jes_tasks where stp_path_txt like '%FSReports%');
   
   count
   
   -------
   
   1600
   
   (1 row)
3. Delete the entries in the table by submitting this command:
   delete from sas_jes_task_logs where task_id in (select task_id from sas_jes_tasks where stp_path_txt like '%FSReports%');

Retest the stored-process report. The report should open in a browser without timing out.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Forecast Server 15.2 is available at: