Topic: Dictionary out of step- Dictionary upgrade fails
It is possible for the dictionary on an R6 system gets out of step with the master. The only known reason for this is an issue which occurred back in 2010, when it was discovered that running multiple updates together meant that only the first upgrade was processed. This was fixed in November 2011 with a new upgrade program. I am not aware of issues since then.
There is no easy way of knowing if a dictionary is out of step as the errors can be subtle and not show up for a long time. If you suspect a problem, because searches or reports do not work as expected then please put a post on the Forum. Dictionary upgrade scripts can fail if the dictionary has got out of step. If this happens I will try to provide an immediate fix to keep R6 running, but further investigation should be undertaken to find and resolve any problems.
At the moment there is a free* service to check a dictionary and if necessary to provide a special set of updates to bring the dictionary into line with the Master. In order to provide this service I will need a copy of your database. I can accept a backup, or a copy of the actual database taken after a detach. This can be provided on a DVD, memory stick or via Dropbox. All SQL versions can be accepted. There is no need to stop using Recorder. After checking I will provide a special dictionary upgrade which will bring your dictionary into line with the master. I would normally turn this around within 48 hours. Please email me mike@Lfield.co.uk if you would like to use this service. It will help if you let me know what version of SQL you are using.
Note* – The data will not be retained once the work is complete and will not be passed on to anyone else in any format. I reserve the right to charge for any time taken in completing additional confidentiality agreements, as they can take more time than processing the data.