Cool Solutions

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


November 21, 2008 8:06 am





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.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized


Disclaimer: This content is not supported by Micro Focus. 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 it thoroughly before using it in a production environment.