Re-unite Missing Relatives and Kill Orphans and Re-index Files

Document path Reference Contents > Advanced Functions > Re-unite Missing Relatives and Kill Orphans and Re-index Files

This window is used for both the File -- Advanced -- Re-indexing function and the File -- Advanced -- Re-Unite Missing Relatives functions. Both list all files that have records in them. All these functions require you to be the only user on the data file.


Re-indexing is a Caliach Vision advanced function that can be applied to a selected set of files within the Data File. The re-indexing process first deletes the existing indexes of a file, then scans the file's data blocks and builds a new set of indexes. In doing so it uses the header to identify where data blocks are for the file. To Re-index:

  1. Backup your data file.
  2. Launch Caliach Vision and make sure you are the only user of the data file.
  3. Operate the Re-Indexing function from the Advanced menu.
  4. On the list, select the files you want to re-index.
  5. Note NOTE: It is rarely obvious which file has a damaged index. Caliach Vision has a highly related data architecture and because of cacheing one event can lead to several files having damaged indexes. If you are reasonably sure you know which files are damaged, re-index just those, otherwise re-index all files.

  6. Click on the Re-index button and then wait for it to finish. It can take a very long time. Typically, a 50Mb Data File will take 5-6 hours on a fast workstation.
  7. Warning WARNING: A common problem is where the header is damaged along with one or more index. When the index is deleted the only source of access to the actual data is lost when the header is damaged. In this case the act of re-indexing completely destroys the Data File. Restore the backup. It is common that during re-indexing you receive no indication that this has happened; it seems to proceed correctly. However, on completion you find that the Data File has grown substantially; by 20% or more. Generally, internal files are only left with one accessible record. In this case, the Data File is destroyed and the backup must be restored.

  8. If the process does not complete successfully, restore the backup, and use the Data Fix Utility function.
  9. If completed successfully, re-launch Caliach Vision and test whether the problem still exists. If it has not solved the problem, restore the backup, and use the Data Fix Utility.




Selected files will be re-indexed.


Selected files will be deleted. All data will be lost.

Warning WARNING: This is a very dangerous function. If you delete a file inappropriately you must recover your backup.

Re-Unite Missing Relatives

Relational databases hold record relationships by storing related record key field data within the fields in the files own records. These relationship fields are automatically maintained under normal circumstances. However, if a computer error occurs, such as a power failure or network interruption at the wrong time, the accuracy of the relationships may be damaged. This is seen by the user as records with no parent, for example Purchase Order line items without a PO, or a PO without a supplier.

Select all the files you want to check, and click on Re-unite button.

Results of the checking will be shown in an Alert Message window. If errors are encountered, details will be given in the Alert Message and a Activity Log record will be created.

NULL values in a database system are effectively an 'un-defined' value. When a calculation is made in which a field has a NULL value, the result will be NULL. If a comparison involves a NULL value the result is 'don't know'. Because of this, NULLs in numeric fields are undesirable and normally will never occur. However, whether caused by data damage or un-managed data import, it often persists. A function is provided here to scan all numeric fields in all records of selected files and identify and report any with NULL values. The system then sets them to zero automatically.




Selected files will be validated for referential integrity.

Clear NULLs

Selected files will be checked for the presence of NULL values in number fields and if found they will be set to zero. Note, from V3.1006 the process also looks for NULLs in boolean fields and repairs them also if found.

nfc() Normalise

Selected files will have non-indexed character fields checked for Unicode normalisation and normalised using nfc() if needed. This function is available for V4.0000 onwards only. See the sub-section on Character Normalisation in the Unicode section of Keyword System Settings.

See also: -

Compiled in Program Version 3.10. Help data last modified 18 MAR 2012 06:03. Class wReorFiles last modified 18 MAR 2012 05:55:49.

Document path Reference Contents > Advanced Functions > Re-unite Missing Relatives and Kill Orphans and Re-index Files