1 Topic by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Topic: Error on Dictionary Upgrade 3C to 3E

Hi All,
Yesterday we upgraded our network install of R6 from 6.18 to 6.25.1. This all seems to go fine. We were already running dictionary 3B.

So i then tried to run the 3C to 3E upgrade and get a nasty error:

Error occurred running script 0000003E.sql. The error is described as: The DELETE statement conflicted with the REFERENCE constraint "FK_TAXON_VERSION_TAXON". The conflict occurred in database "NBNData", table "dbo.TAXON_VERSION", column 'TAXON_KEY'.

Anyone any idea of the cause or fix?

At the moment i've restored from backup and R6 is working fine again. But we need to install this and the next dictionary upgrades.

Thanks in advance,
Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website

2 Reply by MikeWeideli

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

Re: Error on Dictionary Upgrade 3C to 3E

It means that your dictionary has got out of step at some time. I can provide a revised version of the script which is causing the problem, but do not have access to it just at the moment. This will provide a temporary solution, but the underlying problem may need some further action. http://forums.nbn.org.uk/viewtopic.php?id=6543

Mike Weideli

MikeWeideli's Website

3 Reply by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Re: Error on Dictionary Upgrade 3C to 3E

Thanks Mike - just sent you an email. I'll get a copy of our DB zipped and loaded onto Dropbox.

Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website