Topic: Report for listing any missing Organisms
Hi Mike,
Any updates with respect to this report?
Many thanks.
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Recorder Troubleshooting and Bug Reports → Report for listing any missing Organisms
Hi Mike,
Any updates with respect to this report?
Many thanks.
Sorry. I missed the post about the missing upload.
Attached is a report which will list any missing Organisms. Once it has run we need to check to see if the Taxon_version_Key it returns are present in the full Organism table. If you send me the results I can check this or you can check it against the Organism table you have at home. If the entries are in the full table then the problem is in the population of the table in the Dictionary upgrade. It would then be worth you running the upgrade again, by changing the Dict Seq in the setting table to 00000015 (not 14), so that the upgrade is run again without deleting what is already there. If they are not in the full Organism table then this means the Dictionary has some missing or incorrect data. I may be able to work out why this is has happended from the list.
Many thanks Mike, I'll get back to you as soon as I can.
Hi Mike,
Here's the output...
Thanks. A worrying result from my point of view as it looks like some of the entries just haven't gone in. We will need to hold back 6.18 from general release until we can find out why this has happend. If you could set back the Dict Seq indicator in the Setting table to 00000015 and run the Dictionary Upgrade again I am hoping this will fix it. .
Ok, I'll crack on with that now.
Mik, I've reset the SETTINGS Deq Seq indicator to 00000015 and am running dictionary upgrades 00000016 onwards. This may not finish by the time I go home so I'll report back with a new output from the ORGANISM report ran earlier.
Hi Mike,
Updated report output having re-run dictionary upgrades 00000016 onwards.
I believe this is something to do with the order in which the Organism table is processed. Although the order is correct in the table (ie the parents come before their children) it looks like this order is not always adhered to when the dictionary upgrade runs, which means that some records don't go in because their parents are not yet there. Running a second time finds the parent, so a few more go in. To eliminate this possibility, I have split the table into the 10 levels so that the children can't go in first. There is a new dictionary upgrade at www.Recorder6.info/0000001Bto1N.zip which implements this. It is designed to run on a Dictionary already upgraded to 0000001A. I would be most grateful if you would try this for me. You should end up with 108,222 entries in the Organism table. Don't worry about the report I sent you. It has done its job and can be deleted.
Hi Mike, you're a star! Doing a 500,000 record import (split into 75,000 chunks) at present, I'll give it a go when this is done and backed up.
Hi Mike, I've just ran the new set of dictionary upgrades and I now have 108,222 entries in the Organism table. Many thanks for your help!
Forum → Recorder Troubleshooting and Bug Reports → Report for listing any missing Organisms
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.