> Hi,
>
> A couple days ago I found the following error in my database when I
> tried to restore it using Gbak:
>
> gbak: restoring index RDB$PRIMARY302
> IBE: The insert failed because a column definition includes
> validation constraints.
> validation error for column DATA_CAD, value "*** null ***".
>
> After completing the restore session, I noticed that some tables were
> empty. However, the original tables are Ok, no error occurs under
> production mode.
> The column DATA_CAD referred above is a DATE field that automatically
> gets the actual date when the user updates the record.
> We used to perform this restore procedure many times without any error
> so far.
> Does anyone know what can it be?
>
> Thanks a lot,
>
> Rogério

sounds to me like you've applied a NOT NULL constraint to your dev database
and failed to ensure that all NULL values have been replaced with a valid
value. IN this case a backup restore will provide this error.
The PROD version hasn’t had the constraint applied yet - I guess.
Alan