Problem Note 62713: A WHERE clause with a user-defined format causes a ". . . Libname path info not found . . ." error for SAS® Scalable Performance Data Server
 |  |  |  |  |
When you submit a WHERE clause that contains a user-defined format, the format should be defined in the FORMATS domain in the libnames.parm parameter file. If the user-defined format is not defined in that file, SAS Scalable Performance Data Server can fail with the following error in the server log:
SPDS_ERROR: Libname path info not found in SPD Name Server
That error did not appropriately identify the issue. The following errors now appear to guide you toward how to resolve this issue:
SPDS_ERROR: Cannot connect to domain FORMATS.
SPDS_ERROR: Format $format-name could not be loaded.
SPDS_ERROR: SQL passthru expression contained errors.
ERROR: SPDS Sql Passthru Error.
SPDS_ERROR: Format $format-name could not be loaded.
SPDS_ERROR: SQL passthru expression contained errors.
ERROR: SPDS Sql Passthru Error.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 |
| Microsoft Windows Server 2008 for x64 | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| HP-UX IPF | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Linux for x64 | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Solaris for x64 | 5.3 HF1 | 5.4 HF1 | 9.4 TS1M3 | 9.4 TS1M5 | ||
A fix for this issue for SAS Scalable Performance Data Server 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9A.html#62713A fix for this issue for SAS Scalable Performance Data Server 5.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A3J.html#62713| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-10-16 10:01:57 |
| Date Created: | 2018-08-03 14:56:24 |