Oracle migration fails on orphaned entry in the zAdminRole table

  • 7004280
  • 21-Aug-2009
  • 30-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2 Migration
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Migration

Situation

Oracle migration fails on orphaned entry in the zAdminRole table
ERROR:*[2009.04.26-17:30:53] SEVERE: An error has occurred while migrating the database. [2009.04.26-17:30:53] SEVERE: ORA-02298: cannot validate (ZCMADMIN.FK_ZADMINROLE_ROLEUID) - parent keys not found*

Resolution

This is fixed in version 10.2.1 - see KB 7003766 "ZENworks 10 Configuration Management 10.2.1 - update information and list of fixes" which can be found athttps://www.novell.com/support