|
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 → How Do I... & Other Questions → Dictionary updates continually failing
Hello,
We're stuck on dictionary 4Z. Every time we try to update to 50 it says completed with errors, we then get continual error messages until we roll back to the previous backup and start again with 4Z.
Has anyone else had similar issues? We've tried the license keys for 23-24 and 24-25 but it's the same issue with both.
Thanks in advance.
Neil
The update generates a log file (Dictionary.log) which should end up in the same folder as the update dictionary file. First try to run the update with the block size set to 1. The log file should show where and why the update is failing/. If you upload the log file here I will take a look.
Hi Mike,
thanks for the offer! Here's what I get in the DictionaryLog.txt:
[Block Size]1
[Licence Key]********
[Licence Check]--DINTYGRID
IF NOT EXISTS (SELECT * FROM TAXON_COMMON_NAME WHERE TAXON_COMMON_NAME.Taxon_List_Item_Key = 'NHMORG0100004349') INSERT INTO TAXON_COMMON_NAME([TAXON_LIST_ITEM_KEY],[TAXON_VERSION_KEY]) VALUES ('NHMORG0100004349','NBNSYS0000023897')
UPDATE TAXON_COMMON_NAME SET [TAXON_VERSION_KEY] = 'NBNSYS0000165306' WHERE TAXON_COMMON
Completed with errors to Update 00000050
Hi
There is no logical reason for it to stop when running this SQl. Pleaae could you try again with the block size set to 1 and see if it stops in exactly the same place.
Mike
It's almost identical, just the "UPDATE TAXON_" line missing
[Block Size]1
[Licence Key]D1770NTY
[Licence Check]--DINTYGRID
[Errors]
IF NOT EXISTS (SELECT * FROM TAXON_COMMON_NAME WHERE TAXON_COMMON_NAME.Taxon_List_Item_Key = 'NHMORG0100004349') INSERT INTO TAXON_COMMON_NAME([TAXON_LIST_ITEM_KEY],[TAXON_VERSION_KEY]) VALUES ('NHMORG0100004349','NBNSYS0000023897')
Completed with errors to Update 00000050
Hi
If you run XML report Dict 2 what figures do you get.
Mike
Hi Mike,
We don't appear to have the Dictionary reports in our XML reports list. Is there a way of accessing a copy?
Hi
It should be in Reports Run/System Supplied/Dictionary - Report Dict 2. Attached if you can't find it. The file ned to be in the Report folder of R6, Not sure where this will be on your machine.
Hi Mike,
This is what I get:
Table_Name Records
Taxon_List 243
Taxon 317721
Taxon_Version 323796
Taxon_List_Item 735679
Organism 121459
Run the attached. Hopefully, it will put things right.
Run Report Dict 2 afterwards. You should get the same stats as before, but the dictionary should show it is updated to 50.
That worked perfectly! Thank you!
Forum → How Do I... & Other Questions → Dictionary updates continually failing
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.