Hi!

Trying to upgrade our ZCM zone (2 Linux primaries and MS SQL 2008 R2) but the upgrade fails with this in the err.log:

Exception while upgrading database schema.
[2015.10.28-14:36:26] FINER: Setting schema version in DB.
[2015.10.28-14:36:27] FINER: DatabaseUpgradeConfigureAction: getConnection
[2015.10.28-14:36:27] FINER: Upgrading database schema.
[2015.10.28-14:37:42] SEVERE: Exception while upgrading database schema.
com.novell.zenworks.systemupdate.exceptions.System UpdateException: Failed to verify DB state
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDBDetails(PreGlobalAction.java:645)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.execute(PreGlobalAction.java:144)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:190)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:225)
Caused by: java.io.FileNotFoundException: /etc/opt/novell/zenworks/datamodel/zenaudit.xml (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDatabaseTypeHelper(PreGlobalAction.java :736)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDBDetails(PreGlobalAction.java:633)
... 3 more
@FAILED@com.novell.zenworks.systemupdate.exception s.SystemUpdateException: Failed to verify DB state
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDBDetails(PreGlobalAction.java:645)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.execute(PreGlobalAction.java:144)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.configure(ExecutePreGlobalConf igureAction.java:190)
at com.novell.zenworks.configure.actions.ExecutePreGl obalConfigureAction.main(ExecutePreGlobalConfigure Action.java:225)
Caused by: java.io.FileNotFoundException: /etc/opt/novell/zenworks/datamodel/zenaudit.xml (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDatabaseTypeHelper(PreGlobalAction.java :736)
at com.novell.zenworks.systemupdate.v_11_4_0.PreGloba lAction.getDBDetails(PreGlobalAction.java:633)
... 3 more

The file zenaudit.xml certainly is missing. In the database there exists a zen_audit_ESN database. I also wonder where the configuration details for the database can be found in the ZCC. Like IP-address and credentials used by the ZENWorks system. Remember I've been looking for them before but I don't remember whether I found them or not.