1 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Error whilst running the (unnannounced?) upgrade - 

date/time         : 2012-01-17, 15:57:41, 884ms
computer name     : LBP2
user name         : charliebarnes <admin>
registered owner  : User
operating system  : Windows 7 build 7600
system language   : English
system up time    : 6 hours 53 minutes
program up time   : 19 seconds
processors        : 2x Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
physical memory   : 1371/3037 MB (free/total)
free disk space   : (C:) 157.99 GB
display mode      : 1280x1024, 32 bit
process id        : $14a4
allocated memory  : 36.56 MB
executable        : RecorderUpgrade.exe
exec. date/time   : 2011-12-02 11:28
version           : 6.17.1.247
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $f69342f9, $02f7961b, $02f7961b
exception number  : 1
exception class   : EDBUpgraderError
exception message : Error occurred running script 00000082.sql. The error is described as: Invalid object name 'NBNData.dbo.IW_Column_Type_Pattern'.

Upgrade has to be killed (but Recorder appears to work okay)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Hi Charlie
Looks like that script expects your database name to be NBNData. If you download http://forums.nbn.org.uk/uploads.php?file=00000082.txt then rename it to 00000082.sql and swap it for the equivalent file in your upgrade's scripts folder it should work.
Best wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by andrewsalisbury

  • andrewsalisbury
  • Member
  • Offline
  • Registered: 22-11-2007
  • Posts: 7

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Hi

I have what may be a superficially similar problem

Error occurred running script 0000007Z.sql. The error is described as: Invalid object name 'sys.objects'.

However when I now open Recorder it tells me it is version 6.17.1.250.

Many thanks

Andy

Our version is running over a network.

4 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

OK that was wierd.

I tried to run the upgrade in exactly the same way as I always have with previous ones and was told that my windows login does not have sufficient permission to upgrade (it says I lack db owner, which is not the case, I have db owner priviledges).

Our ICT officer then came and tried a series of adminsitrative logins until he found one which did not cause an error and the upgrade began, only to terminate quite rapidly with an unhandled error similar to the ones above (e.g. Error occurred running script 000000??.sql. The error is described as: Invalid object name 'sys.objects'.) Unfortunately I neglected to note down the number of the script which failed.

I thought I would be able to check which script it was by reference to the LastError.txt file, only now I do not know where it is saved. It is not in the location Sally describes C:\Documents and Settings\AllUsers\Documents etc, because this folder doesn't exist.

Recorder 6 opens and runs apparently normally and the version number is correct following the upgrade, but how can we be sure the system is working properly?

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

5 Reply by RobLarge (edited by RobLarge 27-01-2012 15:19:37)

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

I have done some research and it would apear that the only script file which contains the words "sys.objects" is 0000007Z.SQL and its right at the top, so it must be this one which failed to run properly.

A brief check suggests that neither this script, nor any of the subsequent ones had been run, so I ran them all manually (I had to remove the test at the beginning of7Z and manually delete the usp before running it).

So now all scripts have run? But I still don't know if I have a stable, fully functioning install...

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

6 Reply by MikeWeideli

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

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Thanks Rob. Script 7Z was not SQL Server 2000 compatible. This and the scripts after it will not have run on SQL Server 2000 systems.  All the affects are confined to the Import Wizard, but will not cause any corruptions if the Wizard is used.  A revised upgrade will be available shortly once we have run a few more tests.

Mike Weideli

MikeWeideli's Website

7 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Thanks Mike, as I said I have manually run the rest of the scripts without incident, it was only the inclusion of the sys.objects that caused an error.

Does that mean the upgrade is complete now (i.e. are the scripts the last thing to run) or is there likely to be anything else missing?

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

8 Reply by MikeWeideli

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

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

I am comfortable that if you have run the scripts 7Z to 82 manually then everything is Ok, but  you might like to check the Setting table. The db sequence should 00000082. This will probably not have updated  if you have run the scripts manually. It shouldn't cause a problem, but it may be worth updating it.

Mike

Mike Weideli

MikeWeideli's Website

9 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Recorder 6.17 upgrade error - Error occurred running script 00000082

Thanks Mike, you were right, dbseq was stuck on 0000007Y, I have updated it to 00000082 manually.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website