1

Topic: Upgrade problem

I am trying to upgrade from 6.23 to either 6.24 or the 6.25 candidate. I've tried both and the same error occurs so i don't think this is a problem with the upgrade files themselves. Rather something to do with either the SQL or network installation.

The workstation and host PC are both running Windows 10 and the database is on SQL Server 2008 R.


When running the upgrade.exe i immediately get the error;

The following file could not be upgraded, either because it is in use or you have insufficient priveleges:
R:\Addins\Images\GoToKey.bmp
Please resolve the problem and restart the upgrade.

The Upgrade is being run from the C drive of a networked PC.

The workstation i am using is logged in with network admin privilege user credentials. I have no problem accessing and using R6 and i am able to manually navigate and edit/amend/delete the offending file and folder. I tried a separate windows login (also a R6 system manager) and received the same error.

I am able to access and work with the database via R6 fine using the same windows credentials and also via Management Studio and can see no problem with the logins.

Stumped.

Natural History & Biodiversity Data Enthusiast

2

Re: Upgrade problem

I did wonder if Windows 10 image lock file (temp db) was causing issues as it has done so when working with other files and folders. I deleted the addin/image folder and still received the same error. This seems to be a permissions thing as opposed to a file in use thing.

Natural History & Biodiversity Data Enthusiast

3

Re: Upgrade problem

I think this is something to do with copying the image file.

I assume you have tried deleting the image  file from the server before running the upgrade. If not please could you try this before the following.

I have put a version of 6.25.1 (Build 283)  without the image file at www.Lfield.co.uk/downloads/V6.25.1Upgrade.zip.  This is the final version of 6.25 which will be made available to all very shortly (ie. it is later than  the release candidate). I hope this will resolve your problem.

There is a very old bug to do with copy addin image files and this may be the root cause of the problem. I think possibly the error message is spurious and it is actually trying to copy the file elsewhere. If my fix doesn't work then I will need to investigate this in more detail.

Mike Weideli

4

Re: Upgrade problem

Cheers Mike, I'll give this a go now. I had tried deleting the file then running the upgrade (same error).

Natural History & Biodiversity Data Enthusiast

5 (edited by BDeed 23-06-2016 11:22:42)

Re: Upgrade problem

Hi Mike, i tried the new file and am receiving the same error.
It does seem strange that i am receiving the same error regardless of whether or not the file or folder event exists at the at location.

Natural History & Biodiversity Data Enthusiast

6

Re: Upgrade problem

I will just double check that I haven't made a mistake, with removing the file. Can see how it can be trying to copy a file which isn't there.

Mike Weideli

7

Re: Upgrade problem

My apologies, I hadn't removed the file. It was a bit complicated because it is in a zip file within a zip file. The version which definitely doesn't have the file is at

www.Lfield.co.uk/downloads/V6.25.1Upgrade_AddinIMageFileDeleted.zip

Mike Weideli

8 (edited by BDeed 24-06-2016 10:27:03)

Re: Upgrade problem

Hi Mike,
At least the error has now changed... (attached*).
I think this can only be my windows credentials but I've no idea what might be wrong, everything else works fine.

*apparently i can't add a file with a png extention so error screen located here: http://www.activenaturalist.org.uk/mbb/index.php?q=filedepot_download/199/257

Natural History & Biodiversity Data Enthusiast

9

Re: Upgrade problem

Sorry can't get to the file. I did register, but thsi didn't help.

Mike Weideli

10

Re: Upgrade problem

Strange it's in a public folder. You shouldn't have needed to register. I'll have to look into that!

Back on point the error reads identically but instead of the image the update now fails on.

The following file could not be upgraded, either because it is in use or you have insufficient priveleges:
R:\Addins\StdValLib.dll
Please resolve the problem and restart the upgrade.

Natural History & Biodiversity Data Enthusiast

11

Re: Upgrade problem

This does seem to be related to permissions. Looks like R6 can not write to the folders, but why this should be when you can make changes outside R6 I am not sure. I can take out the stdval files, which may solve the problem, but it may simple stop at some other point. Can you look at the 'Security'  on the  R drive folder to see if there is anything there which may be causing a problem.

Mike Weideli

12

Re: Upgrade problem

Hi Mike, i suspect the same removing individual files probably wont solve the issue. All users have full (read/write) access to the share.

Natural History & Biodiversity Data Enthusiast

13 (edited by BDeed 27-06-2016 13:13:14)

Re: Upgrade problem

Considering this might be a permissions issue i re-installed the workstation. This appears to have sorted whatever the issue was and the upgrade then ran for a few seconds until it tried to update the database where it appears to have encountered an object it didn't expect. I think this is now a new un-related issue..

date/time         : 2016-06-27, 13:52:26, 372ms
computer name     : CZC52207TF
user name         : Ben Deed <admin>
operating system  : Windows NT New x64 build 9200
system language   : English
system up time    : 5 hours 6 minutes
program up time   : 16 seconds
processors        : 4x Intel(R) Core(TM) i5-4590 CPU @ 3.30GHz
physical memory   : 3984/8098 MB (free/total)
free disk space   : (C:) 310.70 GB
display mode      : 1600x900, 32 bit
process id        : $2068
allocated memory  : 39.69 MB
executable        : RecorderUpgrade.exe
exec. date/time   : 2016-06-23 14:27
version           : 6.23.1.276
compiled with     : Delphi 7
madExcept version : 3.0n
callstack crc     : $f69342f9, $c2585192, $c2585192
contact name      : Ben Deed
contact email     : ben.deed@merseysidebiobank.org.uk
exception number  : 1
exception class   : EDBUpgraderError
exception message : Error occurred running script 000000A0.sql. The error is described as: There is already an object named 'LC_ASSOCIATE_FILTER' in the database.

