SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 56354: The error "Invalid option name. . ." occurs when you use the METALIB procedure

DetailsHotfixAboutRate It

PROC METALIB generates the following error message:

ERROR: Invalid option name special-character

This error occurs when you have the DBUSER= and DBPASSWORD= options in the DBAUTH statement, and one or both of these options contain a special character in the option value.

For example, you might have a METALIB procedure with the following DBAUTH statement:

proc metalib;
   omr(library="oralib_prompt");
   select(dept);
   dbauth(dbuser=scott dbpassword="tiger@mycompany");
run;

In this example, the special character @ appears in the DBPASSWORD value.

To circumvent the problem, create database user IDs and passwords that do not contain special characters.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Metadata ServerMicrosoft Windows Server 2012 R2 Datacenter9.4 TS1M09.4 TS1M3
Microsoft Windows Server 2012 Datacenter9.4 TS1M09.4 TS1M3
Microsoft Windows Server 2008 for x649.4 TS1M09.4 TS1M3
Microsoft Windows Server 2008 R29.4 TS1M09.4 TS1M3
Microsoft Windows 8.1 Pro 32-bit9.4 TS1M09.4 TS1M3
Microsoft Windows 8.1 Pro9.4 TS1M09.4 TS1M3
Microsoft Windows 8.1 Enterprise x649.4 TS1M09.4 TS1M3
Microsoft Windows 8.1 Enterprise 32-bit9.4 TS1M09.4 TS1M3
Microsoft Windows 8 Pro x649.4 TS1M09.4 TS1M3
Microsoft Windows 8 Enterprise x649.4 TS1M09.4 TS1M3
z/OS9.4 TS1M09.4 TS1M3
Microsoft® Windows® for x649.4 TS1M09.4 TS1M3
Solaris for x649.4 TS1M09.4 TS1M3
Linux for x649.4 TS1M09.4 TS1M3
Microsoft Windows Server 2012 R2 Std9.4 TS1M09.4 TS1M3
HP-UX IPF9.4 TS1M09.4 TS1M3
64-bit Enabled Solaris9.4 TS1M09.4 TS1M3
64-bit Enabled AIX9.4 TS1M09.4 TS1M3
Windows 7 Professional x649.4 TS1M09.4 TS1M3
Windows 7 Enterprise x649.4 TS1M09.4 TS1M3
Microsoft Windows Server 2012 Std9.4 TS1M09.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.