tickerboo2002 wrote:

> gbak: restoring data for table TELEPHONE_SYSTEM_ALLOCATION
> gbak: 49 records restored
> ERROR: validation error for column FORM_ID, value "*** null ***"
> attempted retrieval of more segments than exist.
>
> Any idea what can cause these errors?

You used some tool in the past to change column from NULL to NOT NULL by
modifying the system tables, but the tool probably didn't warn you that
you should UPDATE the existing rows with NULL to something else.

> Is this error in the live database and needs fixing there?

Yes. Just run something like:

update TELEPHONE_SYSTEM_ALLOCATION set FORM_ID = 1
where FORM_ID is null;

Of course, the value you would use (instead of 1) depends on the
semantics of FORM_ID field.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com