At 05:30 PM 22-03-01 +1200, you wrote:

>Firstly... Not to sure where I should post general IB problems anymore... I
>gather the Mers list is not now visited by those who know lots about
>Interbase... so forgive me if this is the wrong place... :-)

It is the wrong place - you need to subscribe to the Open ib-support list - just fire off this email without changing anything (it will look empty to you):

mailto:ib-support-subscribe@yahoogroups.com

Meanwhile, I'll contact you privately, but please do re-post this to ib-support.

Cheers,
Helen

>Now the problem,
>
>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.
>######################################################################
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________