1

Topic: Recorder 6 Upgrade 6.28.0

This upgrade is now available from http://www.recorder6.info/page26.html

There a two main changes. Firstly, the ability to import a second determiner through the import wizard. Secondly, a method of securing map files together with some changes which should overcome the problem which causes most of the map files corruptions. The release notes contain full  details of these changes  plus information on the other bug fixes.

Mike Weideli

2

Re: Recorder 6 Upgrade 6.28.0

Hello,
Having updated the dictionary and the software I have problems with exporting to NBN Exchange format v6.21.
When I try first time I get the message, that I should "Check path snd name. Make sure you have write permission to that folder."
I set all paths to a folder, where I have write permission, but does Recorder have write permissions there too?
When I try to export again, I get the following message:
"There is already and object named '##nbn_exchange_obs' in the database"
Would anybody know, what that means?

Thanks,
Wolfgang

3

Re: Recorder 6 Upgrade 6.28.0

The second message is because a temporary database file is not being closed. Closing R6 and reopening should  solve this.     We certainly haven't changed  the addin or any of the tables or  sql it uses. Close R6 and try again and let me know what happens.

Mike Weideli

4

Re: Recorder 6 Upgrade 6.28.0

Thanks Mike.
Closing and reopening helped. It works now.

5

Re: Recorder 6 Upgrade 6.28.0

I'm not sure if it is a coincidence or not, but since upgrading to Rec 6.28.0, Recorder seems very slow to open up windows which link to taxon records, e.g. the main event/sample window, particularly if a filter is active, e.g. when clicking on an entry in a report - it will display the entry, but then the 'egg-timer' comes on for ages before the window is actually active and things can be clicked on.

This certainly wasn't happening before the upgrade, but our network is a bit problematic at times, so it could be that

Craig

Craig Slawson
Staffordshire Ecological Record

6

Re: Recorder 6 Upgrade 6.28.0

Craig, this isn't just you. About 4 seconds to switch between occurrences in the obs hierarchy.

Mike - it appears to be the function ufn_ReturnReviewStatus that's taking the time.

(Switching the competency level to '0' to disable the feature removes the delay.)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

7

Re: Recorder 6 Upgrade 6.28.0

It appears to be because the function ufn_ReturnReviewStatus is searching the entire TAXON_DETERMINATION for each VDS - restricting the search to the supplied TAXON_OCCURRENCE_KEY reduces the query time to less than 0.1 seconds

i.e. adding

AND TAXON_DETERMINATION.TAXON_OCCURRENCE_KEY = @TOCCKey
Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

8

Re: Recorder 6 Upgrade 6.28.0

Hi

Thanks. I will get this fixed as soon as possible. In the meantime I suggest that the review system is turned off. As mentioned above this can be done by setting the Competency Level  to 0 in the Setting under options.  I  hadn't noticed the delay in the LRC's where it was installed for testing or in the large standalone databases I use for testing.

The aim was to meet the requirement  to use the Determination to identify records which had been reviewed, without necessarily making the reviewer the determiner, but because of restrictions which were imposed by the R6 steering group  we were not allowed to add any additional fields to the table which would have made things a lot easier.

Mike Weideli

9

Re: Recorder 6 Upgrade 6.28.0

Thanks Mike - in case it helps, our TAXON_DETERMINATION table has 10,610,364 entries.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

10

Re: Recorder 6 Upgrade 6.28.0

Thanks for the update, the delay on taxon dets was driving me nuts! I've set competency to '0' and its back to normal speed

11

Re: Recorder 6 Upgrade 6.28.0

Hi

I have had a go at fixing this, and what I have done seems logical and the SQL Server Execution plan suggests a big improvement, but nothing I have here reflects any significant change. I would be grateful if someone with a  large system who has the problem can give the change a try. To do so download www.Recorder6.info/6.28.0Upgrade_Release_VersionWithB5.zip
and run this as a normal upgrade. There will be no need to rebuild indexes and the R6 version will not change just the database version will become B5.  Competency needs to be set to 3. Leaving the change in will do no harm, but it doesn't work the competency needs to be set to back to 0.

Mike Weideli

12

Re: Recorder 6 Upgrade 6.28.0

Looks good to me Mike - no discernible time delay when switching occurrences on our database.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

13

Re: Recorder 6 Upgrade 6.28.0

Many thanks. What I have done is to update version 6.28.0 on the Recorder3.info site and to supply JNCC with a revised version which should  be on the JNCC R6 site by now .  Anyone downloading the upgrade will then get the revised version. Those  who has already dowloaded 6.28.0 who has a problem can download and run it again.  It should only take a moment to run and there is nothing to do after that - no indexes to be rebuilt. The version number will not change, but the database sequnce will be 000000B5.         

Version 6.29 will include the same change so that anyone on the original version of 6.28 will be brought into line.

Mike Weideli

14

Re: Recorder 6 Upgrade 6.28.0

Hi all,

Has anyone experienced any mapping problems since upgrading to 6.28?  We are a bit delayed on upgrading as we need input from the Council IT guys.  It was run yesterday and ever since we haven't been able to use the in system mapping - trying to display the map window causes an error message. 

exception class   : EVariantTypeCastError
exception message : Could not convert variant of type (Null) into type (String).

I've just looked on the B: Recorder 6 drive and the folder 'Map files' is also empty.  I'm assuming this isn't affecting anyone else as I can't see mention of it on the forum so maybe there was a problem during installation?  I'm thinking of asking IT to roll back the version and try again...

Thanks for any input.

Lindsay

Lindsay Bamforth
Fife Nature Records Centre,
Information Officer

15

Re: Recorder 6 Upgrade 6.28.0

I suggest that you don't role back for the moment. I will investigate today, but it will be easier if I have the full error report.  It probably means that something in a table isn't what is expected, because of some problem in the past.  The upgrade didn't delete anything in the tables, it is just checking that what is there is correct.

Mike Weideli

16

Re: Recorder 6 Upgrade 6.28.0

Thanks Mike.  I've just emailed you the Error text file.

Lindsay

Lindsay Bamforth
Fife Nature Records Centre,
Information Officer

17

Re: Recorder 6 Upgrade 6.28.0

The problem looks like it is in the Computer_Map table where the Object_Folder_Folder  has an entry of null, This would be against an entry which has true (1 or -1 )in the Master column. Have you any method of seeing what is in this table and if necessary changing it .  If so a  screen shot of the table contents would enable me to worl out waht needs to be done.   Otherwise I can do you an XML report to get the information out and if necessary a Batch update to put it right.

Mike Weideli

18

Re: Recorder 6 Upgrade 6.28.0

Thanks very much to Mike, who fixed the issue with a batch update as described above.  Sounds like it was a peculiarity of our set-up.  The update assumes that maps work on the machine being used to do the upgrade - as IT need to run the update here (and they do it from their base and they aren't Recorder 6 users), maps may well have not worked on their machines used to do the update!

Hopefully won't be of relevance to anyone else, but just in case...

Linds

Lindsay Bamforth
Fife Nature Records Centre,
Information Officer