1

Re: Recorder 6.17 upgrade error

Hi,
We have just tried to run the Recorder 6 upgrade to the latest version 6.17 from 6.16.2 on a network installation.

We ran the upgrade as an administrator on a Recorder 6 workstation PC running Windows 7 64bit and the upgrade ran successfully displaying the expected confirmation message.

The problem arises when we try to run Recorder 6. We are getting the following unhandled error:

exception class   : EAPIError
exception message : Error 5: Access is denied.

I may well be wrong but I had thought the new upgrade was supposed to move the Base Maps and Map Files out of Program Files to get around the security issues associated with Windows 7 but this has not happened. Could this be the source of the error?

Our setting table in SQL is reporting the following:

SiteID    EHS00001
Version    6.17.1.250
URLSep    +
GatewayURL    http://www.searchnbn.net/searchengine/search.jsp?tab=1&pg=1&searchTerm=
DB Seq    00000082
LevelConf    4
Dict Seq    0000000Y
TaxDesList    NHMSYS0020424779,NHMSYS0001749171,NHMSYS0001770825,NHMSYS0001770462
DBListSep    ,
ConfFull    1

Can anyone point us in the right direction to get this working?

Thanks

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

2

Re: Recorder 6.17 upgrade error

Thought I should update on this...

I have added full control permissions for my user account to the Base Maps and Map Files folders within C:\Program Files (x86)\Recorder 6 Workstation. Recorder 6 now works for me but not for my colleague on her PC where these permissions haven't been set.

How can we get round this issue without having to add these permissions?
Thanks,
F

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

3

Re: Recorder 6.17 upgrade error

Hi Fiona,
The upgrade kit does not move the files for a working install, the change we made was to put the files in the right place for an fresh install. However, it looks to me like I've fixed a bug so that your base map upgrade procedure now works properly, and in doing so exposed a different more visible bug that you don't have access rights to upgrade the local copy of the base maps anyway!

To fix this, the best thing would be to move your Base Maps folder on each workstation from C:\Program Files (x86)\Recorder 6 Workstation to C:\ProgramData\Recorder 6 Workstation then change the setting in your registry (it should be under HKEY_CURRENT_USER\Software\Dorset Software\Recorder 6\Settings\Base Map Path).

Whilst you are in the registry, if you could report back to me what your setting for HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dorset Software\Recorder 6\Local Data Path then it would help me work out exactly why this has affected you.

Best wishes

John van Breda
Biodiverse IT

4

Re: Recorder 6.17 upgrade error

Hi John,
Thanks for your reply.

I moved Base Maps to C:\ProgramData\Recorder 6 Workstation\ , made the registry change and removed my user profile's permissions on C:\Program Files (x86)\Recorder 6 Workstation\
- Recorder 6 still won't work.

I then also tried moving Map Files  to C:\ProgramData\Recorder 6 Workstation\, made the appropriate registry change and Recorder 6 still won't work.

I checked the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Dorset Software\Recorder 6\Local Data Path setting and it was C:\Program Files (x86)\Recorder 6 Workstation\

I changed this to C:\ProgramData\Recorder 6 Workstation\ and Recorder 6 still won't work.

Stuck now!! Any clue as to what is happening?

Ta, F

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

5

Re: Recorder 6.17 upgrade error

John,
With only the initial change you asked me to do implemented the error I get is different and is no longer an Access denied error.
The error is an EApplicationSettingsError:

The Base Map Path setting is missing or incorrect. Recorder is not installed properly and cannot start.

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

6

Re: Recorder 6.17 upgrade error

Hi John,

I've just tried this upgrade directly on a Windows Server 2003 (not via a workstation) with SQL Server 2005 and on invoking Recorder 6 on the server (and an XP workstation) I get the Exception Error "Error 5: Access is denied." as well - I've managed to restore back to v6.16 and it invokes fine.

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

7 (edited by charliebarnes 18-01-2012 16:22:05)

Re: Recorder 6.17 upgrade error

nmrs wrote:

I get the Exception Error "Error 5: Access is denied." as well - I've managed to restore back to v6.16 and it invokes fine.

I just got this error updating another workstation - I had to change the "Base Map Path" path in the registry (its not located on the C drive).

