1 Reply by boneill (edited by boneill 05-08-2010 14:45:06)

  • boneill
  • boneill
  • Member
  • Offline
  • From: Waterford, Ireland
  • Registered: 08-06-2009
  • Posts: 15

Re: Update of old recorder 6 database

Hi All,
Perhaps someone here has experienced an issue such as this before and has sorted it. I have received an old version of recorder 6. I want to work on the database a bit. So I have backed up the database on the old machine and moved it to my development machine. I have restored it to the sqlserver on my development machine and changed the registry, rebuilt the NBNUser login and so on. This is all fine and I can log onto the old database in recorder on my development machine. The problem comes into play with updates. The database is a very old version 6.7.2.77 dated 16 March 2006. As such I need to run all the updates. I can run updates 0000000 and 0000001 no problem but when I run 0000002, the dictionary upgrade runs away fine for about 2.5hrs and then fails with the following exception

"Access violation at address 004DD769 in module 'DictionaryUpgrade.exe' Read of address 00000000."

I have replicated this error three times and it occurs after a reinstall and a remount of the database backup. The version of the update client that I am running is 6.14.1.202. Is there any compatibility problems between the new client version and very old database?
Thanks,
Barry.

Barry O' Neill, Data &  ICT Manager
National Biodiversity Data Centre, WIT West Campus, Carraiganore, Waterford, Ireland
+353 (0) 51-306247 | boneill@biodiversityireland.ie | http://www.biodiversityireland.ie

boneill's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Update of old recorder 6 database

You needed to run all the Recorder Upgrades since 6.7.2.77 and not just the Dictionary upgrades. The Recorder upgrades make changes to the database structure and add/change functionality with changes to tables, stored procedures etc. The client software  needs to be in line with the installed database.

Ideally you should have started with a 6.7 installation and attached the database to this. Then upgraded Recorder using the appropriate upgrades, checking after each one that Recorder was working. The Dictionary upgrades could  then have been run when all the Recorder upgrades were complete.  You can try running the Recorder upgrades with 6.14a installed, and you may be succesful. however, very often this does not work and it often diificult to find a specific reason why. In these cases it becomes easier to just transfer the data from the old database into the latest version. If you need this done I suggest you contact one of the  JNCC Recorder Experts (resellers)  for advice.

Mike

Mike Weideli

MikeWeideli's Website

3 Reply by boneill

  • boneill
  • boneill
  • Member
  • Offline
  • From: Waterford, Ireland
  • Registered: 08-06-2009
  • Posts: 15

Re: Update of old recorder 6 database

Hi Mike,
Thanks for the reply. I had a feeling that it was something to do with compatibility between the client/upgrader version and the the old version of the database but I said I'd check it before I went back to the old version and ran all the updates. Interestingly enough the new recorder client works fine for viewing and navigating surveys with the old database, it must be some newer stored procedures/functions being called by the client when updating and which are missing from the old database, as you say. Thanks again for the input.
Cheers,
Barry.

Barry O' Neill, Data &  ICT Manager
National Biodiversity Data Centre, WIT West Campus, Carraiganore, Waterford, Ireland
+353 (0) 51-306247 | boneill@biodiversityireland.ie | http://www.biodiversityireland.ie

boneill's Website