There are two new XML tags that contain debugging options that you can add to the omaconfig.xml file for the SAS^® Metadata Server. These tags are available in SAS^® 9.2, SAS^® 9.3, and SAS^® 9.4.  This note applies to SAS 9.2 and SAS 9.3.  For details on the omaconfig.xml tags in SAS 9.4, refer to SAS 9.4 System Administration - Repair and Analyze Metadata Files Options

<DEBUG ANALYZE_METADATA_FILES="y"/> 

• This tag contains an option that enables you to analyze your SAS Metadata Repository files for damage.​​​​​​

<DEBUG REPAIR_METADATA_FILES="y"/> 

• This tag contains an option that performs the same analysis as the first, but it also immediately repairs many types of corruption that might be present in the SAS Metadata Repository.

Both of the options provide the same functionality as the Verify Metadata Files check box in the  Metadata Analysis and Repair Tools  in SAS^® Management Console.

The analysis or repair occurs during initial start-up of the SAS Metadata Server process. The options are useful, in particular, when the SAS Metadata Server fails to start because of a damaged repository manager or a damaged SAS^® Foundation repository. In this case, you cannot connect to the SAS Metadata Server using SAS^® Management Console to run the Metadata Analysis and Repair Tools.

To use the new XML tags, complete the following steps:

1. Stop the SAS Metadata Server and all other SAS processes in your environment.
2. Make a backup copy of the omaconfig.xml file, which is located in the SAS-configuration-directory/Lev1/SASMeta/MetadataServer/ directory.
3. Open the original file for editing and add one of the two XML tags (directives) to the file immediately following the <OMAconfig> tag.

   Note: It is not necessary to include both tags in your omaconfig.xml file. If you want to only analyze the metadata, use the first directive. If you want to perform both the analysis AND repair, use the second directive.

   For example, if you want to both analyze and repair the metadata, the first three lines of the omaconfig.xml file are similar to the following:

   <?xml version="1.0" encoding="UTF-8"?>
   <OMAconfig>
      <DEBUG REPAIR_METADATA_FILES="y"/>
   . . .more lines. . .
4. Save the file and restart only the metadata server using the following command:
   SAS-configuration-directory/Lev1/SASMeta/MetadataServer/MetadataServer.sh start
5. Observe the metadata server's log file for errors regarding the analysis or the repair.
6. Stop the metadata server and remove the tag from the omaconfig.xml file.

   Do not leave these options in the omaconfig.xml file after the analysis or the repair is completed. Doing so can significantly affect SAS Metadata Server performance.

7. Restart all SAS processes normally. See the  "Overview of Server Operation" section in SAS^® 9.3 Intelligence Platform: System Administration Guide, Second Edition for more information.

Operating System and Release Information