topic Re: Metadata Analysis/Repair Question in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/Metadata-Analysis-Repair-Question/m-p/189895#M2508 <HTML><HEAD></HEAD><BODY><P>If you do a backup of your metadata repository prior to doing the repair, then if anything goes wrong while repairing you can restore from the backup. All this is easy to do in SMC, although I've never used it with SAS 9.2.</P><P></P><P>To do a metadata backup just right click on Server Backup under your Metadata Manager plug-in.</P></BODY></HTML> Mon, 20 Oct 2014 03:43:16 GMT SASKiwi 2014-10-20T03:43:16Z Metadata Analysis/Repair Question https://communities.sas.com/t5/Administration-and-Deployment/Metadata-Analysis-Repair-Question/m-p/189894#M2507 <HTML><HEAD></HEAD><BODY><P>I have performed metadata analysis/repair on a metadata repository using the tools in management console. Since, this is the first time <STRONG>I am doing this would like to understand if I go ahead and repair using the tool, what kind of impact will it have on my SAS 9.2 environment</STRONG>. The log has following warnings:</P><P>INFO&nbsp; - Analyzing Access Control metadata.</P><P>INFO&nbsp; - Found 597 total Access Control objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 23 orphaned Access Control objects found in repository "Foundation".</P><P>WARN&nbsp; - 23 orphans were found due to missing identities associated to this Access Control.</P><P></P><P>INFO&nbsp; - Analyzing Classifier Map metadata.</P><P>INFO&nbsp; - Found 5,752 total Classifier Map objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 215 orphaned Classifier Map objects found in repository "Foundation".</P><P></P><P>INFO&nbsp; - Analyzing Work Table metadata.</P><P>INFO&nbsp; - Found 3,051 total Work Table objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 2 orphaned Work Table objects found in repository "Foundation".</P><P></P><P>INFO&nbsp; - Analyzing Property Group metadata.</P><P>INFO&nbsp; - Found 537 total Property Group objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 2 orphaned Property Group objects found in repository "Foundation".</P><P></P><P>INFO&nbsp; - Analyzing Property metadata.</P><P>INFO&nbsp; - Found 81,128 total Property objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 454 orphaned Property objects found in repository "Foundation".</P><P></P><P>INFO&nbsp; - Analyzing Text Store metadata.</P><P>INFO&nbsp; - Found 9,357 total Text Store objects.&nbsp; Searching for orphans.</P><P>WARN&nbsp; - 394 orphaned Text Store objects found in repository "Foundation".</P><P></P><P>INFO&nbsp; - **** Begin Analysis Process for repository "Foundation" using tool: Validate SAS Folders Structure</P><P>WARN&nbsp; - Duplicate object found. </P><P>WARN&nbsp; - Duplicate object found. </P><P>WARN&nbsp; - Duplicate object found. </P><P>WARN&nbsp; - Duplicate object found. </P></BODY></HTML> Fri, 17 Oct 2014 17:56:03 GMT https://communities.sas.com/t5/Administration-and-Deployment/Metadata-Analysis-Repair-Question/m-p/189894#M2507 sudhir_madhavaram_gmail_com 2014-10-17T17:56:03Z Re: Metadata Analysis/Repair Question https://communities.sas.com/t5/Administration-and-Deployment/Metadata-Analysis-Repair-Question/m-p/189895#M2508 <HTML><HEAD></HEAD><BODY><P>If you do a backup of your metadata repository prior to doing the repair, then if anything goes wrong while repairing you can restore from the backup. All this is easy to do in SMC, although I've never used it with SAS 9.2.</P><P></P><P>To do a metadata backup just right click on Server Backup under your Metadata Manager plug-in.</P></BODY></HTML> Mon, 20 Oct 2014 03:43:16 GMT https://communities.sas.com/t5/Administration-and-Deployment/Metadata-Analysis-Repair-Question/m-p/189895#M2508 SASKiwi 2014-10-20T03:43:16Z