Re: Network upgrade from 6.9.3 to 6.10.4 and R2002 to R6 transfer
I thought I’d share my experiences with uninstalling R6.9.3, installing 6.10.4 network upgrade from the CD and transferring data from R2002, as the feedback may be helpful:
1) I uninstalled 6.9.3 and MSDE, then checked that R2002 was still working okay – it wasn’t. Four of the addins were missing and I also got the following error transcript:
Exception occurred in application Recorder 2002 at 23/08/2007 10:18:54.
Version : 2.3.7.8
Exception path:
EAccessViolation : Access violation at address 00779AC3 in module 'Recorder2000.ex_'. Read of address 0000000C
Last event\actions:
actLocations invoked
Operating System : Windows 2000 5.00.2195 Service Pack 4
Physical Memory available : 1,048,096 KB
DLLs loaded:
advapi32.dll (5.0.2195.7038)
comctl32.dll (5.81.4968.2500)
comdlg32.dll (5.0.3700.6693)
gdi32.dll (5.0.2195.7138)
HHCtrl.ocx (5.2.3790.620)
kernel32.dll (5.0.2195.7135)
mpr.dll (5.0.2195.7134)
MS4.Dll (5.0.0.1)
MS4User.dll (4.0.0.3)
ole32.dll (5.0.2195.7059)
oleaut32.dll (2.40.4531.0)
shell32.dll (5.0.3900.7105)
user32.dll (5.0.2195.7133)
version.dll (5.0.2195.6623)
winmm.dll (5.0.2161.1)
winspool.drv (5.0.2195.6659)
wsock32.dll (5.0.2195.6603)
After re-installing the four addins, R2002 appears to be running okay again (fingers crossed) and the above transcript hasn’t recurred.
2) I installed 6.10.4 network upgrade from the CD onto my PC (acting as the server), firstly doing the R6 server install, then the workstation setup. This was uneventful.
3) After completing the workstation install it took me to a main menu which included the R2002->R6 transfer option, which I selected. After answering all the questions and hitting the Transfer button I instantly got a dialogue saying ERROR: “The operation completed successfully”, which was obviously an error in itself!
4) I therefore switched to trying the R2002->R6 transfer option on the CD’s auto-run menu. After stepping through the Login Settings, then the Transfer Settings dialogues and hitting Next I got the Login Settings again, following by the Transfer Settings, then the Login Settings, then the Transfer Settings,…!
5) After giving up on that method I went back to the R2002->R6 transfer option on the workstation setup and this time I didn’t get the error message and the transfer occurred, taking about 45 minutes to transfer 532,170 species observations.
At (or near) the end of this transfer, after copying lots of files (rucksacks etc.) I got an “Invalid floating point operation” and a set of summary statistics flashed briefly before Windows killed off the application. Not sure if it completed successfully? (Sally has suggested things for me to check).
6) I looked at the size of the NBNData_Data.MDF file and it is 2,073,536KB, i.e. only 24MB below the 2G limit!
I have 532,170 species observations in R2002 and the whole of its Database folder’s contents (database, dictionaries, etc.) totals only 901,748KB. i.e. in transferring to R6 the size of the equivalent databases has more than doubled! Is this supposed to happen? (The R2002 nbndata.mdb file is 365,424KB).
I am therefore fearing that I’ll immediately have to switch to the unsupported SQL Server 2005 Express…?
7) I looked at the UpgradeErrors. These fell into two categories:
a) Those caused by NBNSYS, NHMSYS and JNCC related references that Sally says I can ignore, and
b) MEASUREMENT_QUALIFIER term list items that I’d added for “Sett”, “Queen”, “Nymph”, etc. which had failed to transfer across to R6. They are marked with “-1” in the SYSTEM_SUPPLIED_DATA field in R2002. I think the Import Wizard added these, so it probably set the flag wrongly when doing so. I’ll need to edit these to 0 and try again…
8) R6 appears to be running and I haven’t tested or explored it thoroughly yet, but…
a) I did notice that the “Report” button on the Locations window is missing and isn’t amongst the addins provided. Sally said this button is intended to be missing and is replaced by an xml report equivalent, but the one provided isn’t a patch on the button in R2002 which provides a neatly formatted report and I use a dozen times a day! Is there an equivalent in R6 that I haven't found yet? If not, can we have the button back please?
b) In order to specify taxon abundances in the report wizard I seem to need to tick 33 boxes to cover all the different possible types and then get 33 columns in the report grid! In R2002 I get two columns, the abundance and its qualifier, which is what I actually want. Is the R2002 equivalent available somehow?
As someone that does daily reports for consultants both of the above seem retrograde steps, reducing my efficiency and the service provided.
9) When will the dictionaries for R2002 be updated?
Regards,
Keith Balmer
Beds and Luton LRC