Unable to Create/Add Objects (folders/groups/bundles/user sources) in ZCC


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.


How To-Best Practice
Comment List