Problem Note 36662: Running the Metadata repair utility on a running SAS® Metadata Server might cause corruption
 |  |  |  |
If you run the Metadata Analyze and Repair utility in the Metadata Manager Plug–Ins tab of SAS® Management Console and choose to repair, or if you run the Analyze Metadata batch utility with the –REPAIR option, you should first pause the SAS® Metadata Server to Administration state.
If the SAS Metadata Server is in Online state when the repair is running, there is the possibility that users are also accessing the metadata at the same time. This can cause the repair process to misinterpret the state of the metadata and attempt to repair metadata that is not damaged. This repair can introduce corruption of its own.
Failing to pause the SAS Metadata Server in this manner can result in corruption of your metadata.
Note: while no harm will come to the metadata if only the analysis (without repair) is executed with the server running, it would still be advisable to pause the server to Administrative state when analyzing the metadata. Otherwise, the analysis report may indicate problems that do not truly exist.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | z/OS | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Servers ==> Metadata |
| Date Modified: | 2011-07-20 11:23:48 |
| Date Created: | 2009-07-30 10:14:36 |