restore cancelled by trigger

Alexandr Schilberz

Delphi Developer

restore cancelled by trigger

2005-02-22 10:17:45 PM
delphi75
Hi,
I use Interbase 5.6 (know it`s an old Version, but i can DEFINITIV update at
this moment) on Windows 2000 Server.
Regularly i do my database backups.
Now i have to restore one.
Nearly at the end of the restore i get the following error message:
action cancelled by trigger (0) to preserve data integrity
could not find table/procedure for GRANTHave done everything i know, to get
the restore works, but no better result.The same backup-file restore fine
under Interbase 7.1What is wrong with my databse?Greetings

Craig Stuntz [TeamB]

Delphi Developer

2005-02-22 10:54:59 PM

Re:restore cancelled by trigger

Alexandr Schilberz writes:

Quote

Now i have to restore one.
Nearly at the end of the restore i get the following error message:

action cancelled by trigger (0) to preserve data integrity
could not find table/procedure for GRANTHave done everything i know,
to get the restore works, but no better result.The same backup-file
restore fine under Interbase 7.1What is wrong with my
databse?Greetings
I consider this an IB < 7.1 bug. You have a privilege in

RDB$USER_PRIVILEGES which doesn't correspond to a real table. IB can
back this up but can not restore it in < 7.1. For old versions the only
"simple" fix is to find the "bad" privilege in the GDB, remove it, and
backup again.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
How to ask questions the smart way:
www.catb.org/~esr/faqs/smart-questions.html