Metadata might become corrupted for a variety of reasons. Here are some tasks that might help avoid and indentify these corruptions:

• Avoid forcing termination of the metadata server SAS process by stopping the task. Abnormal termination of the metadata server might cause damage to the repository data sets.
• Monitor metadata server logs regularly for unusual errors or warnings. If some event occurs that causes corruption of metadata, you have a better chance of recovering quickly and with minimal loss of metadata if you identify the problem as soon as it occurs.
• Consider implementing workunit journaling. Workunit journaling causes the metadata server to post updates to the memory copy of repositories immediately, and to queue disk updates to a high–speed workunit journal file until the CPU is available to apply the updates to disk. If the metadata server fails before the update process has had a chance to apply all updates from the workunit journal buffer to repositories, the metadata server automatically recovers them from the workunit journal file when it is restarted. Refer to Chapter 13 in the SAS^® 9.1.3 Intelligence Platform System Administration Guide for more information on workunit journaling
.

If you experience errors relating to corrupted metadata data sets, you can try to repair the data sets by performing the following steps:

1. Stop your metadata server.
2. Submit the following program in a SAS session:
   /*Supply the path to the repository*/ libname repos 'Fully qualified path to metadata repository'; options DLDMGACTION=REPAIR; proc datasets library=repos; contents data=_all_; run; quit;
3. Restart the metadata server and check the log for corruption errors.

If the data sets cannot be repaired using the program above, contact SAS Technical Support and provide copies of your metadata server log and the output from the PROC DATASETS step from the above program. In extreme circumstances, SAS Technical Support might request a copy of your metadata repositories.

Operating System and Release Information