BUG: Exiting the Upgrade Wizard During Validation Causes Errors (199104)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q199104
BUG #: 52634 (SQLBUG_70)

SYMPTOMS

When upgrading a SQL Server 6.5 database to SQL Server 7.0, if the Validate successful object data transfer option is selected and the Upgrade Wizard is closed during data validation, an informational error file is displayed when the upgrade later resumes.

This error file contains messages such as:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'objects'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tempdb.dbo.objects'.

CAUSE

The Upgrade Wizard stores data validation information in a temporary table in tempdb. When the Upgrade Wizard is closed, SQL Server is stopped. When the upgrade then resumes, SQL Server is restarted and tempdb is re-created; thus resulting in the loss of previously gathered data validation information.

WORKAROUND

To work around this problem, do not stop the Upgrade Wizard during the data verification process. Instead, pause and resume the upgrade without closing the application.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

MORE INFORMATION

Although this problem will not prevent the upgrade from completing successfully, the missing tables in tempdb prevent data validation from completing after the upgrade process is resumed.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB199104
©2002 Microsoft Corporation. All rights reserved.