Random Errors deleting some objects from Oracle database using ZCC

  • 7003274
  • 14-May-2009
  • 27-Apr-2012


Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
External Oracle 10g R2 database


Deleting objects in ZCC:
ERROR: "Unable to delete object.: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.GenericJDBCException: error performing bulk delete "
ERROR (from zcc.log): "java.sql.SQLException: ORA-00036: maximum number of recursive SQL levels (50) exceeded "


This is fixed in version 10.3 - see KB 7005455 "ZENworks Configuration Management SP3 (10.3) - update information and list of fixes" which can be found at https://www.novell.com/support