locked
SQL Server 2005 Upgrade Advisor fails with (system.io.filenotfoundexception) error message... RRS feed

  • Question

  • Hello,

    Here is my current status that may help you in evaluating this problem which I cannot figure out, they are as follows:

    1. OS: Windows XP SP3 (fully updated); production database is runned in windows server 2003 sp1
       - 60g of space left

    2. Instance: ACE1\SQL2K
        - VERSION: 2000.80.2039
        note: There are 3 editions on this machine (2000, 2005, 2008)

    3. Database: {dbname}
        - sizes
           - database: 4.65g
           - transaction log: 1.5g

    4. Installed Microsoft SQL Server 2005 Upgrade Advisor (date 4/18/2006)
        note: This version has worked previously on SQL Server 2000 databases

    5. Running Upgrade Wizard recieved the following errors:
        - SQL BPA command line has encountered a problem and needs to close.  We are sorry for the inconvenience.

    6. Upon further investigation and looking at what the error report contains:
        - EventType : clr20r3     P1 : bpacmd.exe     P2 : 2005.90.2047.0    
    P3 : 443f5935     P4 : bpacmdx     P5 : 9.0.242.0     P6 : 443f5932     P7 : 7
    P8 : 7a     P9 : system.io.filenotfoundexception    

    7. after further debugging received the following:
        - after debug received the following:
    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.
    FileNotFoundException was unhandled

    8. copied exception handling error information below:
        - copied exception details:
    System.IO.FileNotFoundException was unhandled
      Message="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."
      Source="BpaCmdX"
      FileName="BPAClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
      FusionLog="WRN: Assembly binding logging is turned OFF.\r\nTo enable assembly bind failure logging, set the registry value [HKLM\\Software\\Microsoft\\Fusion!EnableLog] (DWORD) to 1.\r\nNote: There is some performance penalty associated with assembly bind failure logging.\r\nTo turn this feature off, remove the registry value [HKLM\\Software\\Microsoft\\Fusion!EnableLog].\r\n"
      StackTrace:
           at Microsoft.SqlBpa.BpaCmd.BpaCmd.MainEntry()
           at main(Int32 argc, SByte** argv)
           at _mainCRTStartup()
    {"Could not load file or assembly

    Don't know what else to do, I would like to use this product to assist in upgrade this database to SQL Server 2005.

    Thanks,
    mray.1962

    Thursday, May 14, 2009 10:18 PM