Subject Re: [ib-support] gbak -R: exiting before completition
Author Milan Babuskov
duilio_fos wrote:
> periodically after a backup I do a restore on a test GDB, just to be
> sure that the backup file is ok.
>
> Today the call of gbak -R produced the following error messages:
>
> "validation error for column ID value NULL"
> "warning - record could not be restored"
> "exiting before completion due to errors"
>
> is it not possible to tell gbak: "discard the unvalid records and
> continue (up to the end)" ?
>
> Thank you
>
> Duilio Foschi

This is probably result of some GUI tools (like IBExpert for instance)
that don't check fields' values, just change the field to NOT NULL.

You can use the same tools to remove NOT NULL constraint and then backup
/restore. Or you can fix records before backing up.

You wrote that it is the test gdb, so I don't see any probl.

Milan.