Need help repairing a damaged DF1 database
this is not an unusual condition (running out of data file space) but you
need to give the DF1 file enough space to recover from the errors that have
things I would do:
(1) make a backup, then perform the recovery attempts on a copy of that
backup. if you have an SSD recovery will go much faster.
(2) attempt the recovery on a different computer than your current server /
workstation machine, with the same Omnis developer version, newly
installed, as runtime version.
sometimes, long-installed omnis software may be corrupted, so working with
a copy you know is whole and complete can eliminate those sudden execution
interruptions during recovery.
(3) add a new segment before performing any recovery attempts, as Rudolf
I’d be happy to look over your shoulder via teamviewer, contact me off list.
From: Darren Csepreghy <DarrenC@csoftware.com.au>
> Subject: Need help repairing a damaged DF1 database
> I’ve inherited a client that is running a POS system based on OMNIS7. It
> is using some .DF(x) databases.
> Unfortunately the developer of the software isn’t around the support it
> The program can still be opened, but faults with a debug window stating
> that “E101009: The data files are full”
> A “quick check” using repair tool supplied with the software of the data
> file reveals that it “Needs Repair. The free block structure is damaged”.
> The repair function reaches a certain number of records (the same each
> time) before seeming to freeze.
> If I go to “Utilities” – “Examine Data File” – “Data File” – “Check free
> blocks”, it crashes rather nicely.
> However it did let me “Change the Data File Size” successfully, although
> this made no difference.
> Does anyone have any advice on how I might be able to resolve this ? I’ve
> read a few posts about exporting the data to a new database but I’m not
> sure how to facilitate this. Are there 3rd party repair tools available ?
> Would there be anyone interested in tackling this for me ??
> Any help would be greatly appreciated.
> Darren C
> E: email@example.com
> M: +61419190342
> From: Mike Matthews <firstname.lastname@example.org>
> Subject: Re: Need help repairing a damaged DF1 database
> Hello Darren,
> Plenty of help in the archives here for you, but you will need a certain
> level of experience.
> Do you have the POS library file as well, which may or may not be unlocked
> from modifications? Also, which exact version of Omnis 7? I expect
> running under Windows or some variant of it for the POS system.
> People on this list have written tools to do this recovery for you, not
> always with 100% guarantee of success, that level doesn’t really exist
> sadly, but inmost cases you will get all of your data back, but missing 1
> or 2 transaction records usually.
> Contact me off list if you would like some help.
> Thank you
> Mike Matthews, Managing Director, Lineal Software Solutions Ltd
> From: Rudolf Bargholz <email@example.com>
> Subject: AW: Need help repairing a damaged DF1 database
> Hi Darren,
> you will probably need to add a new segment, and then expand that segment
> to 512000 blocks.
> Rudolf Bargholz
Manage your list subscriptions at lists.omnis-dev.com