Hi all,

Helen has asked me to repost this message to this list server... I shall
also post her reply and my reply to her reply :-) next.

Regards

Colin Fraser

ps. Thanks Helen!!

---------------Original Post-------------------
We have a stored procedure which used a generator... the Generator was
apparently deleted even when the stored procedure used it. Deleting or
editing the stored procedure now produces the following error:
-----------
This operation is not defined for system tables.
unsuccessful metadata update.
ERASE RDB$FIELDS failed.
deadlock.
------------
Validating the database produces no errors. Backing up the database works
fine. Restoring the database however fails with the following error:
-------------
gbak: ERROR: invalid request BLR at offset 49
gbak: ERROR: generator GEN_RP_REPORT_EVENT is not defined
gbak: Exiting before completion due to errors

Restore exited unsuccessfully on Thu Mar 22 16:34:46 2001
-------------
This is a bit scary to me... If I backup a database without errors, I would
assume that I could restore it without errors... The data does seem to be
restored but lots of things (like procedures) are missing.

Any help would be appreciated...

(p.s. have tried re-adding a generator with the same name... but that didn't
work)

Regards

Colin


######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################