Database upgrade fails at during SoftwareUsageHistory script

  • 3319149
  • 02-Feb-2007
  • 27-Apr-2012


Novell ZENworks 7 Asset Management - ZAM7
Novell ZENworks 7.5 Asset Management - ZAM7.5


If the upgrade fails and DBUpgrade log is checked you will see this entry as the line

Executing script .\sql\mssql7\tsc_upg_0750_msq_03_AlterData.sql...

Changing ZENWorks Asset Management data...

Setting initial values for NC_ProcessData.WebDefinitionBuildState.

Setting initial values for NC_SoftwareUsageHistory.IsServerUsage, SourceDevice, RemoteWorkstationOID.


The SQL transaction log file gets very large during this portion of the ZAM upgrade. Increase the log space to accomodate the transaction for the upgrade.
Once that is done you will need to restore the database and retry the upgrade.