When using SAS Web Report Studio to access a SAS^® Information Map that is based on SAS^® Scalable Performance Data Server^® data, the report might fail and the WebReportStudio.log file might contain these errors:

SPDS_ERROR: Library WRSTEMP is not assigned.
SPDS_ERROR: Library  is not assigned.

This error occurs because the SAS Web Report Studio query cache is not supported with the SPD Server.

There are two circumventions:

1. Disable the SAS Web Report Studio query cache, which is turned on by default.

Instructions to "Disable the Query Cache" are in the documentation topic "Improving the Performance of SAS Web Report Studio." For version 3.1, this topic is located at http://support.sas.com/onlinedoc/913/getDoc/en/biwaag.hlp/a002994057.htm. For version 4.2, this topic is located at http://support.sas.com/documentation/cdl/en/biwaag/63059/HTML/default/a002994057.htm.




2. Modify the WRSTEMP library assignment to use the SASSPDS engine. Locate the appserver_autoexec.sas file, which is typically located in .../Lev1/SASMain. Modify or comment out the existing WRSTEMP library assignment and create an assignment like this one:

LIBNAME wrstemp SASSPDS LIBGEN=YES IP=YES DISCONNECT=YES schema="dmart" USER="spds" PASSWORD="AdminAdmin1" HOST="smynb03605" Serv="5200" ;

Note: If you have installed and deployed hot fix 13 or higher, then you can set the LIBGEN option to NO. Otherwise, this option must be set to YES.

Note: For a complete list of LIBNAME options, see SAS Scalable Performance Data (SPD) Server LIBNAME Options.

Related usage notes include SAS Note 21081 and SAS Note 14050.

Operating System and Release Information