Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Microsoft Windows Server 2003 Enterprise Edition
Oracle 10g
Microsoft Windows Server 2003 Enterprise Edition
Oracle 10g
Situation
Unable to Create or Add Objects such as folders, groups, bundles or user sources in ZCC
Error: Object delete failed.: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.GenereicJDBCException: error performing bulk delete
Error: Cannot create the administrator for the following reasons;; org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update. See the ZENworks Control Center log file (zcc.log) for the full stack trace
Error: Object delete failed.: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.GenereicJDBCException: error performing bulk delete
Error: Cannot create the administrator for the following reasons;; org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update. See the ZENworks Control Center log file (zcc.log) for the full stack trace
Resolution
On the Oracle database, enter the command below that allows unlimited space fro the zcm db username:
alter user zcmadmin quota unlimited on zcm
alter user zcmadmin quota unlimited on zcm
Additional Information
See this Cool Solution for more details.
The alter user command above should only need to be used in instances where "Existing User schema" was selected during the ZENworks install.
The alter user command above should only need to be used in instances where "Existing User schema" was selected during the ZENworks install.