Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
External Oracle 10g R2 database
Situation
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 "
Resolution
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