BookmarkSubscribeRSS Feed
sudhir_madhavaram_gmail_com
Calcite | Level 5

I have performed metadata analysis/repair on a metadata repository using the tools in management console. Since, this is the first time 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. The log has following warnings:

INFO  - Analyzing Access Control metadata.

INFO  - Found 597 total Access Control objects.  Searching for orphans.

WARN  - 23 orphaned Access Control objects found in repository "Foundation".

WARN  - 23 orphans were found due to missing identities associated to this Access Control.

INFO  - Analyzing Classifier Map metadata.

INFO  - Found 5,752 total Classifier Map objects.  Searching for orphans.

WARN  - 215 orphaned Classifier Map objects found in repository "Foundation".

INFO  - Analyzing Work Table metadata.

INFO  - Found 3,051 total Work Table objects.  Searching for orphans.

WARN  - 2 orphaned Work Table objects found in repository "Foundation".

INFO  - Analyzing Property Group metadata.

INFO  - Found 537 total Property Group objects.  Searching for orphans.

WARN  - 2 orphaned Property Group objects found in repository "Foundation".

INFO  - Analyzing Property metadata.

INFO  - Found 81,128 total Property objects.  Searching for orphans.

WARN  - 454 orphaned Property objects found in repository "Foundation".

INFO  - Analyzing Text Store metadata.

INFO  - Found 9,357 total Text Store objects.  Searching for orphans.

WARN  - 394 orphaned Text Store objects found in repository "Foundation".

INFO  - **** Begin Analysis Process for repository "Foundation" using tool: Validate SAS Folders Structure

WARN  - Duplicate object found.

WARN  - Duplicate object found.

WARN  - Duplicate object found.

WARN  - Duplicate object found.

1 REPLY 1
SASKiwi
PROC Star

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.

To do a metadata backup just right click on Server Backup under your Metadata Manager plug-in.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1289 views
  • 0 likes
  • 2 in conversation