1 Topic by BDeed

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 446

Topic: 6.26.2 Upgrade error

In the process of bringing our R6 up to date and have hit a snag, running the 6.26.2 update fails with an error;

date/time         : 2017-03-22, 16:03:08, 701ms
computer name     : CZC5233PZX
user name         : BioBank <admin>
operating system  : Windows NT New x64 build 9200
system language   : English
system up time    : 1 day 6 hours
program up time   : 19 seconds
processors        : 4x Intel(R) Core(TM) i5-4590 CPU @ 3.30GHz
physical memory   : 4191/8098 MB (free/total)
free disk space   : (C:) 235.57 GB
display mode      : 1280x1024, 32 bit
process id        : $1fd8
allocated memory  : 39.89 MB
executable        : RecorderUpgrade.exe
exec. date/time   : 2017-03-22 15:57
version           : 6.25.1.276
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $f69342f9, $eff95fdc, $eff95fdc
exception number  : 1
exception class   : EDBUpgraderError
exception message : Error occurred running script 000000AV.sql. The error is described as: Cannot use DROP PROCEDURE with 'dbo.NATIVE_VIEW' because 'dbo.NATIVE_VIEW' is a view. Use DROP VIEW.


I'm upgrading from 6.25.1 and have just finished upgrading the dictionary to 3T and have re-built the tables. I'm running the upgrade from the host fileserver (Windows 10) using an admin account.

Do I need to try and go to 6.26.1 first?

Natural History & Biodiversity Data Enthusiast

2 Reply by MikeWeideli

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

Re: 6.26.2 Upgrade error

I think the ability to report on Native Species must have been made available on the Forum and the upgrade script is not removing it correctly before adding it again.

Please can you a replace script 000000AV.sql in the scripts folder with the attached.

Post's attachments

000000AV.sql 2.29 kb, 5 downloads since 2017-03-22 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

3 Reply by BDeed (edited by BDeed 22-03-2017 16:53:48)

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 446

Re: 6.26.2 Upgrade error

Cheers Mike I did request an update for flagging native species a while back. I've just tried it with the file you attached and it's still failing with the same error.

*there don't seem to be any difference in the sql?*

Natural History & Biodiversity Data Enthusiast

4 Reply by MikeWeideli

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

Re: 6.26.2 Upgrade error

Hi

Please can you try dowloading it again. I think I must have uploaded the wrong version. This problem should only affect users who have loaded the script from the Forum.

Mike Weideli

MikeWeideli's Website

5 Reply by BDeed

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 446

Re: 6.26.2 Upgrade error

That's worked perfectly, thanks again Mike.

Natural History & Biodiversity Data Enthusiast