Microsoft KB Archive/199104

= BUG: Exiting the Upgrade Wizard During Validation Causes Errors =

Article ID: 199104

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: upgrade wizard verify data validate error err msg message

Keywords: kbbug kbpending KB199104

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.