1

Topic: Database Problems Report

I have recently been tidying up a number of minor anomalies in our networked copy of Recorder 6: I am using Reports>Run>System Reports>Information>Sy07 Problems (Detail).....running this report gives me a list of database problems including a single item under the heading "Determinations with Invalid Key". What does this mean? When I run the key through the "Go to a particular row by typing its key" facility, I get the following message:
     Error showing "SR00026700003MVM
     Error: GetItem: List index out of bounds (%d)

What does all this mean and how can I get rid of the Problem: Determinations with Invalid Key ??

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

2

Re: Database Problems Report

The accompanying documentation says the origin is ‘Dictionary upgrade failed to complete properly’ and suggests rebuilding Taxon Name Index. If this doesn’t work it will need to be investigated using Management Studio. Go To (key) doesn’t work on taxon determinations so you need to look up the corresponding taxon occurrence key and use that. But if the taxon list item key is invalid or missing the observation can’t be displayed in the observation hierarchy because there is no species name to display in the hierarchy on the left. The following query will give you the taxon occurrence key for taxon determination SR00026700003MVM:

Select Taxon_Determination_Key, Taxon_List_Item_Key, Taxon_Occurrence_Key
From Taxon_Determination Where Taxon_Determination_Key = 'SR00026700003MVM'

If the Taxon_List_Item_Key is blank or invalid you can set it to a valid key as follows:

Update Taxon_Determination Set Taxon_List_Item_Key = 'NBNSYS0000094797'
From Taxon_Determination Where Taxon_Determination_Key = 'SR00026700003MVM'

NBNSYS0000094797 is Wolf (Canis lupus) from the Recorder 3.3 list. You will then be able to Go To the observation and edit or delete it.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3

Re: Database Problems Report

Thanks for reply Sally - I'll try the rebuild option first - will I need to rebuild any of the other Indexes (in sequence) as well? I've had no other indications that the Dictionary Upgrade failed to complete properly.

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

4

Re: Database Problems Report

It shouldn’t be necessary in this case but it won’t do any harm.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

5

Re: Database Problems Report

Thanks Sally, rebuilding the Indexes didn't seem to clear the problem - as I can't get at the SQL database (on our corporate secure server) and use Management Studio, I will have to get our IT people to help.....

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU