Freigeben über

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

  • Artikel

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:

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

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

Comments

  • Anonymous
    July 30, 2009
    Thank You, This resolved my issue!

  • Anonymous
    August 03, 2009
    Your workaround saved me a bunch of time.  Thanks so much!

  • Anonymous
    August 27, 2009
    Thank you! Finally the tool is working!

  • Anonymous
    September 09, 2009
    This is a nice workaround! Helped me!

  • Anonymous
    September 23, 2009
    Great, got the -1 error. Your fix worked.

  • Anonymous
    October 14, 2009
    That fixed worked great!!!!!  Saved a lot of time!  Thanks!

  • Anonymous
    November 11, 2009
    Nice and easy workaround. Save me from the upgrade night!

  • Anonymous
    November 18, 2009
    Count me as another person you helped out of a tight spot. Thanks.

  • Anonymous
    November 23, 2009
    Thank you Thank you Thank you ... It really worked.

  • Anonymous
    December 13, 2009
    you are the man!!! works like a charm.

  • Anonymous
    January 22, 2010
    Thank you, you save me a lot of time!!!

  • Anonymous
    January 31, 2010
    Why no Knowledge Base article for this?

  • Anonymous
    March 02, 2010
    Thank you , you save me a lot of wasted time. and i agree with this Why no Knowledge Base article for this????

  • Anonymous
    March 10, 2010
    Thanks! it resolved my issue!!

  • Anonymous
    March 26, 2010
    Great workaround. Nice and easy!!!

  • Anonymous
    May 04, 2010
    Thank you , I cosign on this fix!!!

  • Anonymous
    July 07, 2010
    thanks allloooooot.... worked instantly

  • Anonymous
    September 13, 2010
    Perfect. Works fine !!!

  • Anonymous
    October 22, 2010
    excellent documentation !!!! this has saved my upgrade time

  • Anonymous
    December 30, 2010
    The comment has been removed

  • Anonymous
    December 30, 2010
    Fantastic workaround!  Thanks very much!!!

  • Anonymous
    March 03, 2011
    Thanks for the workaroun.

  • Anonymous
    May 02, 2011
    Thank you very much. Appreciate your the help!

  • Anonymous
    May 05, 2011
    The comment has been removed

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

  • Anonymous
    January 23, 2012
    Thanks you very much sir!

  • Anonymous
    March 06, 2012
    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.

  • Anonymous
    June 13, 2012
    Thank you so much! This fixed the problem with our upgrade.

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

  • Anonymous
    August 05, 2012
    Thanks fixed!! :-)

  • Anonymous
    November 09, 2012
    THANK YOU!!!!!

  • Anonymous
    January 28, 2013
    Heb tot het laatst gewacht om Davilex upgrade 941 voor Euro 300 aan te schaffen en te downloaden i.v.m. een paar BTW grootboeken die aangepast dienden te worden. Deze afzetterij leidde tot Foutcode 29552. Koop dus een wat beter boukhoudprogramma.

  • Anonymous
    February 05, 2013
    Thanks a lot, it saved a lot of research time.

  • Anonymous
    July 13, 2013
    Awesome! cheers

  • Anonymous
    February 09, 2014

  • one more happy user several years after initial SQL 2000 release..

  • Anonymous
    June 09, 2014
    Excellent. Thanks so much!

  • Anonymous
    May 31, 2015
    Thank you Arvindh. Appreciate your work around!! Cheers!