ZCM install returns error creating admin user for MS SQL database.

  • 7003515
  • 11-Jun-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2

Situation

Error:  Could not create the admin user, message:  User does not have permission to perform this action.

Error:  ConfigureAction failed!: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:136) at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.doWork(ZoneCreator.java:188) at com.novell.zenworks.datamodel.utils.hibernate.ZoneCreator.main(ZoneCreator.java:529) Caused by: com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: Cannot open connection at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:417) at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177) at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:544) at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession._postPasswordValidationInitialize(HibernateAbstractSession.java:342) at com.novell.zenworks.datamodel.session.hibernate.HibernateAdministratorSession._postPasswordValidationInitialize(HibernateAdministratorSession.java:125) at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.loginAsSystem(HibernateAbstractSession.java:320) at com.novell.zenworks.datamodel.services.DirectServiceStoreImpl.loginAsSystem(DirectServiceStoreImpl.java:196) at com.novell.zenworks.datamodel.temp.ZoneCreator.getServiceStore(ZoneCreator.java:182) at com.novell.zenworks.datamodel.temp.ZoneCreator.createZone(ZoneCreator.java:96) .. 2 more Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:118) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1294) at com.novell.zenworks.datamodel.session.hibernate.HibernateSessionImpl.newTransaction(HibernateSessionImpl.java:30) at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.beginTransaction(AbstractHibernateSessionImpl.java:84) at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.createDefaultFolders(HibernateAbstractSession.java:507) .. 8 more Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417) .. 15 more Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525) .. 18 more

Resolution

Install to a SQL 2005 database.   See the ZCM 10.2 documentation for Database System Requirements.  This error was received when attempting the ZCM install to a SQL 2000 database.