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: https://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 https://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:
-------------
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