Overview

When the SAS Web Report Studio query cache is in use, you might see an error similar to the following when you attempt to view a report:

If this error is occurring after a period of working successfully, then the first step is to restart your object spawner to see whether that resolves the issue.

If restarting the object spawner does not resolve the issue, then this KB article explains the two most common causes of this error.

The WRSTEMP library and the data library are assigned to different servers

One of the properties for a library is a server assignment. If the data library and the WRSTEMP library are not assigned to the same server, then you see the "Libref WRSTEMP is not assigned" error. To resolve this issue, complete the following tasks in SAS^® Management Console.

1. Right-click the library that contains the data that you are using for the report, and then select Edit Assignments. Make note of the server listed in the Selected servers box.

   Note: If you selected multiple servers for the data library, then contact SAS Technical Support for assistance. You should contact SAS Technical Support even if one of the selected servers is the same server that is selected for WRSTEMP.

2. Open the assignments for the WRSTEMP library (typically, SASApp - wrstemp). If the server selected for the WRSTEMP library is not the same one that is selected for the data library, then you can do one of the following.
   • On the Edit Assignments tab for the WRSTEMP library, replace the currently selected server with the server that is being used for the data library.
   • Re-open the assignments for the data library and replace the currently selected server with the server that is being used for the WRSTEMP library.
3. If you modified the assignments, restart the object spawner.

Sample server assignments

The following display shows correctly configured assignments. Both the data library and the WRSTEMP library are assigned to the same server context.

In the following display, the data library and the WRSTEMP library share a server context (SASApp2). However, if you base an information map on a table selected from the SASApp server context, then you will see the error.

The following display shows incorrectly configured assignments. The data library and the WRSTEMP library are assigned to different server contexts.

The account used to launch the workspace server does not have permission to access the WRSTEMP location

Standard workspace server account

If SAS Web Report Studio is using a standard workspace server (not common), then make sure that the user launching the workspace server has the ability to read and write to the WRSTEMP location. For a list of required permissions, see Where to find information about the query cache and WRSTEMP permissions

Pooled workspace server account

By default, SAS Web Report Studio uses a pooled workspace server. In that configuration, the launch credentials for the pooled workspace server must have the necessary permissions to the WRSTEMP location. To determine which credentials are being used for the pooled workspace server, perform these steps:

1. Log on to SAS^® Management Console with an account that has permission to access the Server Manager plug-in.
2. Expand Server Manager and navigate to the server context to which your WRSTEMP library is assigned. For example, if your WRSTEMP library is assigned to SASApp, then you would navigate to Server Manager ► SASApp ► SASApp - Logical Pooled Workspace Server ► SASApp - Pooled Workspace Server.
3. Right-click SASApp - Pooled Workspace Server and select Properties.
4. Click the Options tab. The credentials appear in the Multiuser credentials box.

   Note: Also make sure that this account is listed on the Accounts tab for the SAS General Servers group.

Test permissions

Follow these steps to determine whether the account that is being used to launch the workspace or the pooled workspace server has permissions to assign the WRSTEMP library.

1. Use the applicable account to log on to SAS^® Enterprise Guide^®.
2. Select File ► New ► Program.
3. In the Program window, enter a LIBNAME statement to the physical WRSTEMP location. For example, you might enter the following code:   LIBNAME test "C:\SAS\EBI\Lev1\SASApp\Data\wrstemp"; run;
4. Submit the code on the server to which the WRSTEMP library is assigned. So, if the WRSTEMP library is assigned to SASApp, then submit the code on SASApp.
5. Examine the log for errors. If the code fails, then check the operating system permissions for the account. For a list of required permissions, see Where to find information about the query cache and WRSTEMP permissions.

Where to find information about the query cache and WRSTEMP permissions

For information about the query cache and WRSTEMP permissions, see the topic "Improving Performance of SAS Web Report Studio" in the SAS Intelligence Platform: Web Application Administration Guide. You can find a link to the guide on the SAS^® Intelligence Platform Product Documentation page. Click the tab for your release of SAS.