1

Topic: 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

2

Re: Dictionary updates continually failing

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.

Mike Weideli

3

Re: Dictionary updates continually failing

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

4

Re: Dictionary updates continually failing

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

Mike Weideli

5

Re: Dictionary updates continually failing

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

6

Re: Dictionary updates continually failing

Hi

If you run XML report Dict 2 what figures do you get.

Mike

Mike Weideli

7

Re: Dictionary updates continually failing

Hi Mike,

We don't appear to have the Dictionary reports in our XML reports list. Is there a way of accessing a copy?

8

Re: Dictionary updates continually failing

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.

Post's attachments

R6TEAM_Dic2_Statistics.xml 1.84 kb, 1 downloads since 2024-04-29 

You don't have the permssions to download the attachments of this post.
Mike Weideli

9

Re: Dictionary updates continually failing

Hi Mike,

This is what I get:

Table_Name    Records

Taxon_List                         243
Taxon                    317721
Taxon_Version            323796
Taxon_List_Item    735679
Organism                    121459

10

Re: Dictionary updates continually failing

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.

Post's attachments

00000050.zip 199 b, 3 downloads since 2024-04-30 

You don't have the permssions to download the attachments of this post.
Mike Weideli

11

Re: Dictionary updates continually failing

That worked perfectly! Thank you!