Article Original Creation Date: 2000-09-06

Problem

Trying to perform an upgrade from offline, the following error message appears:

Unable to upgrade Shadow Tables

Solution

The following are the most common reasons for this error message:

1. Ensure that there is adequate free hard drive space where the databases and the logs are residing.

2. Check the size of the BM, ED, TempDB and make sure that they are large enough, and set to grow. Increase the growth percentage by 5-10 percent.

3. Check the size of the Transaction Log, and make sure it is large enough and set to grow.

4. Ensure 'Truncate Log at Checkpoint' option is set for the Transaction Log. This is a SQL option; This is set in the properties of the ED database in SQL Enterprise Manager, under the Option tab.

This will prevent the transaction log from overflowing. This option can be set back after the UFO has completed.

5. Ensure the RelationshipAdmin and RelationshipUsers groups have been given access to the production and offline BM & ED.

6. Ensure the machine running the UFO process has enough Virtual memory. This should be at least 5X the size of your ED compressed.

7. Run an Audit system on your Production ED, and look for possible error messages.

8. Check the name of the DSM UserID, and the ANM Server in the properties of your Production system in the Relationship Enterprise Manager, and verify that they are correct.

9. Make sure your Offline system name (specified in the properties of the production system) is correct.

10. Run dbcc checkdb in the query analyzer against the BM, ED, master, and tempdb to check for any possible corrupted files.

11. Check the relation.err file in the root of the C drive.

12. If all of the above fails, try backing up your system, and restoring it again.