1 Reply by KCUNN

  • KCUNN
  • Member
  • Offline
  • Registered: 18-03-2007
  • Posts: 10

Re: After Update 6.10 to 6.13 Survey produces error

After updating to 6.13 I am unable to access Surveys. the following error notice appears.

Any suggestions on how to recover this function. Every thing else appears to work ok.

Keith Cunningham

Durham Wildlife Trust


Exception occurred in application Recorder 6 at 21/08/2008 17:08:45.
Version : 6.13.2.176

Exception path:
EOleException : Invalid object name 'Survey_Tag'

Last event\actions:
  actBackup invoked
  actObservations invoked
  TfrmObservations created
  TfrmObservations activated
  TfrmObservations destroyed
  actObservations invoked
  TfrmObservations created
  TfrmObservations activated
  TfrmObservations destroyed

Operating System : Windows XP  5.01.2600  Service Pack 3
Physical Memory available : 753,136 KB

DLLs loaded:
  advapi32.dll (5.1.2600.5512)
  comctl32.dll (5.82.2900.5512)
  comdlg32.dll (6.0.2900.5512)
  gdi32.dll (5.1.2600.5512)
  gdiplus.dll (5.1.3102.5512)
  HHCtrl.ocx (5.2.3790.4110)
  kernel32.dll (5.1.2600.5512)
  mpr.dll (5.1.2600.5512)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1132.0)
  ole32.dll (5.1.2600.5512)
  oleaut32.dll (5.1.2600.5512)
  shell32.dll (6.0.2900.5512)
  user32.dll (5.1.2600.5512)
  version.dll (5.1.2600.5512)
  winmm.dll (5.1.2600.5512)
  winspool.drv (5.1.2600.5512)

Information has been saved to the file C:\Program Files\Recorder 6\User Files\LastError.txt

2 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: After Update 6.10 to 6.13 Survey produces error

I would suggest looking at Tools - Options - General and making sure that the Organise Surveys by Tag box is not ticked as a first option to try to correct this.

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

3 Reply by KCUNN

  • KCUNN
  • Member
  • Offline
  • Registered: 18-03-2007
  • Posts: 10

Re: After Update 6.10 to 6.13 Survey produces error

Thanks Gordon,  I had already carried out your suggestion but it makes no difference whether the box is tagged or not.
Any other ideas

Keith

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: After Update 6.10 to 6.13 Survey produces error

This is an error you get it you try to run R6.13 using a database that hasn't been upgraded.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by KCUNN

  • KCUNN
  • Member
  • Offline
  • Registered: 18-03-2007
  • Posts: 10

Re: After Update 6.10 to 6.13 Survey produces error

Hi Charles,  The version I was upgrading was a standalone 6.10.4  As I understood the instructions this was the most recent version so I used the V13upgrade.zip. I then unzipped it and ran the upgrade.exe file.
The upgrade appeared to work but I am unable to see the surveys and also I cannot enter records.

Have I missed something?

Keith

6 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: After Update 6.10 to 6.13 Survey produces error

It sounds like you've done everything right, but for some reason the database hasn't upgraded itself. Hopefully John van Breda or one of the resellers will be reading this and be able to offer some advice. Or you could contact Mike or Sally, or whoever your reseller is directly.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

7 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: After Update 6.10 to 6.13 Survey produces error

Keith
I agree with Charles - not sure what has caused it but it does sound like your database has not upgraded. What is the value of the DB Seq row in settings. Also - did the upgrade throw any errors and are you certain that the previous upgrade worked alright - ie. that the database you have was definitely upgraded to 6.10?
Steve

8 Reply by KCUNN

  • KCUNN
  • Member
  • Offline
  • Registered: 18-03-2007
  • Posts: 10

Re: After Update 6.10 to 6.13 Survey produces error

Hi Steve,
              Yes I had already checked the database version in settings and realised that it was still at 6.10. Everything else upgraded. I used the 6.10 disc to upgrade from 2002 which has worked pretty well up to now.   

After many hours of work I have now managed to get back to 6.10
I might attempt the upgrade again next week if I am feeling brave.

Keith

9 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: After Update 6.10 to 6.13 Survey produces error

Keith
It would have been really handy to know what the DB Seq value was before you tried to 'downgrade' - I think we could have worked it out from there. Anyway - have another go at upgrading and let us know the value of the other variables in that table if things dont work.
Steve