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

0 Likes
over 12 years ago

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.

Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended