Architecting, installing and maintaining your SAS environment

Metadata Analysis/Repair Question

Reply
Occasional Contributor
Posts: 5

Metadata Analysis/Repair Question

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.

Super User
Posts: 3,260

Re: Metadata Analysis/Repair Question

Posted in reply to sudhir_madhavaram_gmail_com

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.

Ask a Question
Discussion stats
  • 1 reply
  • 406 views
  • 0 likes
  • 2 in conversation