Subject Re: Restore Problem - HELP
Author Todd Brasseur <todd@compass-cama.com>
The previous message was when I restored using the Open Source Version
of IB Expert.

When trying to restore using a licensed version of Quickdesk I get:

Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
action cancelled by trigger (0) to preserve data integrity.
could not find table/procedure for GRANT.


Does this help shed some light on the problem?

Again, any help would be greatly appreciated.

Todd



--- In ib-support@yahoogroups.com, "Todd Brasseur <todd@c...>"
<todd@c...> wrote:
> Hello people,
>
> I was restoring a backup into a new database and got the following
error:
>
> gbak: restoring index RDB$FOREIGN131
> gbak: restoring index RDB$FOREIGN132
> gbak: restoring index RDB$FOREIGN149
> gbak: restoring index RDB$FOREIGN156
> IBE: Unsuccessful execution caused by system error that does not
> preclude successful execution of subsequent statements.
> connection lost to database.
>
> This was during the 'Create Indexes' portion of the restore. I
> thought maybe there was a problem with indexes so I looked in
> RDB$INDICES. The last indexes restored are near the bottom of the
> table. So I removed the last few indexes in the database, re-backed
> up and re-restored and get the same error.
>
> I have no idea now what to do. Any help would be greatly appreciated.
>
> Thanks
>
> Todd Brasseur
> COMPASS Municipal Services Inc.