English

Error: FAILED to upgrade table 'database' .SDE.MVTABLES_MODIFIED for 64 bit upgrade

Error Message

When upgrading ArcSDE for DB2 geodatabases that contain multiversioned views, the following error message displays:

"Error: RENAME <database>.SDE.MVTABLES_MODIFIED TO MVTABLES_MODIFIED_OLD32

FAILED to upgrade table <database>.SDE.MVTABLES_MODIFIED for 64 bit upgrade.

Error: -51

[IBM][CLI Driver][DB2/NT] SQL0750N the source table cannot be renamed because it is referenced in a view, materialized query table, trigger, SQL function, SQL method, check constraint, or referential constraint."

Cause

To upgrade ArcSDE, the functions sde_v_is_writable and sde_current_state must be dropped and re-created. The MVTABLES_MODIFIED table must be temporarily renamed. However, if there are multiversioned views present in the database, these functions cannot be dropped because they are referenced in the MVTABLES_MODIFIED table. In addition, the MVTABLES_MODIFIED table cannot be renamed because DB2 does not allow a table to be renamed if it is referenced in a view or SQL function.

Solution or Workaround

Drop all multiversioned views from the database prior to the upgrade and re-create them after the upgrade is complete.