We've tried to upgrade our ZCM zone from v10.3.1 to 11.1a but have encountered an issue. The zone's database runs on an external Oracle 11g R2 instance (which has been updated from 10g as part of the upgrade pre-requisites).
The upgrade process has failed, with the following error recurring in pre-global-actions.log...

[FINER][Thu Jan 05 11:35:51 GMT 2012][PreGlobalAction]Stack trace: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: Error executing SQL: declare exist_cnt PLS_INTEGER;begin select count(constraint_name) into exist_cnt from user_constraints where upper(constraint_name) = upper('fk_zZENLocation_ZUID');if exist_cnt = 0 then execute immediate
'alter table zZENLocation
add constraint fk_zZENLocation_ZUID
foreign key (ZUID) references zZENObject
on delete cascade';end if;end;
at com.novell.zenworks.systemupdate.v_11_1_0.database .SQLExecutor.executeSQLStatements(SQLExecutor.java :151)
at com.novell.zenworks.systemupdate.v_11_1_0.database .SQLExecutor.executeSQLStatements(SQLExecutor.java :84)
at com.novell.zenworks.systemupdate.v_11_1_0.database .SQLExecutor.executeSQL(SQLExecutor.java:71)
at com.novell.zenworks.systemupdate.v_11_1_0.PreGloba lAction.execute(PreGlobalAction.java:131)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:134)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:161)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (ZCMUSER.FK_ZZENLOCATION_ZUID) - parent keys not found
ORA-06512: at line 1

It appears that foreign keys expected in a parent table are missing.

ZDC logs show errors against the database, but having gone through them they can be disregarded (hashes are different to those which are expected).
We've opened a ticket with Novell through our support partner and are working through it, but realistically we could fix this issue and then come across another issue when we next attempt an upgrade.

As a backup option we're considering building another zone running ZCM 11.1a, exporting data and configurations using zman scripts and re-registering devices from the old - slightly broken - zone to the nice new one. Most of are agents (approx 10,000) are inventory-only XP machines with around 100 fully managed Windows 7 clients.
Has anyone attempted anything similar? Does this sound reasonable?

Your opinions are appreciated,