When you run PROC METALIB, you might receive the following message:

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:

1. 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.
2. 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
3. From the Server Manager plug-in, select the Database server noted above. On the right, you should see one or more connections.
4. Open the properties for the Connection noted above, and then click the Options tab.
5. Edit the Credentials Path by appending the Database Schema Name noted above to the end. Here is an example: schema='My-Database-Schema'
6. 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

A fix for this issue for Base SAS 9.4_M6 is available at: