Hi,

We're running a 10.3.4 Primary Server (Win2k3) against an external SQL Server 2005 DB. We're hoping to upgrade the primary server to 11 SP2 and migrate our database from our 2005 server to a new SQL 2008 R2 server. When migrating the DB to the new server, we're running into issue with the Zen Server not being able to connect to the new DB server. The process I've followed is:

  1. Stop Zenworks Services
  2. Put database into read only mode
  3. Backup database, restore to new server (at level 90), set up security mappings, disable read-only mode
  4. Edit zdm.xml, dmaccount.properties and dmmappings.properties to point to new server
  5. Start Zenworks services, attemp to perform Zen 11 SP2 upgrade


However, we're running into issues with getting the Zenworks server to connect to the new DB server. Loader-messages.log shows the following error:

DEBUG] [4/4/12 11:16:30 PM] [] [Loader.DataModelModule] [] [Logging into the datamodel (try 1)] [] []

When I try to load Zenloader manually, I get the following output:

Loading EncodingStyleRegistry class to work around WSSDK deadlock.
4/4/12 10:44 PM DEBUG [Loader] The ZENworks service loader is loading the modules specified in: F:\Program Files\Novell\ZENworks\conf\loader
4/4/12 10:44 PM DEBUG [Loader] Module com.novell.zenworks.loader.modules.ExecutorModule is initialized.
0 [Module] WARN org.apache.log4j.config.PropertySetter - No such property [performanceFlag] in org.apache.log4j.Hierarchy.
0 [Module] WARN org.apache.log4j.config.PropertySetter - No such property [logStyle] in org.apache.log4j.Hierarchy.
4/4/12 10:44 PM DEBUG [Loader] Module com.novell.zenworks.loader.modules.LoggerModule is initialized.
[Loader.DataModelModule] Logging into the datamodel (try 1)
4/4/12 10:50 PM DEBUG [Loader] Module com.novell.zenworks.loader.modules.DataModelModule failed to initialize
4/4/12 10:50 PM DEBUG [Loader] com.novell.zenworks.loader.InitializationException
at com.novell.zenworks.loader.modules.DataModelModule .initialize(DataModelModule.java:127)
at com.novell.zenworks.loader.ZENModuleThread.run(ZEN ModuleThread.java:68)
Caused by: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.determineZoneUID(HibernateA bstractSession.java:1288)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession._postPasswordValidationInit ialize(HibernateAbstractSession.java:361)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAdministratorSession._postPasswordValidatio nInitialize(HibernateAdministratorSession.java:126 )
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.loginAsSystem(HibernateAbst ractSession.java:320)
at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.loginAsSystem(DirectServiceStoreImpl.j ava:196)
at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.loginAsSystem(DirectServiceStoreImpl.j ava:185)
at com.novell.zenworks.loader.modules.DataModelModule .eventCallback(DataModelModule.java:279)
at com.novell.zenworks.tess.eventsystem.EventThread.r un(EventThread.java:53)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection (ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCCont ext.java:118)
at org.hibernate.transaction.JDBCTransaction.begin(JD BCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(Se ssionImpl.java:1294)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateSessionImpl.newTransaction(HibernateSession Impl.java:30)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.beginTransaction(Abstra ctHibernateSessionImpl.java:84)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.determineZoneUID(HibernateA bstractSession.java:1257)
... 10 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtil s.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool. checkoutPooledConnection(C3P0PooledConnectionPool. java:615)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(AbstractPoolBackedDataSource.jav a:128)
at org.hibernate.connection.C3P0ConnectionProvider.ge tConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.jdbc.ConnectionManager.openConnectio n(ConnectionManager.java:417)
... 17 more

I've checked the usual suspects (ensuring the port is open etc, ensuring that the DB account being using has the right permissions etc) - I'm wondering if this is a valid upgrade scenario (i.e. moving the DB from a 2005 to a 2008 R2 server, rather than just updating the original DB server)?

Is there any other troubleshooting I can do with regards to getting Zenworks to connect to the DB correctly?