Problem Note 65712: The "Register Tables" or "Update Metadata" function can fail with the error message "Invalid connection options. Lack USER option."
 |  |  |  |  |
The Register Tables and Update Metadata functions in SAS® Management Console and SAS® Data Integration Studio can fail with the following error for the METALIB procedure:
This error occurs when the following conditions are true:
- You attempt to perform the Register Tables or Update Metadata function for tables within a database or library, which requires authorization or credentials.
- You log in to the SAS Management Console or SAS Data Integration Studio client with a user ID that has access to metadata-stored credentials for that library or database.
- Your user ID that launches the SAS® Application Server session is not the same user ID that you use to log in to the client.
- Your user ID that launches the SAS Application Server session does not have access to metadata-stored credentials for that library or database.
These conditions result in a situation where the client verifies that you have access to metadata-stored credentials for the library or database (so that it does not then prompt for database credentials). Then the client submits PROC METALIB without any embedded credentials because it expects the same credentials will be available at the time of code execution. If you launch a SAS Application Server session where code is executing and your user ID for that session does not have the same access to metadata-stored credentials, the process fails.
The workaround for this issue is to ensure that you use the same user ID with relevant credentials both to connect to the client and to launch the SAS Application Server session.
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* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 |
| Microsoft Windows 8 Enterprise 32-bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro 32-bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 10 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Datacenter | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2016 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2019 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise 32 bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium 32 bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional 32 bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate 32 bit | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate x64 | 4.904 | 4.905 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| SAS System | SAS Management Console | 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 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 | ||
A fix for this issue for SAS Management Console 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8N.html#65712A fix for this issue for Data Integration Studio 4.904 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#65712A fix for this issue for SAS Middle Tier 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8T.html#65712| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-03-30 16:02:05 |
| Date Created: | 2020-03-19 16:44:55 |