1 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: Problem adding Measurement to Observation.

Hi,

Can anyone help please. One of our recorders has re-installed Recorder 6.14 on his Vista machine. Re-loaded the data from an NBNData.zip file and all appears OK. However, when he is adding a species record to a sample, all goes well until he tries to add a measurement. At this point the system crashes. The record is created but with no measurement. The same occurs if you go in and try and edit the record to add the required information.
Both Recorder and SQL server Express have been re-installed but to no avail.

Any advice would be gratefully received

Cheers,

Dave (KMBRC)

2 Reply by MikeWeideli

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

Re: Problem adding Measurement to Observation.

Could you plesae let us have the derails of the error message generated. First reaction is that perhaps the databse installed is not in line with the version of Recorder 6 being used.

Mike.

Mike Weideli

MikeWeideli's Website

3 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: Problem adding Measurement to Observation.

Mike

I hope this is the relevant part of the message:

command line      : RecorderApp.exe /394296
executable        : RecorderApp.exe
exec. date/time   : 2009-08-05 13:49
version           : 6.14.4.212
madExcept version : 2.7k
exception class   : EDatabaseError
exception message : Violation of PRIMARY KEY constraint 'PK_TAXON_OCCURRENCE_DATA'. Cannot insert duplicate key in object 'dbo.Taxon_Occurrence_Data'.

I did have a thought, as Measurement is a user maintainable Term List, would this situation occur if the imported data contains measurements not in the table in the clean database? If so, is there an easy way to check this via Taxon_Occurrence_Data and Measurement_Type or Measurement_Unit?

Dave

4 Reply by MikeWeideli (edited by MikeWeideli 07-06-2011 11:27:23)

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

Re: Problem adding Measurement to Observation.

It looks like the import hasn't updated the last key table.  I don't think it ever does,  so this will be the problem. Install the Last_Key addin (if it isn't already in the Tools) menu. Then run this. It should sort the problem.



Mike

Mike Weideli

MikeWeideli's Website

5 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: Problem adding Measurement to Observation.

Thanks Mike,

I will get him to run it and let you know the outcome.

Dave