![]() | ![]() | ![]() |
If you have followed the instructions in SAS Note 40103 for making format catalogs available, but you still cannot see the formats in SAS Information Map Studio, then review the following possible causes.
Note: SAS Information Map Studio does not enable you to select user-defined formats for OLAP data sources (see SAS Note 18347).
| Possible Cause | Possible Resolution or Next Steps | ||
|---|---|---|---|
| After modifying the applicable .cfg file by following the instructions in SAS Note 40103, did you restart the object spawner? | Restart your object spawner so that you are working with a new SAS session. | ||
| Is the table selected for the information map associated with the same SAS Application Server to which you defined the format catalog? | Both the table and the catalog must be defined in the same SAS Application Server. For example, if your table is associated with SASApp, but your user-defined format catalog is associated with SASApp2, then you will not see any formats. To resolve this issue, you can either select a table from the SAS Application Server associated with the format catalog, or follow the instructions in SAS Note 40103 to make the user-defined formats available to the server that is associated with the table. | ||
| Can you successfully submit a LIBNAME statement for the location of the format catalog? | In SAS 9.2, a pooled workspace server is used by default and the typical launch credentials are sassrv. If you are running a standard workspace server (the default in SAS 9.1), then the launch credentials are the same ones used to log into SAS Information Map Studio. In SAS® Enterprise Guide®, log in with the appropriate credentials to the server context in which the formats catalog is defined. For example, in SAS 9.1, the server context might be SASMain, as shown below.
Submit the following code, substituting your site-specific information.
If you see the following errors, then contact your administrator to request operating-system access to the location. ERROR: User does not have appropriate authorization level for library LIBRARY. ERROR: Error in the LIBNAME statement. |
||
| Can you read the contents of the formats catalog, and does the catalog contain formats? | In SAS 9.2, a pooled workspace server is used by default and the typical launch credentials are sassrv. If you are running a standard workspace server (the default in SAS 9.1), then the launch credentials are the same ones used to log into SAS Information Map Studio. In SAS Enterprise Guide log in with the appropriate credentials to the server context in which the formats catalog is defined. For example, in SAS 9.2, the server context might be SASApp. Submit the following code, substituting your site-specific information.
If you see the following error, then contact your administrator to request operating-system access to the catalog. ERROR: User does not have appropriate authorization level for file LIBRARY.FORMATS.CATALOG |
||
| Does the format catalog contain user-defined formats that match the type of data item that you have selected? | For example, if you have selected a character data item, then only character formats are displayed. If your catalog does not have any character formats, then the list of formats is blank in SAS Information Map Studio. See the previous information for how to verify the contents of a format catalog. | ||
| Can you launch a workspace server in SAS Information Map Studio? | In order to see formats, your personal credentials (or, possibly, the pooled workspace server credentials) must be able to launch a workspace server. Attempt to test the information map. If the test fails, then contact your system administrator or SAS Technical Support. Inability to launch a workspace server is a separate issue. | ||
| Did you make changes to the sasv9.cfg or sasv9_usermods.cfg configuration file to point to a different catalog or location? | If SAS Information Map Studio was open when you made changes, you must restart SAS Information Map Studio for the changes to be visible. | ||
| Is your FMTSEARCH option correctly set in the sasv9.cfg or sasv9_usermods.cfg configuration file? | In SAS Enterprise Guide, submit the following code in the same workspace server context in which the formats catalog is defined. For example, in SAS 9.2, you might connect to the SASApp server. In SAS 9.1, you might connect to the SASMain server.
Here are some sample results from SAS Enterprise Guide 4.2.
If the library that contains your catalog is not listed, then refer back to SAS Note 40103. |
||
| (Version 4.2 only) Did you log onto SAS Information Map Studio with an internal account? | Internal accounts (formatted as userid@saspw) cannot launch a workspace server. If you are using a standard workspace server (instead of pooled), then you will not be able to see the formats. Use a standard account instead. |
If you have reviewed the remedies in this note and you still cannot see user-defined formats in SAS Information Map Studio, then turn on workspace server logging as explained in SAS Note 34567. Then, attempt to access user-defined formats, and send the resulting log to SAS Technical Support. If you are using SAS 9.1.3, then you must contact SAS Technical Support to request logging instructions.
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Information Map Studio | Microsoft Windows 2000 Advanced Server | 3.1 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows XP Professional | 3.1 | 9.1 TS1M3 SP4 | ||||
| Windows Vista | 3.1 | 9.1 TS1M3 SP4 | ||||
| Windows Vista for x64 | 3.1 | 9.1 TS1M3 SP4 | ||||
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> Information map Data Management ==> Data Sources ==> Metadata Data Management ==> Data Sources ==> SAS catalogs Data Management ==> Manipulation and Transformation ==> User Written Formats SAS Reference ==> Formats ==> Formats SAS Reference ==> System Options ==> FMTSEARCH= System Administration ==> Servers ==> Metadata |
| Date Modified: | 2010-07-05 19:50:33 |
| Date Created: | 2010-07-01 14:50:03 |



