Subject | Cannot Deactivate Primary Index |
---|---|
Author | gorepj |
Post date | 2008-05-27T15:31:47Z |
Hi,
I'm migrating a Version 1.5 Database to Version 2.1 Database.
When running GBAK to restore to 2.1 it proceeds OK until,
gbak:opened file g:\fbdata\fb_Stman32.fbk
gbak:transportable backup -- data in XDR format
gbak: backup file is compressed
gbak:created database g:\fbdata\fb_Stman32.fdb, page_size 8192 bytes
gbak:started transaction
gbak:restoring domain D_BOOLEAN
...
gbak: activating and creating deferred index PK_SM61P
gbak: activating and creating deferred index RDB$PRIMARY16
gbak: activating and creating deferred index RDB$PRIMARY15
gbak: activating and creating deferred index PK_SM64P
ERROR: action cancelled by trigger (3) to preserve data integrity
Cannot deactivate primary index
Any ideas how I can resolve this?
Regards
Peter Gore
I'm migrating a Version 1.5 Database to Version 2.1 Database.
When running GBAK to restore to 2.1 it proceeds OK until,
gbak:opened file g:\fbdata\fb_Stman32.fbk
gbak:transportable backup -- data in XDR format
gbak: backup file is compressed
gbak:created database g:\fbdata\fb_Stman32.fdb, page_size 8192 bytes
gbak:started transaction
gbak:restoring domain D_BOOLEAN
...
gbak: activating and creating deferred index PK_SM61P
gbak: activating and creating deferred index RDB$PRIMARY16
gbak: activating and creating deferred index RDB$PRIMARY15
gbak: activating and creating deferred index PK_SM64P
ERROR: action cancelled by trigger (3) to preserve data integrity
Cannot deactivate primary index
Any ideas how I can resolve this?
Regards
Peter Gore