Problem Note 67427: The METALIB procedure returns the error "Invalid connection string attribute : SCHEMA is required for this datasource"
When you run PROC METALIB, you might receive the following message:
ERROR: CLI error trying to establish connection: Invalid connection string attribute : SCHEMA is required for this datasource
The error occurs when all of these conditions are met:
- The database is Google BigQuery.
- SCHEMA is specified as a LIBNAME statement option.
- Hot Fix H5A003 has been applied to the system that is executing PROC METALIB.
The error occurs because PROC METALIB omits SCHEMA from the database connection options.
The error does not occur in other uses of the database, such as when accessing a table via a LIBNAME statement connection.
Circumvention
As a circumvention, append schema='My-Database-Schema' to the Credentials Path value in the server object's connection properties. Note that you should replace My-Database-Schema with your database scheme name in the string you append. This change ensures that SCHEMA is included when PROC METALIB uses the credentials path in its database connection, thus avoiding the error.
Here are the steps to use this circumvention:
- From within the Data Library Manager plug-in in SAS® Management Console, open the Library object's properties, and then click the Data Server tab.
- Make note of the values for the following fields, and then click Cancel to close the properties window. These values are needed for the next steps.
- Database server
- Database Schema Name
- Connection
- From the Server Manager plug-in, select the Database server noted above. On the right, you should see one or more connections.
- Open the properties for the Connection noted above, and then click the Options tab.
- Edit the Credentials Path by appending the Database Schema Name noted above to the end. Here is an example: schema='My-Database-Schema'
- Click OK to save and close the properties.
Here is an example of the Credentials Path after adding the SCHEMA option:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | z/OS | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
z/OS 64-bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft® Windows® for x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8 Enterprise 32-bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8 Enterprise x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8 Pro 32-bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8 Pro x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8.1 Enterprise x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8.1 Pro 32-bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 8.1 Pro x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows 10 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2008 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2008 R2 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2008 for x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2012 Datacenter | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2012 R2 Datacenter | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2012 R2 Std | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2012 Std | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2016 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Microsoft Windows Server 2019 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Enterprise 32 bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Enterprise x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Home Premium 32 bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Home Premium x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Professional 32 bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Professional x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Ultimate 32 bit | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Windows 7 Ultimate x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
64-bit Enabled AIX | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
64-bit Enabled Solaris | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
HP-UX IPF | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Linux for x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
Solaris for x64 | 9.4_M6 | 9.4_M7 | 9.4 TS1M6 | 9.4 TS1M7 |
*
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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2021-02-19 09:39:26 |
Date Created: | 2021-02-12 18:27:26 |