By default, SAS 9.4 Metadata Server is configured to run a scheduled metadata backup daily at 1:00 AM. The backup that is scheduled for Mondays at 1:00 AM is configured to be a backup with the Reorganize repositories option enabled. This option reclaims unused disk space that is left from previously deleted metadata objects.
If a certain sequence of events occurs before a metadata backup with the Reorganize repositories option enabled, then the metadata server's Foundation repository might become corrupted. This problem can occur in that scenario (with Reorganize repositories enabled for a scheduled metadata backup) or with an ad hoc metadata backup. The corruption that is described in this note does not occur when you take a metadata backup without Reorganize repositories enabled.
The following sections describe the corruption problem for SAS® in general and also for SAS® Enterprise Guide®.
This section describes a series of steps that can lead to a corrupted Foundation repository.
2015-05-14T15:53:32,870 ERROR [00000206] 4:sasdemo - A Login for UserID SASDEMO on Identity sasdemo is already associated to AuthenticationDomain DefaultAuth.
Note: You need to complete this step with a client other than SAS® Management Console. For example, the message that is shown above was generated using the Login Manager feature of SAS Enterprise Guide. You access Login Manager in SAS Enterprise Guide by selecting Tools ► SAS Enterprise Guide Explorer ► File ► Manage Logins ►Add. Select an authentication domain and enter a user ID (which already exists for the user). In this example, those values are DefaultAuth and sasdemo.
Note: You can perform this action from any client (including SAS Management Console) that enables you to update SAS identities.
2015-05-14T16:10:09,070 WARN [00001249] :sas - The ID registry appears to be out of sync with the current ID cache contents. Used IDs (34383) don't match expected (33383) during reclaim. 2015-05-14T16:10:09,070 WARN [00001249] :sas - The ID registry appears to be out of sync with the current ID cache contents. Used IDs (9) don't match expected (-991) during reclaim. 2015-05-14T16:10:09,070 INFO [00001249] :sas - NOTE: This transaction has been journalled but will not be applied to the permanent repository until the in progress backup is completed and journal reload is performed. Journal entry number 2238. ...... 2015-05-14T16:10:09,213 ERROR [00001249] :sas - The mdassoc container in the Foundation repository has an error in its ID registry entry, because the highest container ID is A3000QJ3 which exceeds the ID registry value of A3000QIV. An administrator should analyze and repair this repository. ...... 2015-05-14T16:10:09,215 ERROR [00001249] :sas - Repository Foundation is not properly initialized. Look for details earlier in the server log. An administrator should analyze and repair this repository. 2015-05-14T16:10:09,215 WARN [00001249] :sas - The Foundation repository could not be opened. ...... 2015-05-14T16:10:09,409 WARN [00001249] :sas - Repository Foundation is not properly initialized. Look for details earlier in the server log. An administrator should analyze and repair this repository. 2015-05-14T16:10:09,410 INFO [00001249] :sas - *** FOMSworkunitReloadJournal: Errors encountered while replaying of journal entry 2238 have terminated the replay. 2015-05-14T16:10:09,410 INFO [00001249] :sas - Journal Reload complete. 0 entries with entry numbers from 0 to 0. 2015-05-14T16:10:09,410 INFO [00001249] :sas - The journal could not be fully reloaded because of errors noted above. 2015-05-14T16:10:09,410 INFO [00001249] :sas - Correct any conditions that you can and attempt to start the server again. 2015-05-14T16:10:09,410 ERROR [00001249] :sas - Journal reload has failed ...... 2015-05-14T16:10:09,490 INFO [00001249] :sas - The Backup has completed successfully.
This section lists details and steps, specific to SAS Enterprise Guide, that can lead to a corrupted Foundation repository.
2015-05-14T15:53:32,870 INFO [00000206] 4:myuserid - AddMetadata return code=807fe99d.... 2015-05-14T15:53:32,870 ERROR [00000206] 4:myuserid - A Login for UserID MYUSERID on Identity myuser is already associated to AuthenticationDomain SampleAuth.
When you complete these steps, the metadata-server log displays the same messages as those in step 4 of the first section, Corruption Problem in the Foundation Repository.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Metadata Server | Microsoft® Windows® for x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 |
Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows 8 Pro x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Pro | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2008 R2 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Microsoft Windows Server 2012 Std | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Windows 7 Enterprise x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Windows 7 Professional x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
64-bit Enabled AIX | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
64-bit Enabled Solaris | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
HP-UX IPF | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Linux for x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 | ||
Solaris for x64 | 9.4 | 9.4 | 9.4 TS1M0 | 9.4 TS1M3 |
A fix for this issue for Base SAS 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R19.html#55945A fix for this issue for Base SAS 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M88.html#55945Type: | Problem Note |
Priority: | medium |
Date Modified: | 2015-06-12 15:07:35 |
Date Created: | 2015-06-05 16:29:23 |