User tries either to:
(1) Manually enter company journals
or (2) Run a consolidation.
For both functions, user receives an error.
Table M:\frangoifrs\data\xbjr.dbf has become corrupted . It will need to be repaired before using again.
The index for table xbjr has become corrupt.
One potential cause for this corruption is if the system crashed while saving (or working with) a journal.
Resolving the problem
First check if your file system is corrupt. Afterwards, delete the relevant "bad" index file.
Steps to check for hard drive file system corruption:
The following should be done by the I.T. administrator on the file server that hosts the Consolidator database:
- As a precaution (before continuing) take a backup of the entire Consolidator database (i.e. the DATA and REPORTS folders which contain all the Consolidator information).
- Select the hard drive where the database files reside (e.g. C: drive)
- Right click and show "Properties".
- Select the "Tools" tab, then "Error Checking"
- Click the "Check Now" button
- If errors are shown:
- try repairing the file structure
- If this does NOT fix the problem, then unfortunately you will need to revert to an earlier backup of the database.
- If errors are NOT shown, then carry on with the next section (below).
Steps to delete the bad index file:
- Using windows explorer, browse to the data folder(where database is stored). TIP: This location should be clear because it is named in the error message
- Rename the relevant INDEX (cdx) file (in this case it is "xbjr.cdx") to something else (for example xbjr.cdx.old)
- Re-launch the Consolidator client
- This will automatically launch the optimise routine, and it will give a message stating that a compulsory table is missing.
- Run the optimise
- Afterwards, check the journal where the problem occurred
- If it is available complete the rows as needed and save.
- Or re-enter the journal if required.