Overview

In some circumstances, SAS Report Viewer might fail to load objects on a page after a period of inactivity. Usually, this problem occurs for reports with multiple sections and multiple data sources. However, the problem can also occur for reports with only one data source when objects in the multi-section report generate different queries.

For example, suppose your report has two pages. The first page has a bar chart that uses the Car Make category. The second page has a bar chart that uses the Dealers category. After you view the first page, you take no query-related actions on the report for 30 or more minutes. When you attempt to view the second page, the bar chart fails to render. Instead, you see the Loading message, which remains indefinitely.

At this point, you can refresh the page to render the object.

When this problem occurs, the sas-sasreportviewer.log or the sas-report-data.log might contain a warning about an expired executor. Here is an example:

Workaround

To alleviate this problem, you can increase the executorExpirationIntervalMinutes property on the Report Data service.

1. Log on to SAS® Environment Manager as an Administrator.
2. Navigate to Configuration ► All Services ► Report Data Service.
3. On the right, in the filter box, type sas.reportdata.system. You should see the executorExpirationIntervalMinutes property already defined for 30 minutes.

6. Click the Edit icon  in the upper right corner.
7. Change the value of this property from 30 to 60.
8. Click Save.
9. Wait a minute for the changes to take effect.

Next Steps

The issue described in this SAS Note is not the only cause of a Loading message. For another known cause, see SAS Note 64435, SAS® Report Viewer fails to load some report objects when the SAS® Visual Analytics report uses parameters.

Operating System and Release Information