Upgrade advisor returns error while upgrading an instance of SQL Server 2000 to SQL Server 2005.

Problem description:

Upgrade advisor returns error while upgrading an instance of SQL Server 2000 to SQL Server 2005.

Cause:

The error occurs because of a problem with BPACMD.EXE attempting to load BPAClient.dll. While upgrading the instance of SQL Server the setup looks for the BPAClient.dll and it fails as it is not able to find it at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA.

We get the following error:

Scenario-1: While choosing an instance from the installed instances and choosing one of them to upgrade.

Error:
=====
TITLE: Microsoft SQL Server Setup
------------------------------
UpgradeAdvisor returned  -1 .

Error message:

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=29552

------------------------------
BUTTONS:
OK
------------------------------
Application Log Error:
===============

Event Type:        Error
Event Source:     .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID:            5000
Date:                 7/14/2009
Time:                8:24:09 PM
User:                 N/A
Computer:         ARVINDH

Description:

EventType clr20r3, P1 bpacmd.exe, P2 2005.90.3042.0, P3 45cd7182, P4 bpacmdx, P5 9.0.242.0, P6 45cd717f, P7 7, P8 7a, P9 system.io.filenotfoundexception, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Setup Log:
=========

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Files\SQLSetup0003_ARVINDH_WI.log

=========
MSI (c) (AC:4C) [20:24:07:204]: Doing action: RunUpgradeAdvisorDlg
Action 20:24:07: RunUpgradeAdvisorDlg. Running Upgrade Advisor
Action start 20:24:07: RunUpgradeAdvisorDlg.
MSI (c) (AC:4C) [20:24:07:204]: Note: 1: 2235 2:  3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'RunUpgradeAdvisorDlg'
MSI (c) (AC:B0) [20:24:07:220]: Invoking remote custom action. DLL: C:\DOCUME~1\arkali\LOCALS~1\Temp\MSI81.tmp, Entrypoint: RunUpgradeAdvisorDlg

:

:

:

MSI (c) (AC!EC) [20:24:14:876]: PROPERTY CHANGE: Modifying SqlLogMessage property. Its current value is 'Message type: Progress'. Its new value: '100'.
MSI (c) (AC!EC) [20:24:17:017]: PROPERTY CHANGE: Modifying SqlLogMessage property. Its current value is '100'. Its new value: 'UpgradeAdvisor.returned 4294967295'.
MSI (c) (AC!EC) [20:24:17:017]: PROPERTY CHANGE: Modifying SqlLogMessage property. Its current value is 'UpgradeAdvisor.returned 4294967295'. Its new value: '        Error Code: 0x80077370 (29552)

Windows Error Text:   Source File Name: sqlca\sqlguica.cpp
Compiler Timestamp: Mon Aug 29 01:18:41 2005

     Function Name: IsUpgradeBlocked

Source Line

Scenario-2: While running upgrade advisor exclusively.

Log from DE.log :

=============

C:\Documents and Settings\Administrator\Application Data\Microsoft\SQL Server 2005

Upgrade Advisor\log\DE.log

=============

09/26/2008 19:22:47 DE <Message>Initializing Process object</Message>

09/26/2008 19:22:47 DE <Message>Invoking process</Message>

09/26/2008 19:22:47 DE <Message>Attaching output and error streams</Message>

09/26/2008 19:22:47 DE <Message>Processing output and error streams</Message>

09/26/2008 19:22:50 DE <Message>An error has ocurred: </Message>

09/26/2008 19:22:52 DE <Message>System.IO.FileNotFoundException: Could not load

file or assembly 'BPAClient, Version=9.0.242.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find

the file specified.

File name: 'BPAClient, Version=9.0.242.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91'

at Microsoft.SqlBpa.BpaCmd.BpaCmdExecutionContext..ctor(String

pathToApplicationBinFolder, ResourceManager resMgr)

at

Microsoft.SqlBpa.BpaCmd.BpaCmd.ConfigureAppDomainsAndCreateExecutionContext(</Message>

09/26/2008 19:22:52 DE <Message>)

at Microsoft.SqlBpa.BpaCmd.BpaCmd.MainEntry()

Scenario 3:

-------------

Refer: http://blogs.technet.com/isablog/archive/2009/03/16/sql-server-2005-express-edition-service-pack-3-fails-to-install-on-a-tmg-machine.aspx

 

Workaround:

Copy the BPAClient.dll file from the following location C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA.

Arvindh Kalidasan
Support Engineer, Microsoft SQL Server

Reviewed by

Levi Justus
Technical Lead, Microsoft SQL Server