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
