Oracle SQL Drop / Create / Index errors in pre-global-actions.log when deploying 11.3.1 to first Primary server in the Zone

  • 7015521
  • 13-Aug-2014
  • 20-Dec-2014

Environment

Novell ZENworks Asset Management
Novell ZENworks Configuration Management
Novell ZENworks Endpoint Security Management
Novell ZENworks Full Disk Encryption
Novell ZENworks Patch Management

Situation

Error in the PRE-GLOBAL-ACTIONS.LOG when deploying ZCM 11.3.1 to the first Primary Server in the Zone after the 11.3.1 import is in 'Downloaded' state:
 
' com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Error executing SQL: -- Drop and Create Unique key skipping SyncState column '
 
' java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key '

Resolution

This is fixed in version 11.3.2 - see KB 7015776 "ZENworks Configuration Management 11.3.2 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7015776