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

 


Comments (37)

  1. Steve Knowles says:

    Thank You, This resolved my issue!

  2. Stephen Jordan says:

    Your workaround saved me a bunch of time.  Thanks so much!

  3. Maria J Santos says:

    Thank you! Finally the tool is working!

  4. Martin Henriksen says:

    This is a nice workaround! Helped me!

  5. Dave says:

    Great, got the -1 error.

    Your fix worked.

  6. Tracy says:

    That fixed worked great!!!!!  Saved a lot of time!  Thanks!

  7. Ms. SQL says:

    Nice and easy workaround. Save me from the upgrade night!

  8. Mike says:

    Count me as another person you helped out of a tight spot. Thanks.

  9. Manu says:

    Thank you Thank you Thank you … It really worked.

  10. louis says:

    you are the man!!!

    works like a charm.

  11. kristof says:

    Thank you, you save me a lot of time!!!

  12. Joe says:

    Why no Knowledge Base article for this?

  13. cool_develop says:

    Thank you , you save me a lot of wasted time.

    and i agree with this

    Why no Knowledge Base article for this????

  14. Enam says:

    Thanks! it resolved my issue!!

  15. Thierry says:

    Great workaround. Nice and easy!!!

  16. Marc C. says:

    Thank you , I cosign on this fix!!!

  17. danny says:

    thanks allloooooot…. worked instantly

  18. Jaime González Gjordan says:

    Perfect. Works fine !!!

  19. avadhut says:

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

  20. Mark W says:

    This has saved me a smeg load of hassle much thanks

  21. Ian Hansen says:

    Fantastic workaround!  Thanks very much!!!

  22. Krishna Rao says:

    Thanks for the workaroun.

  23. Joe M says:

    Thank you very much. Appreciate your the help!

  24. MM says:

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

  25. SQL Upgrader says:

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

  26. Jeremy Weisser says:

    Thanks you very much sir!

  27. Ken 2 says:

    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.

  28. Brian says:

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

  29. Lee Horne says:

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

  30. Steve says:

    Thanks fixed!! 🙂

  31. Vanesa says:

    THANK YOU!!!!!

  32. Kees Klavers says:

    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.

  33. Ivan Santana says:

    Thanks a lot, it saved a lot of research time.

  34. Kazido says:

    Awesome! cheers

  35. Tom says:

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

  36. Jan-Ole says:

    Excellent. Thanks so much!

  37. Anonymous says:

    Thank you Arvindh. Appreciate your work around!! Cheers!