SAS^® Management Console requires an application server in order to perform the Update Metadata step. SAS^® 9.2, SAS^® 9.3, and SAS^® 9.4 use the default application server that is set in the connection profile that you use to connect to the SAS^® Metadata Server.

When you use SAS Management Console to update table metadata, a dialog box with the following message might be produced:

The message occurs when the library is invalid on the default server or when the user does not have access to the default server. The message is common when the default server is SASMeta.

The default application server is defined by the object-ID value of the server context, which is set in the AppServer.Default= property in the connection profile.

The connection profile is defined by an SWA file in the user's Application Data directory that resides in locations similar to the following:

For Windows operating environments:

For Windows Vista or later operating environments:

For UNIX operating environments:

Sample contents of an SWA file:

In the sample SWA file above, AppServer.Default=A53DVWWM.AR000001 refers to the object ID for the SASMeta server context on this server.

Follow one of the following circumventions to update table metadata:

1. Edit the SWA file and remove the AppServer.Default= value so that no default server is named. The next time a server is needed (for example, for updating table metadata), you will be prompted to select a server. Select the server that is appropriate for the library (for example, SASApp).
2. Submit a METALIB procedure step from within a SAS job or from an interactive session such as in SAS^®®, running on the appropriate compute server for the library. The PROC METALIB step should look like the following code sample:

In this code:

• The value for SERVER= (in this case, sasbi.demo.sas.com) names the metadata server.
• The value for LIBRARY= (SAS-demo-library) specifies the name of the library that you see in SAS Management Console.
• The value for FOLDER= (/Shared Data/SAS-demo-data) specifies the metadata location for the table.
• The SELECT statement specifies the names the table or tables to update.

This scenario does not use the default server that is defined in the server profile.

Operating System and Release Information