I'm having a problem with ZEN dm 7 inventory. Sure hope someone can help..
Situation :
4 node NW OES SP4 cluster. 2 nodes for ZEN. ZEN files are on cluster
volume. Customer was using a Sybase database which worked fine but wants
to switch to MS SQL. We added a database on a Windows 2003 MS SQL server
following the ZEN7 documentation.
Made a new database object and configured with the IP address of the SQL
box, added MW_DBA, MWM_READER, and MWM_UPDATER users with
password "novell". Configurd JDBC with standard SQL settings.
Made a new server policy which points to the new database object.
Downloaded the jdbc driver for sql2000, extracted msbase.jar, msutil.jar
and mssqlserver.jar and copied these to the zen cluster volume in
\ZENworks\Inv\server\lib ( plus a few other lib dir's to be sure :) )
Restarted the ZEN cluster resource.Everything starts, except for inventory.
I see the error class
com.novell<blahdiblah>zenworksinventoryservicemana ger exited with status -1
I THINK I have everything configured correctly, but I guess I must have
missed something somewhere... :(
If anyone can give me any clue I'd be mighty grateful...

Here's the error in the inventory log file ( can provide the full log if
you want ) :

[12/21/05 10:33:18.373] ZENInv - Server Config: The
networkAddresscom.novell.zenworks.desktop.inventor y.zencommon.DirectoryAttr
[12/21/05 10:33:18.375] ZENInv - Server Config: The Address10.68.16.21
[12/21/05 10:33:18.375] ZENInv - Server Config: Database used is type2
[12/21/05 10:33:18.375] ZENInv - Server Config: dbURL is:
[12/21/05 10:33:18.384] ZENInv - Server Config:
at java.net.URLClassLoader$1.run(URLClassLoader.java: 199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 89)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 35)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
com.novell.zenworks.desktop.inventory.servercommon .DatabaseConnectivity.che
com.novell.zenworks.desktop.inventory.servercommon .ServerConfig.checkDataba
com.novell.zenworks.desktop.inventory.servercommon .ServerConfig.getConfigur
com.novell.zenworks.desktop.inventory.servercommon .ServerConfig.start
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
at sun.reflect.DelegatingMethodAccessorImpl.invoke
at java.lang.reflect.Method.invoke(Method.java:324)
at com.novell.utility.servicemanager.LoaderThreadGrou p._run
at com.novell.utility.servicemanager.LoaderThreadGrou p.run
at java.lang.Thread.run(Thread.java:534)

[12/21/05 10:33:18.387] ZENInv - Server Config: Got a
ZENDatabaseConnectivityException Error connecting to the db:
[12/21/05 10:33:18.401] ZENInv - Server Config: Please check the database
object and also the jdbc/ odbc driver classes
[12/21/05 10:33:18.402] ZENInv - Server Config: The
getConfigurationFromDirectory() returned622
[12/21/05 10:33:18.412] ZENInv - Server Config: Inv Server not configured
properly. Error code: 622
[12/21/05 10:33:18.413] ZENInv - Server Config: Error Type 15 Error 622
[12/21/05 10:33:18.532] ZENInv - Status Reporting: Messages are written
into XML file for DN=CN=CS-ZEN_ZenInvService.OU=Cluster.OU=Mchlan.O=Mch

thanks for any help, Ren