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

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

  • Comments 36

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

 

Leave a Comment
  • Please add 7 and 7 and type the answer here:
  • Post
  • Thank you , I cosign on this fix!!!

  • thanks allloooooot.... worked instantly

  • Perfect. Works fine !!!

  • excellent documentation !!!! this has saved my upgrade time

  • This has saved me a smeg load of hassle much thanks

  • Fantastic workaround!  Thanks very much!!!

  • Thanks for the workaroun.

  • Thank you very much. Appreciate your the help!

  • Thank you. The error was really annoying. Your post saved my a$$. Thanks a bunch!

  • Thank you so much for posting this!  I searched for hours and this was the exact fix to my issue.  Many thanks!

  • Thanks you very much sir!

  • I just got the -1 error when installing SQL Express 2005 SP4. This fix worked and this is the only place I found it. Is this a defect with the installer? Thank you very much.

  • Thank you so much! This fixed the problem with our upgrade.

  • Dozens of times I have struggled with this. Finally a solution that works (quickly) thank you!

  • Thanks fixed!! :-)

Page 2 of 3 (36 items) 123