If you define a SAS^® Table Server library in SAS^® Management Console that has a blank space in the data source name, and you try to assign the library in SAS^® Enterprise Guide^®, you will receive the following error:

If you check the Show details box, you will see this additional information:

[Error] Libname libref is not assigned.

SAS.EG.SDS.SDSException: <?xml version="1.0" 
?> <Exceptions><Exception><SASMessage severity="Error">Libname D18456TS is not assigned.</SASMessage></Exception></Exceptions>
   at SAS.EG.SDS.Model.Library.Assign()
   at SAS.EG.SDS.Model.Library.PopulateDatasets(Collection& collection)
   at SAS.EG.SDS.Model.Broker.PopulateCollection(Collection collection)
   at SAS.EG.SDS.Model.Collection.DoPopulate()
   at SAS.EG.SDS.Model.Collection.Populate()
   at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op) 

If you have logging enabled for the SAS Workspace server, you will see the following error in the SAS Workspace server log:

In this error message, second_word is the string of characters that follows the first blank space character in the data source name.

To circumvent the problem, you must do the following:

1. In SAS Management Console, expand the Table Server Manager Plug-in, then expand the Table Server Logical Server.
2. Click the Data Source Names folder and select the data source name in the right pane that contains the space.
3. Open the properties for this data source name and edit the name to remove any blank spaces.
4. Open the properties for the library in the Data Library Manager Plug-in, select the Options tab and remove any blank spaces from the Data Source Name value.

Now disconnect from your application server in SAS Enterprise Guide and reconnect. You should be able to successfully assign the Table Server Library.

Operating System and Release Information