Hello All -

I am trying to migrate my Internal Sybase database to a SQL 2008 R2 database on an external server.

When I run through the following command: novell-zenworks-configure.bat -c DBMigrateConfigureAction it is able to successfully connect to the SQL server and it starts the migration. If I look on the SQL server, I see that it has successfully created the database and associated tables.

However, the migration fails with the following errors:
Code:
INFO: Novell ZENworks Service Monitor Stopped
INFO: Novell ZENworks Management Agent Stopped
INFO: Novell ZENworks Server Stopped
INFO: Novell ZENworks Loader Stopped
INFO: Creation of the tables is in progress...
INFO: The database has been successfully created.
SEVERE: Datamodel exception while getting db cofiguration
SEVERE: An error has occurred while migrating the database.
SEVERE: org.hibernate.exception.GenericJDBCException: Cannot open connection
com.novell.zenworks.configure.ConfigureException: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at com.novell.zenworks.configure.actions.db.DBMigrateConfigureAction.configure(DBMigrateConfigureAction.java:269)
        at com.novell.zenworks.configure.actions.db.DBMigrateConfigureAction.configure(DBMigrateConfigureAction.java:335)
        at com.novell.zenworks.configure.ZENworksConfigure.execConfigAction(ZENworksConfigure.java:1671)
        at com.novell.zenworks.configure.ZENworksConfigure.configure(ZENworksConfigure.java:1529)
        at com.novell.zenworks.configure.ZENworksConfigure.main(ZENworksConfigure.java:1448)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.novell.zenworks.configure.ConfigureLoader.main(ConfigureLoader.java:73)
Caused by: com.novell.zenworks.configure.ConfigureException: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConfiguration(DatabaseUpgradeUtils.java:237)
        at com.novell.zenworks.configure.actions.db.DBMigrateConfigureAction.configure(DBMigrateConfigureAction.java:213)
        ... 9 more
Caused by: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:org.hibernate.exception.GenericJDBCException: Cannot open connection
        at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.determineZoneUID(HibernateAbstractSession.java:1534)
        at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession._postPasswordValidationInitialize(HibernateAbstractSession.java:450)
        at com.novell.zenworks.datamodel.session.hibernate.HibernateAdministratorSession._postPasswordValidationInitialize(HibernateAdministratorSession.java:16
1)
        at com.novell.zenworks.datamodel.session.hibernate.HibernateAbstractSession.loginAsSystem(HibernateAbstractSession.java:409)
        at com.novell.zenworks.datamodel.services.DirectServiceStoreImpl.loginAsSystem(DirectServiceStoreImpl.java:224)
        at com.novell.zenworks.datamodel.services.DirectServiceStoreImpl.loginAsSystem(DirectServiceStoreImpl.java:213)
        at com.novell.zenworks.configure.ZENworksConfigure.getServiceStore(ZENworksConfigure.java:410)
        at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConfiguration(DatabaseUpgradeUtils.java:175)
        ... 10 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.determineZoneUID(HibernateAbstractSession.java:1503)
        ... 17 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:615)
        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)
        ... 24 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:1406)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)
I precreated the database on our SQL server and made sure to set compatibility to 90. I also performed the READ_COMMITTED_SNAPSHOT ON setting.

Any help would be greatly appreciated.

Thank you.