Dictionary Updates After 0000004K - Using Dictionary Update Kit v5

Download the application DictionaryUpdater5.exe  (click here).  Unzip and copy the application file into a folder on  any machine that connect to  Recorder 6  Server. You must backup the R6 database before doing the update. Queries and issues should be posted  on the Forum.  You may need IT support to run this application.   

     

Preparation for  Update:

• Before running this process for the first time download and run XML Report Dic2 (click for more) . This should report the following for a dictionary up to 0000004K. If there any differences see  Dictionary Out Of Step.

Taxon_List  = 244, Taxon = > 311,368 ,Taxon Version = 317,443,Taxon List Item = 607,848,Organism =  119626

( Note := Taxon may be greater on some systems, but should not be less).  

  

• Download the upgrade files you need from this link Update files.  You can download either the zipped version or the unzipped version.  Place the file in the folder with the application and unzip the file to this folder if required. The folder can contain both the zipped and unzipped version, but only the unzipped version with the .sql extension is required and  there is no need to delete the any already processed.  With the first update in this format there are 5 separate upgrades contained in the zipped file. This will not normally be the case and is only necessary as part of the transition from the old version of the Dictionary Update Kit (v4). Each  upgrade must be run separately, but note that 0000004L to 0000004P run instantly and it is not necessary to rebuild the indexes after these.

 

Requirement for running the Update using Dictionary Upgrade Kit v5:

           This process can only be used if  :-

.

• Your dictionary version is 0000004K (or later)
• You have registered with Recorder 6 Steering group and have a Licence Key (8 characters) covering the current financial year.  
• The user running the upgrade from within Recorder 6 must have System Manager Admin permission  on Recorder 6.  

Note:- If you are on a version of R6  before 6.26 then you will need to upgrade before being able to run further dictionary upgrades. If your dictionary is not up to 0000004K or above then you must first use the old software to upgrade to 0000004K.  Check your version of R6 and Dictionary Updates from within Recorder 6 using Help/About Recorder 6.

Running the Update using Dictionary Upgrade Kit v5:

• Backup the database using R6 Backup or ensure that you have a backup available. Close R6.
• Run the Upgrade kit v5  and logon to SQL Server. Click on ‘Proceed’.  
• If the connection is OK  a new window will open. Select the folder where the dictionary update can be found. The application will not remember and you must select it each time.
• Enter the Steering Group Licence key and click on Proceed. Note that a licence key is only valid for a financial year.
  The Block size can be altered - click for more info.
• The update will normally take some time. There is a progress bar which updates for each table being processed.  Do not be concerned if little appears to be happening. Including additional progress information would substantially slow the update.  It is best to not use the machine for anything else while the update is running. If you leave the R6 window and return R6  may show ‘ not responding’. This can be ignored.
• Close the Upgrade program and run it again for each update file you need to process.   
• Optionally run XML Report Dic2 and check the results against those provided. If they differ restore from backup and seek advice.
• From within Recorder 6 rebuild the 4 index tables.

Errors and Problems

• The process writes a  log file ‘Dictionarylog.txt’  to the location of the update file. Refer to this if the process fails part way through.  
• Report any errors on the forum and supply the log file.
• Restore from the backup taken prior to the update.