 |
|
|
|
|
Most relevant administration functions are directly accessible from the IJC user interface. This document describes some things that are not currently possible through the IJC UI and must be performed manually.
On rare occasions the meta data that describes the database contents to Instant JChem may become corrupted. When this happens there may be items that are not understood and cause error messages to be displayed on startup. The only current way to avoid this is to manually remove these bad items from the IJC meta data tables. The error message will report the ID of the offending item (a 32 character hexadecimal string). This ID will correspond to an item in the IJC_SCHEMA table.
Before performing this operation you are advised to back up the IJC_SCHEMA table in case the wrong item(s) are deleted.
Connect to the database using a SQL editor (e.g. the database explorer provided with
IJC). Examine the contents of the IJC_SCHEMA table to confirm that there is a row
which has a ITEM_ID with the corresponding value. Delete this row using SQL such as this:
DELETE FROM IJC_SCHEMA WHERE ITEM_ID = 'uuid' OR PARENT_ID = 'uuid'
where uuid is replaced with the actual 32 character ID.