Problem Note 57367: A SAS® 9.4 metadata user bulk load can take many hours to complete when the SAS® Metadata Server is clustered
 |  |  |  |  |
When you import metadata users into a SAS 9.4 Metadata Server that is clustered, the process might take several hours to complete.
The problem occurs when the authorization cache on a particular slave node has already been populated from previous calls to that slave node. The population of the authorization cache occurs as a part of normal metadata server operation and, in general, provides performance improvements.
However, when you encounter this problem, the presence of entries in the authorization cache results in additional processing when the slave node attempts to process the metadata user bulk load updates. The metadata server log files do not log any messages or errors while the processing is taking place. The only symptom you experience is that the user bulk load program takes several hours to complete.
Click the Hot Fix tab in this note to access the hot fix for this issue.
For more information about the user bulk load process, see this documentation on the User Import Macros that are available in SAS® software.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft® Windows® for x64 | 9.4_M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| HP-UX IPF | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Linux for x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Solaris for x64 | 9.4_M2 | 9.4_M4 | 9.4 TS1M2 | 9.4 TS1M4 | ||