Hi,

We have newly installed ZCM10 (installed 10.0.1 and upgraded to 10.0.2).
Server is W2K3 R2. Database is separate MS SQL2005 SP2. ZENworks is
installed in D:ZENworks. Inventory is not working correctly. Inventory
data is scanned in WS and sent to server, but Inventory cannot be viewed.
When inventory report is started from Control Center, it displays
different error messages depending on report that is run.

For example when running "Devices By Machine / Login Name", error message
is:
The data you requested is not available.

Details: Invalid column name 'isdeleted'.

When running "Duplicate Machine Names", error is:
The data you requested is not available.

Details: Invalid object name 'nc_workstation'.

NovellZENworkslogsinventory-servlet.log contains various error messages,
for example:

2008-01-23 15:47:45,860 ERROR inventory.ReportParams - Error in
getZCCdbConnection - caught DataModelException getting Store
2008-01-23 15:47:45,860 INFO inventory.ReportServerImpl - QueryJob
exception:
java.sql.SQLException: DB connection failed

Thanks,

Jukka