Issue: unable to create groups, folders, admin (from user sources or in zcc)
Platform: Windows 2003 R2 SP3 Enterprise 32-bit
ZENworks Version: 10.1.1
Database: Oracle 10g database on separate server
Could not delete users sources;
Error: Object delete failed.: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.GenereicJDBCException: error performing bulk delete (all one line)
Click to view.
Creation error where a ZCC Administrator or a ZCC Administrator based from a User source could not be created, also creation of any folders, bundles, policies would get this error;
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.
Click to view.
Looking up farther in the exception the following is shown in the zcc.log:
Caused by: java.sql.SQLException: ORA-01536: space quota exceeded for tablespace 'ZCM'
It was determined that the tablespace was limited for the zcm database administrator user id. Enter a command to allow the zcmadmin user to have unlimited space in the zcm tablespace. The oracle command entered into the tablespace (allowing unlimited space for the zcm db username) was;
alter user zcmadmin quota unlimited on zcm
Explanation: the user zcmadmin can store any volume of data on the tablespace zcm. Afterwhich, ZCC functionality of creating/deleting/adding to ZCC was working again.
Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).
It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.