(And then following that I got told I didn't have an Error path - assume this is meant to be created when updating - it did on my first workstation, but not my second).

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

8

Re: Recorder 6.17 upgrade error

Fiona,
Please can you confirm - when you run Recorder, does the Recorder.exe file sit on a network drive as in the standard setup, or have you done something to move it locally into C:\Program Files (x86)\Recorder 6 Workstation\?

Sorry, think I made a mistake in my post. The folder under ProgramData should be called Recorder 6, not Recorder 6 Workstation. Please can you correct it, and put the Map Files Path and Base Maps path in there, delete the relevant 2 registry settings so Recorder can redetect them and try again? The error you got about the Base Map Path being missing or incorrect implies that the registry setting did not point to a valid folder.

What I don't understand is you say that your colleague can't run Recorder now unless permissions are added to these 2 folders under the Program Files directory. But even Recorder 6.16 could not have created any maps without permissions to write to at least the Map Files directory. Are you saying that mapping was working in 6.16 with the map files directory set to Program Files without write permissions explicitly set?

John van Breda
Biodiverse IT

9

Re: Recorder 6.17 upgrade error

Hi,

Tried the v6.17 install again this morning having restored everything back to its original state and sadly another "Error 5: Access is denied."

I tried this install at home on a Network copy of Recorder 6 on an up-to-date XP/SQL Server 2008 desktop and it worked.

Any ideas please? All previous upgrades have worked here without issue since v6.10.

Cheers!

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

10

Re: Recorder 6.17 upgrade error

Hi

Also having problems with a networked workstation install of v6.17 which sounds similar to this getting an error message of:

The Object Sheet File Path setting is missing or incorrect, Recorder is not installed properly and cannot start.

Will try the above suggestion and keep an eye on this thread.

Natural History & Biodiversity Data Enthusiast

11

Re: Recorder 6.17 upgrade error

Mmm... having restored everything back to v6.16 (bar any registry settings that may/may not have been set during the v6.17 install) and restored NBNData back to the state previous to attempting the v6.17 upgrade, I can no longer delete surveys with either the Add-In or the 'old' Batch Update. On a survey known to take 2 minutes to delete (60,000 occurrences), nothing after an hour. Trying again but it's looking like a full server restore to the last known point where everything was working if I can't get any joy :-(

Anyone any thoughts yet?

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

12

Re: Recorder 6.17 upgrade error

Hi John,
Recorder.exe is sitting on the network drive as per the standard setup.

I have got myself a bit mixed up - my colleagues setup when running 6.16 required her to be made a local admin on her machine to allow her to create maps. However on running the upgrade this seemed to be broken and she got the same access denied error. Having run Recorder once as administrator her set up is now working.

On my setup, we have moved the Base Maps and Map Files to the ProgramData\Recorder 6, modified the two registry keys (as deleting them didn't work) and this hasn't fixed it.

I got our ICT dept in at this stage and we exported the modified Recorder 6 settings branch while logged on as domain admin, then logged on using my own user account, double clicked the file to import the settings, ran Recorder 6, got an OLE registry error, then ran it as admin, got the files in the wrong place error (as expected), then re-ran Recorder as a normal user and it worked. Bit of a hack really but it's working now and has worked on another user's machine after importing the registry file.

I will now see if we can roll this out to my colleague who has had local admin rights to get round the issues.

Hope this helps others. Thanks John :-)

Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

13

Re: Recorder 6.17 upgrade error

Ok, I have spent all morning bashing at this one, only to realise that Windows virtualisation means you can almost never work out what is working and what isn't.

Here is the long and the short of what I have found.
1) When you run Recorder on a networked workstation, one of the first things that it is supposed to do is check the network for new base map files and copy them down to the local machine (since they run much more quickly locally). This was not working before in some circumstances and is fixed in 6.17.
2) If you ran initially ran Recorder as an administrator on this machine (when it was first installed), then when it copies the base map files locally it does so but gives the files admin-only permissions for writing. This seems to be just the way Windows does it - despite being in ProgramData these files effectively become read only. Therefore the "fixed" 6.17 now fails because it cannot do this, unless ran as administrator.

There is a relatively simple fix to this since Recorder can create the Base Maps folder for you on startup with the correct permissions. You can get it to do this by first removing the Base Maps folder from the ProgramData folder (you need to remove the one pointed to by the Base Maps Path registry setting, NOT the one on the server installation folder). Then also delete the Base Maps Path setting from the Recorder registry settings. Next time you run Recorder it should sort that out for you, but make sure you run Recorder without choosing to run as administrator.

If anyone is interested in being a guinea pig, I've uploaded an application which checks through a whole host of settings relating to a Recorder install to try and ensure it is all present and correct. It provides automated fixes where it can. This is most definitely a beta, so please do not use on a machine that is critical to your use of Recorder. You can get the zip file at http://forums.nbn.org.uk/uploads.php?fi … mCheck.zip, just unzip and run the exe it contains from a machine with Recorder installed.

John van Breda
Biodiverse IT

14

Re: Recorder 6.17 upgrade error

Ok... seeing as the thread suggests that Base Map files may be set Read-Only I removed this flag, although none of the files looked as thought they were flagged as such. I then retried the v6.17 upgrade and I'm delighted to report the upgrade seems to have worked. I am now attempting to delete a survey... fingers-crossed!!

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

15

Re: Recorder 6.17 upgrade error

Hi Les
Problems with deleting surveys are not related to the map file permissions problems in this thread. I don't think 6.17 should change any of the survey deletion functionality, but if you get stuck let us know and I can look into it in more depth.

John van Breda
Biodiverse IT

16

Re: Recorder 6.17 upgrade error

Hi John,

Indeed... I've had issues in the past with both the Add-In and the Batch Update. One day they'll work fine, then for no apparent reason they take forever to delete a survey that would normally take a minute or two. Then, yes you've guessed it, without any interference(!) from me all returns to normal and they both work great!

Thanks for the pointers re the v6.17 upgrade and the Base Maps folder, that's now sorted but being able to delete surveys is critical to the success of the NMRS so I'm not out of the sticky stuff just yet! ;-)

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

17

Re: Recorder 6.17 upgrade error

John,

Trying to delete 60,000 records, normally takes about 3 minutes. Running for an hour now (Delete Surbey Add-In) and it looks like Recorder 6 has stopped responding - 3rd or 4th time of trying now.

Restarted the delete via new Batch Update and leaving it to run overnight to check in the morning...

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

18

Re: Recorder 6.17 upgrade error

Hi Les
It sounds like an existing problem cropping up then rather than a new one. One thing you could try if possible - restart your SQL Server before running the survey deletion. If you need help doing this just let me know.
Best wishes

John van Breda
Biodiverse IT

19

Re: Recorder 6.17 upgrade error

Morning John,

It looks as though normal service has resumed. The Batch Update deleted a Survey of 60,000 TOCC's overnight although I have no idea how long it took and the Delete Survey Add-In deleted a Survey with 30,000 TOCC's in less time than it took to make a cup of tea. Relieved!

R6 V6.17.250 is up and running! Resetting attributes to Read/Write on the R6 Server "Base Maps" directory cured the "Error 5: Access is Denied".

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme