Problem Note 65678: A "Parse Failure" error message occurs in the SAS® log when you use a concatenated library with the SAS® Scalable Performance Data Server
 |  |  |  |  |
When you use a concatenated library in an implicit pass-through query, error messages that are similar to the following appear in the SAS log:
LIBREF \#C00017 ENGOPT="dbq='SPDS52'"
SPDS_NOTE: Correct Syntax for libref statement is:
SPDS_NOTE: LIBREF librefname [ ENGNAME '=' identifier ] [ ENGOPT '=' string ]
SPDS_ERROR: Parse Failure: LIBREF #\#C00017 ENGOPT="dbq='SPDS45' ";
SPDS_NOTE: Correct Syntax for libref statement is:
SPDS_NOTE: LIBREF librefname [ ENGNAME '=' identifier ] [ ENGOPT '=' string ]
SPDS_ERROR: Parse Failure: LIBREF #\#C00017 ENGOPT="dbq='SPDS45' ";
SPDS_ERROR: SQL passthru expression contained errors.
ERROR: SPDS Sql Passthru Error.
12
13 quit;
ERROR: SPDS Sql Passthru Error.
12
13 quit;
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 | HP-UX IPF | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |
| Solaris for x64 | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |||
| Linux for x64 | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |||
| 64-bit Enabled AIX | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |||
| Microsoft® Windows® for x64 | 5.2 HF4 | 5.2 HF5 | 9.4 TS1M3 | |||
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#65678A 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#65678| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-03-10 14:37:50 |
| Date Created: | 2020-03-10 08:47:45 |