main thread ($1a00):
00551424 +218 RecorderUpgrade.exe DBUpgrader       387 +23 TDBUpgrader.RunScript
00551a7d +191 RecorderUpgrade.exe DBUpgrader       471 +19 TDBUpgrader.RunUpdates
00554c70 +050 RecorderUpgrade.exe UpgradeFrame     120  +4 TfraUpgrade.ProcessDatabase
00554aa7 +1f3 RecorderUpgrade.exe UpgradeFrame     108 +47 TfraUpgrade.Execute
00554359 +039 RecorderUpgrade.exe Main             140  +4 TfrmMain.EmbedCurrentFrame
00554282 +0ca RecorderUpgrade.exe Main             118 +13 TfrmMain.btnProceedClick
0049e78c +064 RecorderUpgrade.exe Controls                 TControl.Click
00494744 +01c RecorderUpgrade.exe StdCtrls                 TButton.Click
004895fd +065 RecorderUpgrade.exe Buttons                  TBitBtn.Click
00494838 +00c RecorderUpgrade.exe StdCtrls                 TButton.CNCommand
0049e5f4 +188 RecorderUpgrade.exe Controls                 TControl.WndProc
004a153f +157 RecorderUpgrade.exe Controls                 TWinControl.WndProc
00494608 +06c RecorderUpgrade.exe StdCtrls                 TButtonControl.WndProc
005133b0 +064 RecorderUpgrade.exe XPMenu          2928 +10 TControlSubClass.ControlSubClass
7737fd0f +02f user32.dll                                   GetPropA
0049e3c4 +024 RecorderUpgrade.exe Controls                 TControl.Perform
004a1677 +023 RecorderUpgrade.exe Controls                 DoControlMsg
004a1ccf +00b RecorderUpgrade.exe Controls                 TWinControl.WMCommand
004b9878 +02c RecorderUpgrade.exe Forms                    TCustomForm.WMCommand
0049e5f4 +188 RecorderUpgrade.exe Controls                 TControl.WndProc
004a153f +157 RecorderUpgrade.exe Controls                 TWinControl.WndProc
004b78c9 +421 RecorderUpgrade.exe Forms                    TCustomForm.WndProc
004a11bc +02c RecorderUpgrade.exe Controls                 TWinControl.MainWndProc
00476300 +014 RecorderUpgrade.exe Classes                  StdWndProc
77518e54 +034 ntdll.dll                                    KiUserCallbackDispatcher
77365ede +13e user32.dll                                   SendMessageW
7737dd03 +093 user32.dll                                   CallWindowProcA
004a1623 +0d7 RecorderUpgrade.exe Controls                 TWinControl.DefaultHandler
0049eb94 +010 RecorderUpgrade.exe Controls                 TControl.WMLButtonUp
0049e5f4 +188 RecorderUpgrade.exe Controls                 TControl.WndProc
004a153f +157 RecorderUpgrade.exe Controls                 TWinControl.WndProc
00494608 +06c RecorderUpgrade.exe StdCtrls                 TButtonControl.WndProc
005133b0 +064 RecorderUpgrade.exe XPMenu          2928 +10 TControlSubClass.ControlSubClass
004a11bc +02c RecorderUpgrade.exe Controls                 TWinControl.MainWndProc
00476300 +014 RecorderUpgrade.exe Classes                  StdWndProc
77386f2b +00b user32.dll                                   DispatchMessageA
004bdcb3 +083 RecorderUpgrade.exe Forms                    TApplication.ProcessMessage
004bdcea +00a RecorderUpgrade.exe Forms                    TApplication.HandleMessage
004bdf1a +096 RecorderUpgrade.exe Forms                    TApplication.Run
00555570 +1d0 RecorderUpgrade.exe RecorderUpgrade  104 +30 initialization
743c38f2 +022 KERNEL32.DLL                                 BaseThreadInitThunk

thread $2fd8:
743c38f2 +22 KERNEL32.DLL  BaseThreadInitThunk

thread $2154:
743c38f2 +22 KERNEL32.DLL  BaseThreadInitThunk

thread $1db4:
743c38f2 +22 KERNEL32.DLL  BaseThreadInitThunk

thread $2478:
76f7a4f4 +104 KERNELBASE.dll  WaitForMultipleObjectsEx
743c38f2 +022 KERNEL32.DLL    BaseThreadInitThunk

thread $10f8:
743c38f2 +22 KERNEL32.DLL  BaseThreadInitThunk

thread $2944:
743c38f2 +22 KERNEL32.DLL  BaseThreadInitThunk

thread $2e04:
76f7a4f4 +104 KERNELBASE.dll                WaitForMultipleObjectsEx
0044e3e5 +00d RecorderUpgrade.exe madExcept CallThreadProcSafe
0044e44f +037 RecorderUpgrade.exe madExcept ThreadExceptFrame
743c38f2 +022 KERNEL32.DLL                  BaseThreadInitThunk
>> created by main thread ($1a00) at:
768f493b +000 combase.dll



error details:
During update following re-install of workstation.

Natural History & Biodiversity Data Enthusiast

14 (edited by BDeed 27-06-2016 13:12:02)

Re: Upgrade problem

It looks like 'LC_ASSOCIATE_FILTER' is something we added in at the end of last year when i asked about using the report wizard to export observations based on individuals associations with a group.

Natural History & Biodiversity Data Enthusiast

15 (edited by BDeed 27-06-2016 13:20:00)

Re: Upgrade problem

Last one.. i checked script  000000A0.sql and it was identical to one i'd already run on the db (which you provided). I have removed it and re-run the upgrade. All has gone fine and R6 is now running as 6.25.

Cheers Mike.

Natural History & Biodiversity Data Enthusiast